Page 31 - TP_Pluse_V2.2_Class_6
P. 31
Notice that when the cell C1 is selected, the Formula bar shows the formula you just typed.
What appears in the cell is the result.
When a formula is typed and used in a cell it is displayed in the formula bar.
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.
Tech Hint
To calculate the sum of adjacent cells: press the Alt + = keys together after selecting the cells.
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: Click and 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 on the Home tab, click Copy.
Step 2: Select the cell or cells that you want to copy it to.
(a) To copy the formula and any formatting, on the Home tab, click Paste.
(b) To copy the formula only, on the Home tab, click on drop-down arrow of Paste tool and
select Paste Special in the Paste Special dialogue box, and then select Formulas and
click on OK button.
Let’s CatCh uP
State whether these statements are True or False.
1. Excel makes calculations easier. ___________
2. We can apply all types of mathematical operations like addition,
subtraction, multiplication and division in Excel. ___________
3. The input of =25+B2 will give an error message. ___________
More on Excel 2016 29

