Star Talent > Week 6 > Spreadsheets

Watch the videos and follow along with Mr. Hall. Read the text for a reminder of what to do.

Step 1: The Seating

Time to allocate seating! Type in the letters A, C, S, GC or F into the cells for the seats. Each cell is a block of 50 tickets!

A= Adults. C=Children. S=Seniors. GC= Golden Circle. F= Free.

Step 2: Adding it all up

Use a formula to calculate how much income you have for each type of ticket.

  • Help: The formula you need to type into the first cell is =v4*x4

Use a formula to work out the total income for all the tickets

    • Help: Go to cell Y10 and enter the formula =sum(y4:y8)

Step 3: Pay Expenses

We need to pay for things such as staff and equipment. Starting with 'Lasers' choose how many you want for the show.

Next, use a formula to multiple the cost by how many you want.

  • Help: The formula for lasers in cell Y21 is =W21*X21

Step 4: Have we made a profit?

Let's find out the total of all the expenses added together.

  • Go to cell Y29 and press = to add a formula. Select SUM

Profit will tell you how much money you have left over after you have paid for all your expenses.

  • Type this formula into cell Y30 to work out the profit =Y10-Y29

Can you make your profit as close to £10,000 as possible?

  • Change the numbers in the 'How Many' column on your expenses to see what happens.

Step 4: Making Graphs to show The Boss

Highlight the ticket sales data for your graph and press the 'chart' button'

Next, highlight the expenses data for your graph and press the 'chart' button'

Important: Copy and Paste your graph onto the 'Charts' page at the bottom of the screen