Page 75 - gyamfi series vol. 2

INFORMATION AND COMUNICATION TECHNOLOGY GYAMFI SERIES
4 50 10

1. Analyze the table and use excel functions to create formula for cell,
I. C2
II. C4

Answers:
i. C2 =(A2-B2)
ii. C4 =(A4-B4)

2. Without using excel function find the total of cell:
i. C2
ii. C4

Answer
i. C2 = 200-120= 80
ii. C4 = 50-10= 40

Note; all Excel formula begins with EQUAL SIGN (=)

HOW TO ENTER MULTIPLICATION FORMULAR
(*) meaning product or multiplication.
A BCD E
1 QUANTITY AMOUNT TOTAL
AMOUNT
24 GHC10.00
35 GHC9.00 GHC45.00
46 GHC8.00
57 GHC 12.00
Use excel function to find cell:
i. Cell C3
ii. Cell C2
iii. Cell C5

answers
i. Cell C3 =(A3*B3)
ii. Cell C2 =(A2*B2)
iii. Cell C5 =(A5*B5)

IMPORTANCE OF SPREADSHEET OR MICROSOFT EXCEL
1. It is used to prepare salaries of workers or employees.
2. It saves time and sheet.
3. The information on worksheet can be saved for future retrieval and also changes can
be made easy on the worksheet if necessary.
4. It helps easy access of decision making using what if analysis.
5. It is used to prepare records of organization and employees.
6. It makes it faster and accurately when performing mathematical calculation

Page 75 of 90
ALL SAINTS SCHOOL. Santasi-Apire HANDOUT