Page 32 - Plus_V2.2_C6_Flipbook
P. 32
You can also use cell addresses to perform calculation in the following way:
Notice that when the cell C1 is selected in the Formula bar shows
the formula you just typed. Tech Hint
What appears in the cell is the result. To calculate the sum of
What appears in the formula bar is the value, which is a adjacent cells: press the
formula in this case. Alt + = keys together after
The elements of a formula are: selecting the cells.
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.
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.
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, 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. __________
30 Premium Edition-VI

