Page 20 - 2616_V iCode_C-5

Formula Bar

Formula bar is a box located on the right side of the Name box that allows you to

enter and edit formulas and perform calculations on your worksheet data. It is also
used for entering and editing the content on the cells.

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.

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 the letters 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
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 A2.

Active Cell

The currently selected cell that appears highlighted with the green border is 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.

18 Premium Edition-V