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...

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:

(a) Copy and paste table title "Workers' Wages" on the same sheet. Format this new table as follows:
(i) Title the new table as SALARIES
(ii) Sort the table in alphabetical order
(iii) Calculate average wage of workers per day

(iv) Calculate the max and min wages paid to the workers from the SALARIES

(b) Insert a bar chart for data in 2a

(c) Save workbook with your full name in the folder created

(d) Print and submit