General Homework Set 6

What is your teacher's name?

Mr Munro
Mr McGivern
Mrs Smith
Mr Carey

A local Cinema keeps a spreadsheet to record takings from the movies showing each evening. A part of the spreadsheet is shown. Cell E2 contains a formula. Suggest a suitable formula for this cell.KU (1 point)

Resource 1

Cells E3 to E5 contain very similar formulae to E2. Which feature of a spreadsheet would allow formulae to be entered in these cells without typing the actual formula in each cell? PS (1 point)

Details of one movie have been mistakenly omitted from the spreadsheet.
The film details are shown What can be done to enter the details above, keeping the movie titles in alphabetical order? PS
(2 points)

Resource 1

The movie title above will be too long for the cell it will go into. What can be done to make sure that the whole of the title will be visible in the cell? PS (1 point)

Cell C2 was originally entered as 3.50 and not £3.50. Why would it be a bad idea to type the pound sign in the cell? Explain your answer clearly. PS (2 points)

Introduction
to Spreadsheets

More Complex Tasks

Advanced Tasks

Homework

Helpful Extras

Spreadsheet General Homework 6