Page 37 - TP_Pluse_V2.2_Class_6
P. 37

3                     Formulas and Functions





                                                             in Excel 2016










                     Let’s surf

                      Ø  Types of Data in Excel                      Ø  Different Ways to Enter a Formula
                      Ø  Understanding Cell Range                    Ø  Cell Referencing in Formulas and its Types
                      Ø  References to Other Worksheets              Ø  Functions



                                                                                           21 st
                  Let’s PLug-in                                                          Century   #Productivity & Accountability
                                                                                          Skills
                    If in Maths, English, and Computer Science, you get 95, 85, and 90 marks, respectively, find out

                    your average marks and percentage of your exams.
                      ______________________________________________________________________________

                      ______________________________________________________________________________




                 Excel is one of the most useful programs and can provide us a wide range of tools to work with data.
                 In this chapter, you will learn how to use formulas in Excel.


                       TYPES OF DATA IN EXCEL


                 In Excel, there are three different types of data that you can enter in a spreadsheet. These are:
                    Labels: A label is an important entry in Excel. The label is used to define
                   the information on the spreadsheet, i.e., headings of columns, titles
                   and names. It is any text besides phone numbers, numbers, formulas,

                   etc. We do not do any mathematical calculations on labels. Labels are
                   aligned to the left side of a cell.
                    Values or Numbers: Values are numeric data on which mathematical calculations are performed.
                   This type of data includes characters 0–9. The numbers are always aligned to the right side of
                   the 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 (=) sign
                   e.g. = A2 + B2.





                                                                               Formulas and Functions in Excel 2016  35
   32   33   34   35   36   37   38   39   40   41   42