User Tools

Site Tools


spreadsheet

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

* Spreadsheet Questions

Follow this link for a list of the functions that you will need for the spreadsheet task.

* Spreadsheet Functions

spreadsheet.txt · Last modified: 2018/04/19 09:12 by rheadi