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

