ICSE Class 8 Computer Studies Question 3 of 6

Spreadsheet - Formulas and Functions — Question 3

Back to all questions
3
Question

Question 3

What do you know about Absolute Reference? Explain with the help of an example.

Answer

Absolute reference is used when we do not want to change the address of the cell while copying the formula to another cell. To use absolute reference in a cell, you need to add dollar ($) sign before the column and row number. For example: =$A$1+$A$2