Page 56 - 2422_C5_Flipbook
P. 56

Sheet Tab

                  It is present at the bottom left side of the Excel window just above the Status bar. Sheets
                  tabs show the number of worksheets in a workbook and the Active Sheet (currently open
                  worksheet). The name of default worksheet is Sheet 1. To add a new worksheet, click on the
                  plus sign on the right of the sheet tab.






                       Row and Columns
                  Columns are the vertical sections of the worksheet whereas Rows are the horizontal sections

                  of the worksheet. An Excel worksheet has 1,048,576 rows and 16,384 columns.

                       Cells

                  Cells are the intersection of rows and columns. It is the smallest unit in a worksheet and can
                  hold numbers, text or formula.

                       Worksheet

                  The worksheet is divided into Rows and Columns. The rows are numbered as 1, 2, 3, 4…. as
                  indicated by the Row Headers on the left side of the workspace. The columns are labelled
                  alphabetically as A, B, C, D…Z, AA….AZ,…..XFD as indicated by the Column Headers at the top

                  of the workspace.

                       Active Cell

                  As the name suggests, it is the cell that is currently active or selected. It can be recognised by
                  its thick green border. You can type data into an active cell only.


                       Formula Bar

                  It displays the contents of the active cell. You can also type or edit data and formulas in the
                  formula bar.



                          Let’s CatCh uP
                    Match the following:

                    1.  Row Header               a.  Address of the active cell

                    2. Column Header             b.  Displays content of active cell

                    3. Sheet Tab                 c.  Row numbers
                    4. Name Box                  d.  Column labels

                    5. Formula Bar               e.  Displays number of sheets in worksheet




                  54    Premium Edition-V
   51   52   53   54   55   56   57   58   59   60   61