Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 10 - 2607_Trackpad_Pro_5.1_flipbook_C6
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 |