Which of the following is an absolute cell reference?

Question

BlackTom AI · Accepted Answer

Absolute cell references use a dollar sign ($) before both the column letter and the row number (for example, $A$1) to lock that exact cell when a formula is copied or filled.

1) Relevant knowledge points and concepts
- In spreadsheet notation (Excel, Google Sheets) a dollar sign fixes (makes absolute) the column, the row, or both.
- $A$1 means the column A and row 1 are both absolute (neither changes when copied).
- A mixed reference like A$1 fixes only the row; $A1 fixes only the column.
- Plain A1 is a relative reference and will shift when copied.

2) Step-by-step reasoning
- Examine each option for where the $ appears:
  a. K$9 → $ before 9 only: row is absolute, column K is relative (mixed).
  b. $K9 → $ before K only: column is absolute, row 9 is relative (mixed).
  c. $K$9 → $ before K and before 9: both column and row are absolute.
  d. K9 → no $ signs: both column and row are relative.

3) Calculations / intermediate steps
- No numeric calculations required; the “intermediate steps” are the identification of the presence/absence of $ for column and row:
  - a: column K (no $) = relative; row 9 ($) = absolute → mixed
  - b: column K ($) = absolute; row 9 (no $) = relative → mixed
  - c: column K ($) = absolute; row 9 ($) = absolute → absolute
  - d: column K (no $) = relative; row 9 (no $) = relative → relative

4) Why the correct answer is correct
- Option c ($K$9) has a $ before the column letter and a $ before the row number, so both parts are fixed. That is the definition of an absolute cell reference.

5) Why the other options are incorrect
- a (K$9) and b ($K9) are mixed references (only one coordinate fixed).
- d (K9) is a fully relative reference (neither coordinate fixed).

6) Conclusion
- Therefore the absolute cell reference is option c: $K$9, which matches the provided correct answer.

Which of the following is an absolute cell reference?单项选择题

类似问题

Fahdi has autofilled a formula down in the Discount column to show the discount for each Member Type but is getting an error message. What is the problem?