Page 22 - TP_Pro_V5.1_Class6
P. 22

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.

                  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).





                   20   Pro (V5.1)-VI
   17   18   19   20   21   22   23   24   25   26   27