General Homework Set 3

What is your teacher's name?

Mrs Smith
Mr Munro
Mr Carey
Mr McGivern

Angus runs his own taxi cab. Here is part of the spreadsheet which he uses to keep a record of his expenses and income.

Cells C6 and C10 each contain a formula.

Suggest a suitable formula for cell C6. PS (1 point)

Resource 1

Suggest a suitable formula for cell C10. PS (1 point)

If cell E3 changes, name another cell which will also change. PS
(1 point)

The formula in C6 has been replicated across to the other cells in row 6.

What does replicate mean? KU (1 point)

Where else in the spreadsheet could the replicate feature have been used? PS (2 points)

Angus decides to include the tax he has to pay each month as one of the costs in the spreadsheet. Describe how this can be done in the above spreadsheet. PS (2 points)

The spreadsheet package Angus is using has a human computer interface (HCI).

What is meant by the term human computer interface (HCI)? KU (1 point)

The entry in cell E8 is too long for the cell. How could the spreadsheet be changed to make the text fit this box? PS (1 point)

Introduction
to Spreadsheets

More Complex Tasks

Advanced Tasks

Homework

Helpful Extras

Spreadsheet General Homework 3