Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 18 - logicode 2609 C6
P. 18

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

                       16   Premium Edition-VI

| 13 14 15 16 17 18 19 20 21 22 23 |