You are to create and use a total of 2 differentlinked spreadsheet: that use advanced spreadsheet features – relevant to your company. Think about your company, and what you could use spread sheets for. Ideas might include: One linked spreadsheet must calculate costing estimatfi for each stage of a construction job against actual expenditures and contracted revenue. Income for this task could be allocated as: 1 Deposit 5’91; 1 Ease Stage 10% 1 Frame Stage 15% E Lock-up Stage 35% E Fixing Stage 21% 1 Completion 10% The other linked spreadsheet may include a customer data base, menus, itinerary, staff details, wages, timfi heels, etc Functions to be demonstrated must include 3 from the list below . mathematical fu nctions [eg_ square root. integer, absolute value, round] . statistical functions {eg standard deviation, count, maxim urn, minimum] . basic financial functions {if available] . date functions . logical fu nctions leg. looku p, if, choose. true, false. conditions] El sirnple nested functions. "I’our assasor will also be required to observe you in this task. Duri ng this observation, your assasor will be assessing you: . Using safe work practices . Developing a linked spreadsheet solution . Automating and standardising your spreadsheet operation {through creating. using and editing macros nd templates} . Using your spreadsheet ensuring you . Enter. check and amend each spreadsheet correctly . Enter your data effectively I Use manuals or user docu rne ntation [including o n-line] for assistance where required . Review. adjust and print your spreadsheet