Page 22 - Trackpad_V5_Book 6
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 do not 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 presented 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 (Ver. 5.0)-VI
   17   18   19   20   21   22   23   24   25   26   27