General Homework Set 4

P and D Music rent out sound systems around various towns and cities in Scotland. A spreadsheet is used to keep a record of their income and expenditure. Here is part of the spreadsheet.

Cells H2 and C11 each contain a formula.

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

Resource 1

Suggest a suitable formula for cell C11. PS (2 points)

The formula in C11 has been replicated across to the other cells in this row.

What is meant by the term replicate in this example? KU (1 point)

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

The company start to do business in Edinburgh and want to include figures in the appropriate place in the spreadsheet. Describe how this can be done. PS (2 points)

P and D wish to produce a quarterly report showing data from the spreadsheet in a graph. What feature of the spreadsheet package could be used to do this? KU (1 point)

Certain features of the spreadsheet package have been used to highlight important information. Suggest one other change that could be done to improve the layout of the spreadsheet. PS (1 point)

Introduction
to Spreadsheets

More Complex Tasks

Advanced Tasks

Homework

Helpful Extras

Spreadsheet General Homework 4