Case 13-1
Jim is copying and pasting formulas from one area of a worksheet to another. Please answer the questions below.
-In several areas of the worksheet, Jim uses absolute references.The correct format for an absolute reference is ____.
A)$C3
B)$C$3
C)C3$
D)C3

Question

Quizplus · Accepted Answer

The correct format for an absolute reference includes putting a dollar sign ($) before both the column letter and row number, such as $C$3. This will ensure that the reference will not change if copied or moved to another location in the worksheet.

Case 13-1 Jim Is Copying and Pasting Formulas from One Area of Area