Spreadsheet+And+Or

Task
A school is voting in their student council. Every pupil in the school is allowed to cast 2 votes for each candidate - their first choice and their second choice.

The votes are counted as follows First choice votes = 123 Second choice votes = 77 First choice votes = 104 Second choice votes = 152 First choice votes = 60 Second choice votes = 28 First choice votes = 120 Second choice votes = 111
 * Andy**
 * Gina**
 * Fiona**
 * Lewis**

The rules are that a pupil is voted onto the student council if both their total first choice votes and their total second choice votes exceed 100.
 * Part A - AND**

Produce a spreadsheet which uses the AND function to show who gets voted onto the student council

The rules are changed so that a pupil can be voted onto the student council if either their first choice votes or their total second choice votes exceed 100.
 * Part B - OR**

Produce a spreadsheet which uses the OR function to show who gets voted onto the student council