Spreadsheets - Test Bite

Choose the correct word to fill in each of the blanks in the following sentences. (3 marks G KU for spaces a to c, 3 marks G PS for spaces d to f)

The spreadsheet above has four (the options are) SELECT--- columnsrowscells and five (the options are) SELECT--- columnsrowscells . The cell with the (the options are) SELECT--- column headingcell referenceformula B3 contains (the options are) SELECT--- textvalueformula(e) Cells A1 to A5 contains (the options are) SELECT--- textvalueformula(e) and cells D2 to D5 contains(the options are) SELECT--- textvalueformula(e) .

Here's part of a spreadsheet used for recording ticket sales for a school show.

Which of these shows the formula used to calculate the value in cell C5?

Which of the following best describes what should be done to column B and column D to make the figures look more like sums of money?

Credit. This one's a bit more difficult. Here's part of a spreadsheet used by a teacher to record exam marks. The teacher has used a formula to calculate if a student has gained a Pass or a Fail

What name is given to the kind of forumula used in cell C2?

The formula in cell C2 refers to the number in cell B9. When the formula is replicated from C2 down to C6 should the reference to B9 be