Credit Homework Set 1

CHOOSE YOUR TEACHER FROM THE OPTIONS BELOW (1 point)

Mr McGivern
Mrs Smith
Mr Munro
Mr Carey

The following is a part of a spreadsheet a car dealer keeps on his cars in stock.

A discount of £500 is being offered, but only on cars over £10 000.
A formula in D2 calculates the sale price. This formula is replicated down the column.
Write down the formula for cell D2. [PS] (3 points)

Resource 1

When the formula is replicated, will relative or absolute referencing be used? Give a reason for your answer. [PS] (2 points)

The spreadsheet package used to produce the spreadsheet above uses cell protection.
What does cell protection mean? [KU] (1 point)

Write down a column in the spreadsheet shown where cell protection should not be used. Give a reason for your answer. [PS] (2 points)

The spreadsheet shown could be transferred to a database package.
Based on the spreadsheet shown
How many fields would the database contain? [PS] (1 point)

How many records would the database contain? [PS] (1 point)

Give one reason why the manager may want the information in a database. [PS] (1 point)

The manager sends a standard letter to regular customers letting them know of upcoming cars on sale.
Outline the steps involved in producing a standard letter. [PS] (3 points)

Introduction
to Spreadsheets

More Complex Tasks

Advanced Tasks

Homework

Helpful Extras

Spreadsheet Credit Homework 1