Page 83 - TGPT_V5.0_C5_Flipbook
P. 83
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.
Copying a Formula
There are two methods to copy a formula:
Using the Fill Handle
Step 1: Select the cell that contains the formula, then position the 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.
Hintbot
To calculate the sum of adjacent cells: press the
Alt + = keys together after selecting the cells.
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.
Editing Cell Contents in Excel 2021 81

