USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
A revolving cell address.
|
|
|
A relative cell address
|
|
|
A fixed cell address.
|
|
|
An absolute cell address.
|
Detailed explanation-1: -Which type of cell address will be adjusted in the new location based on the relative position of the original formula’s input cells? A revolving cell address.
Detailed explanation-2: -By default, a cell reference is a relative reference, which means that the reference is relative to the location of the cell. If, for example, you refer to cell A2 from cell C2, you are actually referring to a cell that is two columns to the left (C minus A)-in the same row (2).
Detailed explanation-3: -Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant, no matter where they are copied.
Detailed explanation-4: -If you want to maintain the original cell reference when you copy it, you “lock” it by putting a dollar sign ($) before the cell and column references. For example, when you copy the formula =$A$2+$B$2 from C2 to D2, the formula stays exactly the same. This is an absolute reference.