USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
A3 is an example of a cell’s address
|
|
true
|
|
|
false
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -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-2: -2. The Name box shows the data that you enter in an active cell.
Detailed explanation-3: -A3 is an example of relative reference to a cell in excel.
Detailed explanation-4: -You can use the ADDRESS function to obtain the address of a cell in a worksheet, given specified row and column numbers. For example, ADDRESS(2, 3) returns $C$2. As another example, ADDRESS(77, 300) returns $KN$77.
There is 1 question to complete.