Page 27 - ModularV1.1 _c6_flipbook
P. 27

Worksheet Tab Scrolling Buttons: These are arranged on the left side of the horizontal
                    scroll bar. These are used to display the worksheet tabs that 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 3 worksheets—Sheet 1, Sheet 2 and Sheet 3, that can be increased or decreased as

                    per the requirement.
                     CREATING A NEW WORKBOOK

                 You can create  a new workbook  any time by

                 following these steps:
                                                                                                                                                                                                                 Save As dialog box
                 Step 1  Click on the File tab.

                         Backstage view will appear.
                 Step 2  Click on the New option.

                 Step 3  Click on Blank Workbook in the Available
                         Templates list.

                 Step 4  Click on  Create.  The  new  workbook  file
                         will open and you can start adding your
                         own data.
                                                                                    Creating a new workbook
                     ENTERING DATA IN A WORKSHEET

                 The data in the form of numbers or text can be entered by just clicking on a cell and typing with

                 the help of a keyboard. You can type data directly into the cell, or you can enter data using the
                 Formula bar. To do so, follow these steps:

                 Step 1  Click on the cell where you want to enter the data.
                 Step 2  To enter the data and move down one cell, press the Enter key.
                 Step 3  Repeat Steps 1 and 2 until you finish entering all your data.














                                  Entering data in a worksheet                                Worksheet
                     SAVING A WORKBOOK

                 After completing your work in an Excel workbook, you need to save it for future use. For saving
                 a workbook, follow these steps:
                 Step 1  Click on the File tab.




                                                                                     Introduction to MS Excel 2010  25
   22   23   24   25   26   27   28   29   30   31   32