Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 20 - 2616_V iCode_C-5
P. 20

    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

| 15 16 17 18 19 20 21 22 23 24 25 |