lOMoARcPSD|52690394
Information Communication
Technology EXAM TESTS
, lOMoARcPSD|52690394
1
MICROSOFT EXCEL
PRACTICAL EXERCISE 1.1
Using the data given, get the sum of all the figures within the range.
A B C D E F G
1 Mon Tue Wed Thur Fri TOTAL
2 Breakfast 3,560 3,186 2,952 3,395 3,436
3 Lunch 20,163 21,416 19,912 19,681 18,628 4 Bar 9,873 12,172
12,642 12,711 18,846
5 Snacks 2,405 3,544 2,694 3,120 3,712
6 TOTALS
PRACTICAL EXERCISE 1.2
(i). Calculate the totals for each salesperson and get the grand total.:
(ii). Format the worksheet as follows:
Make all the Totals bold, two decimal places, comma, center the title across columns A-E
and make it size 16, bold and Italic.
(iii). Put a double border round the whole table and a single line border inside the table.
(iv). Save the worksheet as Stationery Analysis.
PRACTICAL EXERCISE 1.3
Using the information given in the table below, calculate the total amount payable by the
company to the employees.
Information Communication
Technology EXAM TESTS
, lOMoARcPSD|52690394
1
MICROSOFT EXCEL
PRACTICAL EXERCISE 1.1
Using the data given, get the sum of all the figures within the range.
A B C D E F G
1 Mon Tue Wed Thur Fri TOTAL
2 Breakfast 3,560 3,186 2,952 3,395 3,436
3 Lunch 20,163 21,416 19,912 19,681 18,628 4 Bar 9,873 12,172
12,642 12,711 18,846
5 Snacks 2,405 3,544 2,694 3,120 3,712
6 TOTALS
PRACTICAL EXERCISE 1.2
(i). Calculate the totals for each salesperson and get the grand total.:
(ii). Format the worksheet as follows:
Make all the Totals bold, two decimal places, comma, center the title across columns A-E
and make it size 16, bold and Italic.
(iii). Put a double border round the whole table and a single line border inside the table.
(iv). Save the worksheet as Stationery Analysis.
PRACTICAL EXERCISE 1.3
Using the information given in the table below, calculate the total amount payable by the
company to the employees.
