Credit Homework Set 4

CHOOSE YOUR TEACHER FROM THE OPTIONS BELOW (1 point)

Mr Munro
Mr McGivern
Mr Carey
Mrs Smith

A shop uses a spreadsheet to keep control of its stock.
Column E uses a formula that compares the values in column C and D and places a Y or an N in E, depending on whether the item needs to be re-ordered.
What kind of formula would be used in column E? [KU] (1 point)

The formula in cell E2 was replicated to cells E3 to E5. Would absolute or relative replication have been used here? Explain your answer. [PS] (2 points)

What would be done to stop the formula in column E from being accidentally altered? [PS] (1 point)

The item code in column A includes a check digit.
Is a check digit an example of validation or verification? [KU] (1 point)

Explain the difference between validation and verification. [KU] (1 point)

What is the purpose of including an item code as well as the name of each item? [PS] (1 point)

The manager sends the spreadsheet to head office as an attachment to an Email.
What is an attachment? [KU] (1 point)

Give one advantage to sending the spreadsheet as an attachment. [PS] (1 point)

An employee in the shop asks for a copy of the software used to create the shop's spreadsheets, to install on their own machine.
Which piece of legislation makes this action illegal? [KU] (1 point)

Introduction
to Spreadsheets

More Complex Tasks

Advanced Tasks

Homework

Helpful Extras

Spreadsheet Credit Homework 4