DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Column heading
|
|
|
Row heading
|
|
|
Cell
|
|
|
Cell reference
|
Detailed explanation-1: -A cell reference is the set of coordinates that a cell occupies on a worksheet. It identifies the location of a cell in the spreadsheet. A cell reference is always the column letter followed by the row number. For example, the first cell in the top left-hand corner of a worksheet is cell A1.
Detailed explanation-2: -Rows are referenced by numbers that appear on the left and then run down the Excel screen. The first row is named row 1, while the last row is named 65536.
Detailed explanation-3: -A row header is the column at the left of the table that identifies each row within the table. Row headers are needed if the cells in a column identify the contents of the row, in effect providing a label for the row. These labels are often a key or ID column for the rest of the data.
Detailed explanation-4: -Labels: Labels refer to text that is typed into the cells of a spreadsheet. Labels have no numeric value and cannot be used in a formula or function..