USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Absolute
|
|
|
Relative
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -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-2: -A cell reference in Excel is always relative (like D2), which means it changes when the formula is duplicated. A cell reference can be blended in addition to absolute and relative. In a mixed reference, either the column name or the row number (such as $D2 or D$2) remains constant.
Detailed explanation-3: -Relative referencing is the default. So, for example, whenever you extend a formula down some cells, the cells change based on the relationships of the rows and columns.
Detailed explanation-4: -Relative cell references are basic cell references that adjust and change when copied or when using AutoFill. Example: =SUM(B5:B8), as shown below, changes to =SUM(C5:C8) when copied across to the next cell.