Look-up+tables

Task
Watch this video on Look-up tables in Excel.

media type="youtube" key="YmseU3Wiod0?fs=1" height="385" width="480"

Now create a spreadsheet with a look-up table to manage pupil test results (out of 100) as follows:

A = 70+ B = 60+ C = 50+ D = 40+ Fail = 0-39

Populate your spreadsheet with the following data. The grade should be pulled from the look-up table:

Jane Mcreadie - 55 Alison Bennet - 30 Kishore Kumar - 67 Andy McLeod - 75 Ben Nicol - 92