Administrative Professional (CAP) · Question
In Microsoft Excel, what is the purpose of using absolute references (e.g., $A$1) in formulas?
Absolute references ($A$1) ensure that the cell reference does not change when the formula is copied or filled to other cells.
Start free practice for Administrative Professional (CAP)
200 questions · no signup required · 40 free questions per day
Question: In Microsoft Excel, what is the purpose of using absolute references (e.g., $A$1) in formulas?
Answer options: ✅ To keep a cell reference constant when copying a formula.
- To automatically adjust cell references when moving a formula.
- To format the cell with a specific currency.
- To hide the cell reference from other users.
Correct answer: To keep a cell reference constant when copying a formula.
Explanation: Absolute references ($A$1) ensure that the cell reference does not change when the formula is copied or filled to other cells.
Start free practice for Administrative Professional (CAP)
200 questions · no signup required · 40 free questions per day
More about Administrative Professional (CAP)
Related Questions
- Which tab in Microsoft PowerPoint is used to apply predefined animation effects to individual objects on a sli
- When writing an internal memo, what tone is generally most appropriate?
- What is the primary purpose of a 'register' in records management?
- Which of the following is an example of an open-ended question?
- What is the purpose of using 'track changes' in Microsoft Word?
- In Microsoft PowerPoint, what feature allows you to display your slides on a projector while viewing your note
More for Administrative Professional (CAP) candidates
FAQs
Question explanations
- Which tab in Microsoft PowerPoint is used to apply predefined animation effects to individual objects on a sli
- When writing an internal memo, what tone is generally most appropriate?
- What is the primary purpose of a 'register' in records management?
- Which of the following is an example of an open-ended question?
Ready to practice?
Free, no signup required. Build a wrong-question list as you go.
Start Free Administrative Professional (CAP) Practice →Related courses
Other Canadian certifications candidates often prepare for alongside this one.