Page 72 - Penta Book's ICT Catalogue

Let’s see another example.
Type the following table:

1
To create and copy a formula
using references:

> Click cell H4.
> In the Formula bar, type the
formula =G4*$G$1. 1
> Press Enter  . 2
> Click the cell H4 again and

use the Autofill tool. 3

You can use the Copy, Paste 2
commands as well, instead

of the Autofill tool. DIGITAL TEENS 2 MODULE 5 Computing and ICT . Sample Pages

3

8
GRADE

To create and copy a formula using
row absolute reference:
1
> Type this table and click E2. 1

> In the Formula bar, type =D2*B$8. 2
> Press Enter  to calculate the

formula. 3
2

> Click cell E2 and Autofill cells
E3:E6. 4

You can click the cell you want to lock
and press F4 to apply an absolute
reference.

3
4

Penta Books 71