Page 22 - Trackpad_V1_Book 6_Flipbook
P. 22

DATA TYPES IN EXCEL 2010


                  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 on the spreadsheet
                  such as the heading of the column, title, and name. It can be alphabetic, numeric 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, 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, a formula is entered in the 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.
                      Excel has a maximum of 64 functions nesting levels.


                                                                                                      PURE

                           A formula can contain a maximum of 8,192 character length.                 FACT





                           OPERATORS IN EXCEL 2010

                  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   Trackpad (Version 1.0)-VI
   17   18   19   20   21   22   23   24   25   26   27