Credit Homework Set 2

CHOOSE YOUR TEACHER FROM THE OPTIONS BELOW

Mr Carey
Mr McGivern
Mrs Smith
Mr Munro

A school uses a spreadsheet to calculate what departments spend on computer supplies and books.
Part of the spreadsheet is shown below:

Which type of referencing would have been used to copy the formula from D3 to the other cells in that column? [PS] (1 point)

Resource 1

A discount is given to each department if they spend more than £200. This formula is entered in cells E3 to E6.
Write down a formula for cell E3. [PS] (4 points)

The formula in cell E3 is replicated down the column. Which cell would require absolute replication? [PS] (1 point)

How can the cells containing the discount formula be stopped from having the contents accidentally altered? [KU] (1 point)

The cell attributes of B3 to F6 are to be changed.
What is meant by cell attributes? [KU] (1 point)

Suggest a suitable alteration to these cells. [KU] (1 point)

The spreadsheet is part of an integrated package that the school uses.
Give two advantages of an integrated package. [KU] (2 points)

Give two disadvantages of an integrated package. [KU] (2 points)

Which feature of the software package would allow the school name to be produced at the top of each page when the file is printed? [KU] (1 point)

Introduction
to Spreadsheets

More Complex Tasks

Advanced Tasks

Homework

Helpful Extras

Spreadsheet Credit Homework 2