FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO INSERT HEADERS FOOTERS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
A formula using the ____ cell reference B4 instructs Excel to adjust the cell reference as it copies it to the destination area.
A
mixed
B
invalid
C
relative
D
absolute
Explanation: 

Detailed explanation-1: -The dollar sign in an Excel cell reference affects just one thing-it instructs Excel how to treat the reference when the formula is moved or copied to other cells. In a nutshell, using the $ sign before the row and column coordinates makes an absolute cell reference that won’t change.

Detailed explanation-2: -If you copy a formula 3 rows down and 1 row left, then the cell references in the formula will shift 3 rows down and 1 row left. These are called “relative” cell references, since they change relative to where you copy the formula.

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.

There is 1 question to complete.
Previous
Next