Page 40 - Plus V4 with Adobe class 6
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.
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.
Some formulas based on BEDMAS rule can be entered as:
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
Using the Fill Handle of adjacent cells: press
the Alt + = 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 (+) 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, 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

