General Homework Set 5

What is your teacher's name?

Mr McGivern
Mr Carey
Mrs Smith
Mr Munro

CalDar Ferries take passengers around several islands in the North of Scotland. A spreadsheet is used to store information about each ferry trip. The TOTAL COSTS and PROFIT are calculated automatically using formulae. Part of the spreadsheet is shown.

a. Profit is calculated by subtracting the TOTAL COSTS from the Fares.
Suggest a suitable formula for cell B9. PS (1 point)

Resource 1

All the formulae needed to calculate the TOTAL COSTS for each ferry crossing are replicated from the formula in cell B8. What happens when a formula is replicated? KU (2 points)

The data for cell B5 was displayed as 356 when it was entered. What has been done to the cell attributes to change the way the data appears? PS (1 point)

The company want to include a figure for Tax in the spreadsheet. This should be included in the spreadsheet beside the other costs, and before the total costs and profits are calculated. What must be done to the spreadsheet to enter the details of tax in the correct place? PS (1 point)

The use of the computer will involve running costs. Give two examples of computer running costs. KU (2 points)

The spreadsheet package has on-line help and on-line tutorials. Which of these options should be used in the event that the user forgets how to enter a formula?
Explain your answer. KU (2 points)

Introduction
to Spreadsheets

More Complex Tasks

Advanced Tasks

Homework

Helpful Extras

Spreadsheet General Homework 5