Credit Homework Set 3

CHOOSE YOUR TEACHER FROM THE OPTIONS BELOW

Mr Carey
Mr Munro
Mrs Smith
Mr McGivern

Dianne is studying a course in computing. She creates the spreadsheet shown.

Only column D needs to have cell values changed with all formulae working correctly. What could Dianne do to ensure that no other cells are accidentally overwritten? [KU] (1 point)

Resource 1

When the value 2 was entered in cell D6, the amount 4.46 automatically appeared in cell E6. Suggest a suitable formula for cell E6. [PS] (2 points)

A formula referring to cells B1 and E6 is placed in cell F6 to calculate the VAT for Corn Flakes. This formula is replicated down the column.
Explain whether the reference to B1 would use relative or absolute referencing. [PS] (2 points)

The cell attributes of certain cells are to be changed.
What does cell attributes mean? [KU] (1 point)

Suggest a suitable alteration to the cells in column E. [KU] (1 point)

Outline the steps required to make the alteration. [KU] (2 points)

Dianne tries to import the data in the spreadsheet into a database.
If the completed spreadsheet had 1000 rows of data about products, what would this tell you about the size of the database? [PS] (1 point)

The spreadsheet above contains many formulae. What type of field in a database would contain a formula? [KU] (1 point)

How would the database be altered if an extra item is added to stock? [PS] (1 point)

Diane has a friend who is working on a similar spreadsheet. Dianne's friend phones and asks for a copy of the spreadsheet. Should Dianne fax or E-mail the spreadsheet?
Give a reason for your answer. [PS] (2 points)

Introduction
to Spreadsheets

More Complex Tasks

Advanced Tasks

Homework

Helpful Extras

Spreadsheet Credit Homework 3