DATABASE FUNDAMENTALS
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
E44 is an example of a ____
|
|
Cell Reference
|
|
|
Formula Bar
|
|
|
Active Cell
|
|
|
Formula
|
Explanation:
Detailed explanation-1: -E44 is an example of a cell pointer, also called a cell address.
Detailed explanation-2: -A cell reference or cell address is a combination of a column letter and a row number that identifies a cell on a worksheet. For example, A1 refers to the cell at the intersection of column A and row 1; B2 refers to the second cell in column B, and so on.
Detailed explanation-3: -A$7 – relative column, absolute row.
Detailed explanation-4: -C$6 says the column reference is relative but the row is always row 6.
There is 1 question to complete.