Components of Spreadsheet/Worksheet
Workbook is a file created using spreadsheet software. It contains different worksheets.
The actual working area of workbook is called worksheet. A workbook allows to add or remove the worksheets. A worksheet contains different cells made by rows and columns. There are 3 worksheets by default in a MS-Excel workbook and each worksheet contains 256 columns and 65,536 rows.
A cell is the intersection between row and column. It is the actual location to enter and store data in spreadsheet software. Each cell is identified by its unique name called cell address or cell reference.
Cell reference is the name of cell made by column label and row number. Example: A1, IV65536, etc.
There are 2 types of cell reference. They are:
Relative cell reference:
It is the cell reference made by column label and row number only. It changes its value while using in formula or copying to another place. Example:- A1, IV65536, etc.
Absolute cell reference:
It is the cell reference which is written with ‘$’ sign. It doesn’t change its value while using in formula or copying to another place. Example: $A$1, $IV$65536, etc.
Any one or two of these usually comes in Grade 11 Final Examination of Computer Science. Cell reference is very important among these. So, it needs to preferred while studying.