USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What type of formula cell reference instructs Microsoft Excel to keep the cell reference constant in the formula as it copies it to the destination area?
|
|
Relative
|
|
|
Mixed
|
|
|
Absolute
|
|
|
Unconditional
|
Explanation:
Detailed explanation-1: -In Excel, an absolute reference is a cell reference in which the column and row coordinates stay constant while copying a formula from one cell to the other.
Detailed explanation-2: -Absolute Cell Reference(Keeping value constant in an excel formula) When you want certain cell reference to remain unchanged or want to keep a value constant, that is the time you will have to use absolute cell reference.
Detailed explanation-3: -When you are typing your formula, after you type a cell reference-press the F4 key. Excel automatically makes the cell reference absolute! By continuing to press F4, Excel will cycle through all of the absolute reference possibilities.
There is 1 question to complete.