Page 30 - TP_Pluse_V2.2_Class_6
P. 30
Let’s PraCtiCe 21 st
Century #Technology Literacy
Skills
Create an Excel worksheet having a list of months and expenditure in each month. Use the
Auto Fill to fill the names of months.
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.
To show how formulas work, we'll begin with a simple exercise by selecting blank cell A1.
Then type = 5 + 5, and press Enter key. As you press the Enter key, Excel performs the calculation and
produces the result as 10 in cell A1.
Enter some more formula in other cells and see what results are shown by Excel.
1. =8 – 5
2. =8 * 5
3. =8/5
4. =8 ^ 5
The results will be 3, 40, 1.6 and 32768 respectively.
Some formulas based on BEDMAS rule can be entered as:
1. =(8 + 5) – (2 + 3) ^ 2
2. =(9/3) * (4 ^ 2) – 5
Tech Fact
Excel follows BEDMAS rule for doing mathematical calculations, where B stands for Brackets, E
for Exponentiation, D for Division, M for Multiplication, A for Addition and S for Subtraction.
You can also use cell addresses to perform calculation in the following way:
28 Plus (Ver. 2.2)-VI

