Databases, formulas and a vote table
Answers are for parents and teachers.
1
Draw a table with three fields and three records about invented pupils’ favourite fruits. Circle one field and underline one record.
Answers differ. Check that columns are fields, rows are records and every record has its own ID.
2
B2 holds 7 and C2 holds 8. What does =B2*C2 give?
56
3
D2 holds 90 and D3 holds 45. What does =D2-D3 give?
45
4
A cell A1 holds 24 pencils to be shared equally among 6 pupils. What does the formula =A1/6 give?
4
5
Voters’ choices for Solution B are in cells D2 to D9. Write a formula for the total of Solution B.
=D2+D3+D4+D5+D6+D7+D8+D9 (or =SUM(D2:D9)).