USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
related
|
|
|
relative
|
|
|
pasted
|
|
|
alternative
|
Detailed explanation-1: -These are called “relative” cell references, since they change relative to where you copy the formula. If you do not want cell references to change when you copy a formula, then make those cell references absolute cell references.
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: -A relative reference in Excel is a cell address without the $ sign in the row and column coordinates, like A1. When a formula with relative cell references in copied to another cell, the reference changes based on a relative position of rows and columns.
Detailed explanation-4: -By default, all cell references are relative references. 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-5: -The automatically adjusted cell reference in a pasted formula is called a (n) relative reference.