USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
relative reference
|
|
|
absolute reference
|
|
|
comparative reference
|
|
|
virtual reference
|
Detailed explanation-1: -When copied across multiple cells, they change based on the relative position of rows and columns. For example, if you copy the formula =A1+B1 from row 1 to row 2, the formula will become =A2+B2.
Detailed explanation-2: -These are called “relative” cell references, since they change relative to where you copy the formula.
Detailed explanation-3: -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-4: -Here is what happens when you select the reference and press the F4 key. Press F4 key once: The cell reference changes from A1 to $A$1 (becomes ‘absolute’ from ‘relative’). Press F4 key two times: The cell reference changes from A1 to A$1 (changes to mixed reference where the row is locked).
Detailed explanation-5: -A relative cell reference in a formula will not change when the formula is copied. By default, when a cell reference is first included in a formula (so that only the column and row reference are included), it is displayed as a relative cell reference.