Jan's Working with Numbers

Start with: , ex5-1-theatertickets-Lastname-Firstname.xlsx in folder excel project5 [Created in previous exercise 5-1.]

The theater manager wants to know what percentage of total sales during August each of the ticket types was. In other words, he wants to be able to fill in the blanks in the following sentence:
Type _____ tickets were _____% of total sales in August. This compares each type to the total of actual sales.

You will use the Planning Checklist and construct such a sheet based on ex5-1-theatertickets-Lastname-Firstname.xlsx from your Class disk. You will use Subtotals to calculate how many of each ticket type were sold. You will have to sort first. Then you will create a pie chart to display the results.

1. Open ex5-1-theatertickets-Lastname-Firstname.xlsx from the excel project5 folder on your Class disk.
2. Save As with the name ex5-5-percentages-Lastname-Firstname.xlsx in the excel project5 folder of your Class disk.
   
3. Planning 1 Goals- In a Comment in cell A1, state the goals for the sheet.
   
4. Planning 2 Input/Output- In the Comment in cell A1, identify the output wanted and the input and formulas required.
   
5. Planning 3 Layout- Make changes to the layout and formatting so it will be easy to read and so that the percentages that the manager wants to see are especially obvious. Remove from the final version of the sheet the parts of the original that are not used, such as the play names and dates. Change the subtitle.

   Hints:
   1) From the second of the three tables you only need the data in the columns Ticket Type and # Sold.

   2) The original sheet created subtotals for each play. Remove those totals and the grand total and use Excel's Subtotals feature to create subtotals for each type of ticket. Remember to Sort first. Show only the type totals.

   4) Create the a pie chart of the percentages on the same sheet.

6. Planning 4 Test- Test your calculations by making a copy to Sheet3 and change the numbers on that sheet - easy numbers, realistic numbers, and special numbers.
   
7. Planning 5 Documentation - Document your design choices using comments in appropriate cells. Have all the comments print at the end.
   
8. Prepare to print: Create a header with your name and the date on the Left, the filename and sheet name in the Center, and Exercise Excel 5-5 on the Right. Spell Check. Print Preview. (All comments should print at the end.)
   
9.  Save.
   [ex5-5-percentages-Lastname-Firstname.xlsx]
   

10.   Print the sheet.
    Your print-out should show the table of values and the pie chart on one page and the comments on a second page. [Results will vary, of course.]