Question 2
As the account clerk of an organization, you are to prepare the table as shown below using a spreadsheet application.
WORKER |
WAGE PER DAY (N) |
EDEH |
1,500.00 |
USMAN |
1,750.00 |
STEVEN |
1,200.00 |
OLOLADE |
650.00 |
COMFORT |
897.50 |
JOE |
2,371.20 |
- Copy and paste table title “Workers’ Wages” on the same sheet. Format this new table as follows:
- title the new table as “SALARIES”;
- sort the table in alphabetical order;
- calculate average wage of workers per day;
- calculate the maximum and minimum wages paid to the workers from the table “SALARIES”
- Insert a bar chart for the data in 2 (a)
- Save workbook with your full name in the folder created.
- Print and submit.
Observation
The question tested candidates’ skill on using a spreadsheet application to perform some computations and insert a graph.
Majority of the candidates demonstrated proficiency on the use of spreadsheet application.