Electronic Spreadsheet using LibreOffice Calc · Class 9 · CBSE Information Technology (402)
Which of the following cell references is an example of an absolute cell reference?
Practice question from Electronic Spreadsheet using LibreOffice Calc (Class 9 · CBSE Information Technology (402)), with the correct answer and a step-by-step solution.
medium · MCQ · Q-7F8BDB
Which of the following cell references is an example of an absolute cell reference?
- A.A1
- B.1Correct answer
- C.$A1
- D.A$1
Solution
An absolute cell reference uses dollar signs before both the column letter and row number (e.g., 1) to keep the reference fixed when the formula is copied to another cell.
More from Electronic Spreadsheet using LibreOffice Calc
- What is the default extension of a workbook saved in LibreOffice Calc?
- Which symbol must every formula begin with in LibreOffice Calc?
- What is the primary function of the Scenario tool in LibreOffice Calc?
- Which feature in LibreOffice Calc allows a user to combine data from multiple worksheets or ranges into a single master summary range?
Practise more Information Technology (402)
Sign up free for adaptive practice on this chapter, with instant feedback and hints on every question.
Start practising freeFree to start · No credit card needed