This is a practice assessment task the includes:
Importing text data
Entering a formula
Formatting a percentage
Entering an IF Function
Creating a chart
Final formatting to ensure the spreadsheet and chart will fit on one page.
All of the above processes are demonstrated elsewhere with video tutorials.
First: Download the Tool Hire IF Function Practice Assessment Sheet
Second: Download Data File
Third: Complete the spreadsheet and chart so that theu fit on one page
Fourth: Email the finished spreadsheet and chart to your ICT FS Tutor for assessment and feedback
Entering a formula and formatting as a percentage