Page 40 - TP_Plus_v4_Class6
P. 40
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 in
the particular cell.
Factbot
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.
Calculate the formulas given below based on BEDMAS and write the result.
1. =(8 + 5) – (2 + 3) ^ 2 2. =(9/3) * (4 ^ 2) – 5
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.
Hintbot
Copying a Formula
There are two methods to copy a formula: To calculate the sum of
Using the Fill Handle adjacent cells: press the
Alt and = keys together
Step 1: Select the cell that contains the formula, then position the after selecting the cells.
mouse pointer over the lower-right corner of the cell until
the black cross (+) or Fill Handle appears.
Step 2: Drag the fill handle over the cell or cells to which you want to copy the formula, then release
the mouse button.
Using Copy and Paste
Step 1: Select the cell that contains the formula, and click on the Copy command.
Step 2: Select the cell or cells that you want to copy it to.
a. To copy the formula and any formatting done in that cell, click on the Paste command.
b. To copy the formula only, on the Home tab, click on drop-down arrow of Paste command
and select Paste Special, and then select Formulas and click on OK button.
Double Tap Century #Technology Literacy
21 st
Skills #Flexibility
Write T for True and F for False.
a. Excel makes calculations easier.
b. We can apply all types of mathematical operations like addition, subtraction,
multiplication and division in Excel.
c. The input of =25+B2 will give an error message.
38 Plus (Ver. 4.0)-VI

