Page 62 - TP_iPlus_V2.1_Class7
P. 62

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. The Zoom button on the status bar are
                  used to adjust the magnification level of the worksheet.
                  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.
                  Quick Byte

                  A cell range in Excel refers to a group of two or more cells. There are two types: Contiguous Cell
                  Range, where cells are next to each other and specified with a colon (e.g., A1), and Non-Contiguous
                  Cell Range, where cells are not adjacent and specified with commas (e.g., A1, B1, C3).
                  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.
                  Workbook


                  An Excel file is called a workbook. It is a collection of different worksheets. By default, a workbook
                  contains only one worksheet, Sheet1. The number of worksheets can be increased as per the
                  requirement.




                    60
                         iPlus (Ver. 2.1)-VII
   57   58   59   60   61   62   63   64   65   66   67