Page 31 - TP_Modular_V2.1_Class7
P. 31

SAVING A WORKBOOK

                 After completing your work in an Excel workbook, you need to save it for future use. For saving
                 a workbook, follow the given steps:

                 Step 1   Click on the File tab.
                 Step 2    Click on the Save option. Save As dialog box appears. Select the location where you want
                         to save the workbook.

                 Step 3    Enter the File name in the File name textbox.
                 Step 4   Click on the Save button.



























                    DATA TYPES IN EXCEL 2016


                 Excel supports various data types, including:
                 1.  Text/String: Alphanumeric characters.

                 2.  Number: Numeric values for calculations.
                 3.  Date/Time: Dates and times for scheduling and tracking.
                 4.  Boolean: True or False values for logical operations.

                 5.  Error: Indicates a problem with a formula or operation.
                 6.  Array: A range of cells or values.

                 Each data type has its own formatting and functions for manipulation and analysis within Excel.
                    Labels: A label is an important entry in Excel. The label is used to define the information
                    on the spreadsheet, i.e. heading of columns, titles and names. It is any text besides phone
                    numbers, numbers, formulas, etc. Labels are aligned on the left side of a cell.

                    Formula: A formula is a mathematical expression used to do simple and complex calculations
                    of the numeric data inserted in a cell or a range of cells. A formula always begins with an equal
                    to (=) sign e.g. = A2 + B2.






                                                                                  Introduction to Excel 2016      29
   26   27   28   29   30   31   32   33   34   35   36