Question

1.10 To change the cell reference C4:C9 to an absolute cell reference, you would enter it as

A) C4:C9

B) C$4:C$9

C) $C$4:$C$9

D) None of the above​

Answer 1

Answer:

D. none of the above

all string formats are wrong

Answer 2

Answer:

To change the cell reference C4:C9 to an absolute cell reference, you would enter it as $C$4:$C$9.

Explanation:

Absolute cell references

• Absolute cell references are those that don't change when a cell is moved, copied, or filled.
• Thus, regardless of where a cell appears in the worksheet, the reference always links back to the same cell.
• A dollar sign in the column or row coordinates serves as the indicator.

• For instance, the formula will become = B1+B2 if you enter = A1+A2 into A3 and duplicate it to another location: B3.

• For adding absolute cell references to your calculations, there is a shortcut available.
• Press the F4 key to continue typing your formula after entering a cell reference.
• The cell reference is automatically made absolute by Excel! Excel will cycle through each possible absolute reference by pressing F4 repeatedly.

#SPJ2