Page 71 - PlusGPT_V2.1_C7_Flipbook
P. 71

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.


                        EDITING IN EXCEL 2016


                 In the previous chapter, we have learned about different components of Excel 2016 window such as

                 cell, row, column, formula bar, workbook and worksheet. We have also learnt the process of creating
                 a workbook, entering data into a worksheet and saving a workbook. In this chapter, we will learn more
                 about Excel 2016.





                                                                                          Introduction to Excel 2016  69
   66   67   68   69   70   71   72   73   74   75   76