Scribd
Upload
192 views2 pages

Exercise 4.6

The document provides instructions for a spreadsheet exercise to create a spreadsheet to track concert venue costs and profits. It involves entering venue and cost data, performing calculations for total costs, maximum income and profit/loss, adding and deleting rows, and formatting and printing the spreadsheet.

Uploaded by

Jelyn Okeke
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
192 views2 pages

Exercise 4.6

The document provides instructions for a spreadsheet exercise to create a spreadsheet to track concert venue costs and profits. It involves entering venue and cost data, performing calculations for total costs, maximum income and profit/loss, adding and deleting rows, and formatting and printing the spreadsheet.

Uploaded by

Jelyn Okeke
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
You are on page 1/ 2

CLAIT

Unit 4 Spreadsheets

Exercise 6

1. Load Excel.

2. Enter the title Concerts.

3. Under the title enter the following column headings:

Venue Hall Artist Total Ticket Size of Maximum Profit/


Cost Cost Cost Price Hall Income Loss

4. The first heading Venue should be left-justified. The other headings


should be right-justified.

5. Under the Venue heading enter the following row labels:

Cardiff Bristol
Leeds York
Lancaster Glasgow
Dublin

6. Enter the following data:

Venue Hall Artist Total Ticket Size of


Cost Cost Cost Price Hall
Cardiff 1200 2500 10 1500
Bristol 1600 2000 15 800
Leeds 800 2500 8 600
York 750 2000 7.50 850
Lancaster 875 2000 9.50 1200
Glasgow 1100 1500 12 1600
Dublin 950 1500 10 1375

7. Insert a footer with your name left aligned and today’s date right
aligned.

8. Save the data and print the spreadsheet.

9. The Leeds venue is no longer available but an alternative is found.


Change Leeds to Eastbourne.

10. Increase the width of the Venue column to display Eastbourne in full.
The Eastbourne Hall Cost is £1550; amend the cell accordingly.

CLAIT Unit 4 1 of 2
Exercise 4.6
11. The Glasgow concert has been cancelled. Delete the row for Glasgow.
Make sure you do not leave a blank row.

12. Use a formula to calculate the Total Cost of the Cardiff venue.
Replicate this formula to obtain the Total Costs for each of the other
venues.

13. Calculate the Maximum Income for Cardiff. Replicate this formula to
obtain the Income for each of the other venues.

14. Calculate the Profit/Loss for the Cardiff venue. Replicate this formula
to obtain the Profit/Loss for each of the other venues.

15. Provide a printout showing the formulae that have been used.

16. Add a new column after Artist Cost and before Total Cost called
Admin Cost. The heading should be right-justified.

17. Enter the following data:

Cardiff 1200
Bristol 1050
Eastbourne 450
York 890
Lancaster 1200
Dublin 1600

18. Adjust the formula calculating Total Cost to include Admin Costs for
all the venues.

19. Display the data in the Ticket Price column to two decimal places, all
other numeric data should be displayed in integer format.

20. Save and print the spreadsheet.

21. Close the file.

CLAIT Unit 4 2 of 2
Exercise 4.6

You might also like