Excel spreadsheet practice tasks

If you are cruising towards thinking you're pretty ready for a spreadsheet task for IT Applications unit 4 outcome 1, here are some tasks to see if you need to practise just a little bit more. Solutions are provided, but be aware that there will be several ways to solve a particular problem.

Aim for the more elegant method, please! So:

• nested IFs are to be avoided at all costs (see here for ways to avoid nested IF)
• used named cells and ranges instead of monstrously ugly constructions like Sheet2!$B$15:$G$22
• eschew dumb horrors like =(A1,A2,A3,A4,A5,A6,A7) and, even worse, =SUM(B5*E3)

Good luck.

Task 1 - Conditional Formatting (requires Excel 2007 for advanced formatting features)

Task 2 - VLOOKUP task 1 (tax table)

Task 3 - IF, AND, OR (in progress, if I could be bothered and I get time or someone else finishes it)

Task 4 - Arithmetic - Create a spreadsheet that works out catering figures for Joe. It should look like this:

Download a solution for task 4.

Task 6 - A Simple VLOOKUP

Download solution to task 6.