Page 74 - gyamfi series vol. 2

INFORMATION AND COMUNICATION TECHNOLOGY GYAMFI SERIES
OR
=Sum (C2,C3,C4,C5,C6,C7,C8,C9,C10)
OR
=SUM(C2:C10)

Note; the above all Excel formulas are ADDITION excel function for calculating totals of a
particular cells.

AVERAGE FORMULARS AT:
1. Cell E2
=Average(B2:D2)
Or
=Average (B2,C2,D2)
2. Cell D11
=Average (D2:D10)
OR
=Average (D2,D3,D4,D5,D6,D7,D8,D9,D10)
OR
=sum(D2,D3,D4,D5,D6,D7,D8,D9,D10)/9

MAXIMUM VALUE AT:
1. Cell E2
=Maximum (B2,C2,D2)
Or
=Max (B2,C2,D2)
2. Cell D11
=Maximum (D2,D3,D4,D5,D6,D7,D8,D9,D10)
OR
=Max (D2:D10)
MINIMUM VALUE AT:
1. Cell E2
=Minimum (B2,C2,D2)
OR
=Minimum (B2:D2)
2. Cell D11
2, Cell D11
=Minimum (D2,D3,D4,D5,D6,D7,D8,D9,D10)
OR
=Minimum (D2:D10)

HOW TO GENERATE SUBTRACTION
ABC D E
1 TOTAL
2 2OO 12O
3 150 60 90

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