Page 29 - modular4.0
P. 29

Chapter Profile
                        COMPONENTS OF EXCEL 2019


                 Following are the components of Excel 2019 window:

                     Title Bar: It is located on the top of the window that shows the name of the current workbook.

                     File Tab: A green button located at the left top corner that contains the file menu commands
                    such as New, Open, Save, etc.

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

                                   Quick Access Toolbar
                                                                   Title Bar              Control buttons

                            File tab

                                                                                                           Ribbon
                         Name box
                                                                                                            Formula
                      Highlighted                                                                             bar
                       headings                                           Column
                                             Active Cell
                                                                          Heading
                  Worksheet Window

                                                                                        Mouse Pointer
                                                                   Cell
                      Row Heading

                                         Worksheet Tab
                     Worksheet tab
                    scrolling buttons
                                    Status bar              Components of Excel 2019
                     Formula Bar: It is used to enter and edit formulas and perform calculations on the data present
                    in your worksheet. It is also used for entering and editing the all contents.
                    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 shows various 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.

                     Column: The vertical divisions on a worksheet are called columns. There are 16,384 columns in
                    an Excel worksheet.
                     Row and Column Heading: The work area is divided into rows and columns. The rows are
                    referred 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 appears a
                    rectangular box.

                     Active Cell: The currently selected cell that appears highlighted with green border is an active
                    cell. The data is entered in an active cell.



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