IF Function - Practice Assessment Task

This is a practice assessment task the includes:

Importing text data

Entering a formula

Formatting a percentage

Entering an IF Function

Filtering data

Sorting data

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