Page 23 - KEC Khaitan C6 Flipbook
P. 23

FORMULAS AND FUNCTIONS                                                                   CHAPTER


                 IN EXCEL 2021                                                                           A2
















                    LEARNING OUTCOMES                                                                            95%


                    The student will be able to:
                        understand the data types in excel 2021.
                        understand operators in excel 2021.
                        understand operator precedence.
                        understand ways to enter a formula in excel 2021.
                        understand the cell range.
                        understand the cell reference.
                        understand functions.




                           DATA TYPES IN EXCEL 2021


                 In Excel, data can be categorized into three types. Let us learn about them.
                 LABEL

                 Any text entered in Excel is called a label. It is used to define the information in the spreadsheet,
                 like the heading of a column, title, and name. It can be alphabetic, or alphanumeric text. By
                 default, the label is always left-aligned. We cannot perform any mathematical calculations on
                 labels. Some examples of labels are Name, x45fg, 12-5LA, Lakshay, Ravi.

                 VALUE
                 Any numeric data entered in Excel is called a value. These numerical entries are treated as fixed
                 values in Excel. We can do mathematical calculations on numeric entries. By default, numeric
                 values are always right-aligned. For example, 45 and 85574.


                 FORMULA
                 A formula is an expression that operates on the value or a range of cells and generates a result.
                 To perform mathematical calculations,  formula is  entered  in a cell. We  perform arithmetic
                 calculations on numeric values. The elements of a formula are:
                   References: A cell or a range of cells that you want to use in your calculation.

                   Operators: Symbols (+, -, *, /, ^, $, %, etc.) that specify the calculations to be performed.
                   Constants: Numbers or text values that do not change.



                                                                                 Formulas and Functions in Excel 2021  21
   18   19   20   21   22   23   24   25   26   27   28