Page 42 - TP_Prime_v2.2_Class_6
P. 42
Copying a Formula
There are two methods to copy a formula:
Using the Fill Handle
To use the Fill Handle in Excel, follow these steps:
Step 1: Select the cell that contains the formula, then position the mouse pointer over the
Prime (Ver. 2.2)-VI Step 2: Click and drag the fill handle over the cell or cells to which you want to copy the
lower-right corner of the cell until the black cross (+) appears.
formula, then release the mouse button.
Using Copy and Paste
To copy a formula in Excel, follow these steps:
Step 1: Select the cell that contains the formula.
40
Step 2: Click on the Copy Command under the Home tab.
Step 3: Select the cell or cells where you want to paste.
(a) To copy the formula and any formatting, click on the Paste Command under
the Home tab.
(b) To copy only the formula, click on the drop-down arrow of the Paste command
under the Home tab, select the Paste Special option. Select the Formulas
option from the Paste Special dialog box and then click on the OK button.
21 st
Century #Information literacy
Warm Skills
Up! Write ‘T’ for true and ‘F’ for false.
1. Excel makes calculation 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. ___________
Order of Operation
When performing calculations using a formula, Excel follows certain rules of precedence:
• Excel calculates expressions within parentheses ‘(‘ , ’)’ first.

