Page 69 - PlusGPT_V2.1_C7_Flipbook
P. 69

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.
                   Worksheet Tab Scrolling Buttons: These are arranged on the left side of the worksheet tab. These
                    are used to display the worksheet tabs which are invisible. The tab is clicked to make a worksheet
                    active.

                   Workbook: A workbook is a collection of different worksheets. By default, a workbook contains
                    one worksheet i.e., Sheet1, that can be increased or decreased as per the requirement.

                   Ribbon: Microsoft Excel ribbon is the row of tabs and icons at the top of the Excel window that allows
                    you to quickly find, understand and use commands for completing a certain task.


                        CREATING A NEW WORKBOOK


                 You can create a new workbook any time by following these steps:

                 Step 1:   Click on File tab.
                          Backstage view will appear.
                 Step 2:   Click on the New option.

                 Step 3:    Click on Blank workbook option in the Available Templates list.
                 The new workbook file will open and you can start adding your own data.



                                                                                          Introduction to Excel 2016  67
   64   65   66   67   68   69   70   71   72   73   74