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 spread sheets...

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 spread sheets for.  Ideas might include:

•    Customer database
•     menus,

•    itinerary,

•    staff details,

•    wages,

•    timesheets, etc


You must discuss your spreadsheet concept with your assessor prior to commencing this assessment


Functions to be demonstrated must include 3 from the list below


•    mathematical functions (e.g. 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.