Spreadsheet Practical task
For the practical spreadsheet task you need to be able to format a spreadsheet, completing tasks such as change font, colour, merge and center, etc.
You also need to know some of the functions that Excel provides to help you create a spreadsheet: for example vlookup, sumif, sum, min, max, etc
Follow this link to some sample spreadsheet questions which might appear on the theory paper. These will require that you know how to use some functions and might ask what formula you will use
Follow this link for a list of the functions that you will need for the spreadsheet task.