ICSE Class 8 Computer Studies Question 2 of 6

Spreadsheet - Formulas and Functions — Question 2

Back to all questions
2
Question

Question 2

What is Cell Reference? Mention its types.

Answer

The cell address that we use in the formula is known as the cell reference. The address of the cell consists of the column letter followed by the row number. For example, cell address A1 denotes the column name as A and the row number as 1. The different types of cell references are Relative reference, Absolute reference and Mixed reference.