Page 52 - 2611_SmartGPT Pro V(5.0) C-5

TYPES OF DATA IN EXCEL

In Excel, there are three different types of data that you can enter. These are:

Text: The text is used to define the information on the spreadsheet, NAME AGE CLASS
i.e., the headings of columns, titles, and names. This includes any AKSHAT 11 4 5
SOUMYA
12
type of text, not just phone numbers, numbers, or formulas. We do RAHUL 11 4
not do any mathematical calculations on text. Text is aligned on
the left side of a cell.

Values or Numbers: Values are numeric
data on which mathematical calculations are
performed. This type of data includes characters
0–9 and special characters, such as –, +, [, /,
?, >, <, %. The numbers are always aligned on
the right side of the cell, and the characters are
always aligned on the left side of the cell.
Formula: A formula is a mathematical expression that performs both simple and

complex calculations on the numeric data entered into a cell. A formula always begins
with an equal (=) sign, e.g., = A2 + B2.

USING FORMULAS TO PERFORM CALCULATION

Formulas in Excel begin with an equal (=) sign. When the contents of a cell begin with an
equal sign, Excel understands that the user has given a formula here. If you don’t enter the
equal sign, Excel will treat your entry as text, and the calculation will fail.

DIFFERENT WAYS TO ENTER A FORMULA

There are mainly two ways to enter a formula in a worksheet:

Typing the Formula Directly in the Cell: In this
way, the formula is directly typed in the cell
after typing an equal sign (=). After entering the
formula in the cell, press the Enter key. When
the Enter key is pressed, result of the formula
appears in the cell.

Typing the Formula in the Formula Bar: In
this way, we can type the formula in Formula

bar after selecting the cell. After entering the
formula, when we press the Enter key from the
keyboard. The result will appear.

50 Computer Science (V5.0)-V