Task Summary |
Key Terminology |
What you will learn
You will learn how to use the sum() and previous skills you have learnt on this project How you will be assessed Submit project when completed |
Function - A formula is an expression which calculates the value of a cell.
|
Total seats sold
Activities
Switch to the Booking tab at the bottom of the screen
- Click in one of the empty Total cells (as highlighted above)
- Type the function =sum(
- Click on the first cell to add up (Adult value 25 in the screenshot above), then type + followed by clicking the next cell you wish to total (child value 5).
- You should complete this same action across the cells before pressing enter to finish the function (in the example above 25+5+110 have been summed to give a total of 140).
- Complete all of the Total cells on your sheet
Finance sheet
Activities
- Setup a new sheet called Finance
- Using your knowledge of the functions you have learnt, set up your prices for the seats as shown below
- NOTE: To set the $ sign, do not type it - instead: right click -> format cell -> currency and select the currency you wish to use
- Set up the income table as shown below - the income should automatically change when new seats are booked.