Workbook, Worksheet, Cell, Cell Reference Short Notes | Grade 11

Components of Spreadsheet/Worksheet

Workbook:

Workbook is a file created using spreadsheet software. It contains different worksheets.

Worksheet:

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.

Cell:

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:

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:

  1. 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.

  2. 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.

Comments

comments

Hemant

Hemant Chaudhary is an student 19 years old. He is interested in Hacking, Blogging,coding. He like to Visit new Places and make new Friends. He used to Learn His web works From Friends and Currently is is CEO and Founder of Meropaper and meroreview.com