TEST OF PRACTICAL KNOWLEDGE QUESTION As the account clerk of an organisation, you are to prepare the table as shown below using a spreadsheet application: W...

Answer Details

This is a spreadsheet (e.g. Microsoft Excel or LibreOffice Calc) practical task. The steps below reproduce the original table, create the required SALARIES table, apply the sorting and calculations, and insert the bar chart.

Step 1 – Original table (\"Workers' Wages\")

Enter the data exactly as given. Type the title in cell A1, the headings in row 2, and the records below.

Step 2 (a) – Create and format the SALARIES table

Select the original table, press Ctrl + C to copy, click an empty cell (e.g. D1) and press Ctrl + V to paste a copy on the same sheet.

• (i) Rename the title: click the pasted title cell and type SALARIES.
• (ii) Sort in alphabetical order: select the Worker and Wage/day columns of the copy, then use Data → Sort → Column: Worker → A to Z. The names re-order and each wage stays with its owner.

After sorting, the SALARIES table looks like this:

Step 2 (a)(iii)–(iv) – Calculations

Assuming the six wages occupy cells E3:E8, enter these formulae in empty cells below the table:

Verification of the average:

Step 2 (b) – Insert the bar chart

Select the Worker and Wage/day columns of the SALARIES table, then choose Insert → Chart → Column/Bar. The chart plots each worker's daily wage:

The tallest bar belongs to Joe (₦2371, the maximum) and the shortest to Ololade (₦650, the minimum), which agrees with the MAX and MIN results above.

Step 2 (c)–(d) – Save, print and submit

• Save: choose File → Save As, open the folder you created, type your full name as the file name and click Save (.xlsx).
• Print: choose File → Print (Ctrl + P), select the printer and click Print, then submit the printout.