Page 10 - 2403_Trackpad_V5.1_C6_Fb
P. 10

DATA TYPES IN EXCEL 2021


                  In Excel, data can be categorised 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.

                  Some points must be kept in mind while creating a formula:
                      A formula must always begin with an equal (=) sign.

                      Operators must be included to direct the operation.
                      The data can be either numbers or cell addresses.



                                                                                                      PURE
                           A formula can contain a maximum of 8,192 characters in length.             FACT






                            OPERATORS IN EXCEL 2021


                  Operators are the symbols that are used to perform calculations on the elements of a formula.
                  There are three different types of operators: Arithmetic, Comparison and Reference.


                  ARITHMETIC OPERATORS
                  These operators  perform basic  mathematical  operations.  Some  arithmetic  operators  are:
                  +(addition), -(subtraction), *(multiplication), /(division) and ^(exponential).






                   8    Premium Edition-VI
   5   6   7   8   9   10   11   12   13   14   15