Page 29 - TP_Modular_V2.1_Class7
P. 29

Ribbon: This bar has tabs with group of related commands displayed on it.
                                 Quick Access Toolbar             Title Bar              Control Buttons


                        File Tab
                                                                                                          Ribbon
                       Name Box
                                                                                                         Formula
                                                                                                         Bar
                     Highlighted
                       Headings                                        Column
                                            Active Cell
                                                                       Heading
                      Worksheet                                                                          Column
                        Window
                                                                           Row
                                                           Cell                                           Workbook
                    Row Heading       Worksheet
                                         Tab                                                             Mouse
                                                                                                         Pointer
                      Worksheet
                    Tab Scrolling
                         Buttons
                                    Status Bar           Components of Excel 2016


                    Formula Bar: It is used to enter and edit formulas in a cell and perform calculations on your
                    worksheet data. It is also used for entering and editing the contents of a cell.
                    Name Box: The address of the active cell is displayed in this box.
                    Worksheet Window: It is a single page in Excel also called spreadsheet.

                    Status Bar: The horizontal bar at the bottom that shows information about the file in which you
                    are working. The right section of the status bar has view control buttons for the spreadsheet.
                    Row: The horizontal divisions on a worksheet are called rows. There are 10,48,576 rows in an

                    Excel worksheet. Each row is represented by a number such as 1, 2, 3, and so on.
                    Column: The vertical divisions on a worksheet are called columns. There are 16,384 columns in
                    an Excel worksheet. Each column is represented with alphabetic value such as A, B, C and so on.
                    Row and Column Heading Buttons:  Work  area  is divided  into  rows  and  columns.
                    The rows are reffered using numbers and columns using the alphabets. The row headings

                    range from 1 to 10,48,576 and column headings range from A to XFD.
                    Cell: The intersection of a row and a column is called a cell. A cell in Excel worksheet looks
                    like a rectangular box.

                    Active Cell: A cell is formed by the intersection of a row and a column. The currently selected
                    cell that appears highlighted with green border is an active cell. The data we type is entered
                    in an active cell.
                    Mouse Pointer:  The mouse pointer is displayed as a block plus sign ( ), whenever it is
                    located in a cell on the worksheet. Another common shape of the mouse pointer is the block
                    arrow.

                    Worksheet Tab: There can be more than one worksheet in Excel workbook and each has a
                    specific name. Any worksheet can be activated by clicking on its name in worksheet tab.


                                                                                  Introduction to Excel 2016      27
   24   25   26   27   28   29   30   31   32   33   34