**
Fill This Form To Receive Instant Help**

Homework answers / question archive / Each student is to develop and use 2 different linked spreadsheets that use advanced spreadsheet features - suitable for a construction company

Each student is to develop and use 2 different linked spreadsheets that use advanced spreadsheet features - suitable for a construction company.

One linked spreadsheet must calculate costing estimates for each stage of a construction job against actual expenditures and contracted revenue. Income for this task could be allocated as:

- Deposit 5%
- Base Stage 10%
- Frame Stage 15%
- Lock-up Stage 35%
- Fixing Stage 25%
- Completion 10%

The other linked spreadsheet may include a customer database, menus, itinerary, staff details, wages, timesheets, etc

Functions to be demonstrated must include 3 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.

During this observation, your are to assess each candidate:

- Using safe work practices
- Develop a linked spreadsheet solution
- Automate and standardise your spreadsheet operation (through creating, using and editing macros and templates)
- Use your spreadsheet ensuring you
- Enter, check and amend each spreadsheet correctly
- Enter your data effectively
- Use manuals or user documentation (including on-line) for assistance where required
- Review, adjust and print your spreadsheet
- Name and store your spreadsheet accordingly

- Represent numerical data into graph form
- Include appropriate chart type and chart features, which represents numerical data validly
- Create graphs with Labels and titles from numerical data contained in a spreadsheet file
- Save, view, adjust and print each chart