Page 59 - iPlus_Ver_2.0_class_7
P. 59

Title Bar

                 Title bar lies at the top of the window screen. It displays the name of the active workbook. When
                 the spreadsheet is newly created, by default it is named as Book1, second is Book2 and so on.
                 Quick Access Toolbar

                 Quick Access Toolbar is present on the title bar. It displays quick access buttons of the Save,
                 Undo and Redo commands.

                 File Tab

                 A green button located below the Quick Access Toolbar contains the file menu commands such
                 as New, Open, Save, etc.
                 Ribbon

                 Ribbon is like a strip that has various tabs such as Home, Insert, Page, Layout, Formulas, and
                 Data. These tabs consist of different groups that contain related commands.
                 Name Box

                 Name box is a box located on the left side of the Excel window, just below the Ribbon. The

                 address of the active cell is displayed in this box.
                 Formula Bar

                 Formula bar lies below the Office Ribbon. Formula that performs different calculations in cells is
                 entered and displayed here. It is denoted by ‘fx’.
                 It is used for entering and editing the formula in the cell. Formula bar consists of:

                 Name box: displays the cell reference, for example A1 or D10.
                 Function: It lets you click on the Function icon and inserts an equals (=) sign into the selected
                 cell.
                 Input line: It displays the contents of the selected cell (data, formula, or function). It allows

                 editing of the the cell contents. Click in the area, then type the changes. To edit within the current
                 cell, just double-click in the cell.
                 Cell Pointer

                 The active cell in a worksheet is known as the Cell Pointer. It remains highlighted with bold
                 border in the active worksheet.
                 Active cell: The selected or activated cell is referred to as active cell which is always highlighted,
                 with a thick border. The address of the active cell is displayed in the name box for example A1. In
                 a spreadsheet, active cell is the place where data is entered. Before entering any data in the cell,
                 it has to be first selected by placing a cursor on it. When we position the mouse cursor on a cell,
                 it gets selected, and is ready to take data from the user or do editing.
                 Cell Address


                 Each  cell  has  a  unique  address  which  identifies  its  location.  A  cell  address  is  identified  with
                 its column position followed by its row number, for example: ‘A5’ is the cell address that is a
                 combination of column ‘A’ and row ‘5’.


                                                                                                                  57
                                                                                  Spreadsheets—An Introduction
   54   55   56   57   58   59   60   61   62   63   64