Showtime Video Rentals - Spreadsheet 1 - Weekly Income

Showtime use a spreadsheet programme to help work out how much they make each week.

You have set up a spreadsheet with information on it.

You now need to put the correct formulae in to column F to calculate the income that they receive

• First load up your speadsheet if it is not on the screen already

• Click in cell F12 and type in the above formula EXACTLY
• There is a way to make sure you get the correct cell names - Mr. Lowe will show you this.
• The formula for cell F13 will be similar but you will use C13 D13 and E13
• You can then add a formula in F19 to add it all up and give you a final income

You can now draw some graphs to show the weekly income visually...

BACK TO MAIN PAGE