USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
4A
|
|
|
A4
|
|
|
A16:A29
|
|
|
None of the above
|
Detailed explanation-1: -The correct answer is Mixed cell Reference.
Detailed explanation-2: -Cell address a4 in a formula means it is a mixed reference. A mixed reference is made up of both an absolute reference and relative reference. This means that part of the reference is fixed, either the row or the column, and the other part is relative.
Detailed explanation-3: -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-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.
Detailed explanation-5: -Hence, we conclude that Addressing a cell as $A$4 is called Absolute Addressing.