DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Column
|
|
|
Row
|
|
|
Range
|
|
|
Column Heading
|
Detailed explanation-1: -A range is a block of cells that can be selected manipulated named or formatted as a group. The row headings are the gray boxes containing sequential numbers along the left side of the worksheet. They can be used to select or identify a row.
Detailed explanation-2: -RANGE. A range is a group of two or more cells in a worksheet. The cells in a range can be adjacent or nonadjacent. Commands executed by Excel will affect the entire range. A range is identified by the cell references of the cells in the upper left and lower right corners of the range.
Detailed explanation-3: -Range: A range is a group of cells in a spreadsheet that have been selected. If the cells are all together in a rectangular or square shape, it is an adjacent range. An adjacent range is identified by the cell reference in the upper left and lower right corners of the selection separated by a colon. (Example: A3:B5).
Detailed explanation-4: -Defined name-a name that refers to a single cell, range of cells, constant value, or formula. For example, when you define a name for a range of cells, it’s called a named range, or defined range.