Database and Advanced Spreadsheet for Business Assignment - Spreadsheet Project

The Problem: Fights Transfers are a Dublin based transportation company providing transport services from Dublin Airport to Dublin and the surrounding counties up to 50KM from the Airport.

They have asked you to use spreadsheet software to set up a pricing system which will automatically work out the cost of a transport service, record quotes and create professional looking receipt.

Specific Requirements -

• They want to be able to clear the price calculations at the click of a button and to be able to change prices easily.
• They want to be able to change prices easily on any of the three price lists (This project will require four price lists, one for each vehicle type, on the Price Lists page).
• They want to be able to print this receipt at the click of a button.
• They also want the spreadsheet set up so that you cannot delete formulas and data by mistake or enter data which is unacceptable.
• They want a method of recording customer quotes.

Note - Just need to make a receipt on excel using different functions of Excel. Try to work it out on your own and remember: the 'Denton Gazette' assignment shows you how to use these tools.

Attachment:- Assignment Files.rar