Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 43 - 2617_JSSPS_C-5
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.

                                                                                        Introduction & Editing in Excel  41

| 38 39 40 41 42 43 44 45 46 47 48 |