Asked by Melissa Washburn on Apr 28, 2024
Verified
Your worksheet contains a price in cell A5, and many formulas refer to that price.How would you refer to that price in the formulas?
A) A5
B) $A$5
C) $A5
D) A$5
Absolute Cell Reference
In spreadsheet applications, an absolute cell reference is a cell address that does not change when copied or moved to another cell location.
- Familiarize with the dynamics of how relative and absolute references in formulas are modified when they are copied or shifted.
Verified Answer
ZK
Zybrea KnightMay 04, 2024
Final Answer :
B
Explanation :
By using the absolute reference with the dollar sign in front of both the column and row reference ($A$5), we can ensure that the formula will always refer to cell A5 regardless of where it is located in the worksheet.
Learning Objectives
- Familiarize with the dynamics of how relative and absolute references in formulas are modified when they are copied or shifted.