Page 43 - CloudGPT_C5_Flipbook
P. 43

COMPONENTS OF EXCEL 2019 WINDOW

                 The basic components of Excel 2019 window are given below. Let us read about them.

                              Quick Access Toolbar             Title bar


                         File tab
                                                                                                       Ribbon
                      Name box                                                                         Formula bar
                      Active cell                                                                      Cell

                                                                                                       Scroll bar
                           Rows
                                                                                                       Columns






                      Status bar

                                    Sheet tab                                        View bar

                   Title Bar: It shows the name of the current workbook and the name of the program.
                    Quick Access Toolbar: It contains some of the most frequently used commands like Save,

                   Undo and Redo.
                    Ribbon: It contains different tabs. The tabs are divided into groups. Groups have commands,
                   tools and buttons.

                    File Tab: It contains options such as New, Open, Save, Save As, Print and Close.

                    Status Bar: It shows the name of the selected command or status information. The warning
                   messages are also displayed here.

                     View Bar: It helps us view the worksheets in different modes—Normal View, Page Layout
                   View and Page Break Preview.
                     Sheet Tab: It shows the number of worksheets in a workbook and the active Sheet.

                    Worksheet: It is divided into Rows and Columns. The rows are numbered as 1, 2, 3, 4….
                   as indicated by the Row Headers. The columns are labelled alphabetically as A, B, C, D…Z,

                   AA….AZ,…..XFD as indicated by the Column Headers. The total number of columns in Excel
                   is 16,384. The total number of rows is 1,048,576.
                    Rows and Columns: Columns are the vertical sections of the table whereas Rows are the
                   horizontal sections of the table.

                    Cell:  The  intersection  of  rows  and  columns  is  known  as  cell.  It  is  the  smallest unit  in  a
                   worksheet and can hold numbers, text or formula. Each cell is identified by a unique cell

                   address which is a combination of Column label and Row number as A1, B5, etc.
                    Active Cell: It is the cell that is currently selected. It can be recognised by its green outline.
                   You can type data into an active cell only.



                                                                                        Introduction to Excel 2019  41
   38   39   40   41   42   43   44   45   46   47   48