Page 38 - Plus_V2.2_C6_Flipbook
P. 38

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



                   Let’s PLug-in

                     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., heading 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 on 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 on 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.


                  36    Premium Edition-VI
   33   34   35   36   37   38   39   40   41   42   43