Today we are going to use our formula and function skills to work out how much money we made from the Hogwalks Concert
First lets open your user interface workbook from last lesson
Then Click on the image below to open the Hogwarks Concert speadsheet
Don't forget to copy this worksheet into your user interface workbook?
Use the example below as a template for woking out the profit for the other seats.
Click on the image below to open the ''TV Quiz'.
Fill in as many answers as you can.
An IF Statement is a 2+ parameter functions. Below is an example of an 'IF statement' that checks if two cells, 'C21 and C23' are equal. If they are, it sets the value to 'Correct', if not it sets it to 'Incorrect'
If you look in your TV quiz and click on a cell that says 'Correct', you can see an example of an IF statement in the formula bar.
Click on the image below to open the Quiz Template
Copy this worksheet into your user interface workbook then create your own quiz about Harry Potter
Lets extend our learning by looking at Validation
Click on the image below and complete the 'Validation Worksheet'.
If you complete this task Attempt the tasks for Hogwarts 2