Page 60 - iPlus_Ver_2.0_class_7
P. 60
Worksheet
A worksheet is the main working area in an Excel window where we can enter data. It consists of
rows and columns. It is also known as a spreadsheet.
Worksheet Tabs
There can be more than one worksheet in Excel, and each has a specific name. Any worksheet
can be activated by clicking on the worksheet tab. These tabs are located at the bottom-left of
the Excel window as Sheet1, Sheet2, Sheet3 and so on.
Worksheet Tab Navigation Buttons
Worksheet tab navigation buttons are located on the left side of the worksheet tabs. These are
used to move from one worksheet to another in a workbook. We can also directly click on the
worksheet tab to make it active.
Status Bar
The horizontal bar at the bottom, which shows various information about the file on which you
are working is called the Status bar. The right section of the status bar has view control buttons
such as Normal and Page Layout for the spreadsheet.
Row
The horizontal divisions in a worksheet are called rows. There are 10,48,576 rows in an Excel
worksheet. Rows are numbered from top to bottom along the left edge of the worksheet as
1, 2, 3, ... .
Column
The vertical divisions in a worksheet are called columns. There are 16,384 columns in an Excel
worksheet. Columns are labelled from left to right with letters such as A, B, C, D, ... .
Row and Column Heading
The row heading is the grey-coloured number (1, 2, 3, etc.) located in front of each row in
the worksheet. On the other hand, the column heading is the grey-coloured alphabet letter
(A, B, C, etc.) located at the top of each column. The row headings range from 1 to 10,48,576 and
the column headings range from A to XFD.
Cell
The intersection of a row and a column is called a cell. A cell in an Excel worksheet looks like
a rectangular box. Every cell in the worksheet has an address, which is called a cell address. A
cell address is a combination of a column heading and a row heading. For example, a cell in the
second row of column A has the cell address as A2.
Active Cell
The currently selected cell that appears highlighted with a dark black border is an active cell. The
data is entered in an active cell.
Mouse Pointer
The mouse pointer is displayed as a block plus sign ( ), whenever we move over a cell in a
worksheet. Another common shape of the mouse pointer is the block arrow.
58
iPlus (Ver. 2.0)-VII

