ASSESSMENT TASK 1

You are to create and use a total of 2 different linked spreadsheets that use advanced spreadsheet features -relevant to your company. Think about your company ,and what you could use spreadsheet for. Ideas might include:

Customer database, menus, itinerary , staff details, wages, timesheets, etc.

Functions to be demonstrated must include 2 from the list below

Mathematical functions (eg . square root, integer, absolute value, round)

Statistical functions (eg. Standard deviation, count, maximum, minimum,)

Basic financial functions (if available)

Date functions

Logical functions (eg. Lookup, if ,choose, true, false, conditions)

Simple nested functions.

Your assessor will also be required to observe you in this task. During the observation , your assessor will be assessing you:

Using safe work practices

Developing a linked spreadsheet solution

Automating and standardizing your spreadsheet operation (through creating , using and editing macros and templates)

Using your spreadsheet ensuring you

oEnter, check and amend each spreadsheet correctly

oEnter your data effectively

oUse manuals or user documentation (including on-line) for assistance where required

oReview, adjust and print your spreadsheet

oName and store your spreadsheet accordingly

Representing numerical data into graph from

Include appropriate chart type and chart features, which represents numerical data validly

Create graphs with labels titles from numerical data contained in a spreadsheet file

Save, view, and print each chart

you will be submitting the following for each spreadsheet

Printouts of each spreadsheet and associated graph

A soft-copy of your spreadsheet