Page 39 - Plus V4 with Adobe class 6
P. 39
Creating a Chart
To create a chart, follow the given steps:
1 Select the
range of cells.
2 Click on the 3 Click on the Insert Column
Insert tab. or Bar Chart command.
4 Select the 2-D Column
Chart option.
DATA TYPES IN EXCEL
In Excel, there are three different types of data that you can enter. These are:
Labels: The label is used to define the information on the spreadsheet, i.e.,
heading of columns, titles and names. It is any text besides phone numbers,
numbers, formulas, etc. We do not do any mathematical calculations on
labels. Labels are 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 and characters are always aligned on the right side of the cell.
Formula: A formula is a mathematical expression used to do simple and complex calculations of the
numeric data inserted in 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 equal to sign, Excel
understands that 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 as follows:
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.
#Charts, Formulas and Functions in Excel 37

