1. Open the "exceldata.xls" file in Excel. This file can be found on the M drive, _student folder, Intro to Computers folder.

2. Hide all columns except A, B, O, and P. Click here for help.

3. Insert three blank rows at the very top of the spreadsheet.

4. Starting in row 3, column A, enter the following column titles (using bold and uppercase letters) in this order from left to right: “PRODUCER”, “DEPARTMENT”, "TICKETS SOLD", and "TICKET PRICE".

5. Center the column headings. Click here for help.

6. For all cells, turn on the wrap text feature. Click here for help.

7. Make the columns wide enough so that each column title has no more than two words per line. Make sure no words are split between two lines.

8. Set the vertical alignment of each column title to bottom. Click here for help.

9. Between the “TICKETS SOLD" and “TICKET PRICE” columns, insert a column labeled “REVENUE” (use bold and uppercase letters).

10. In the “REVENUE" column, create a formula that calculates the money received via ticket sales (“TICKETS SOLD multiplied by TICKET PRICE”). Calculate this value for all the movies.

11. Sort the spreadsheet by “DEPARTMENT” in alphabetical order from A to Z. Click here for help.

12. Filter the spreadsheet so that it shows only departments beginning with R through Z. Click here for help.

13. Enter the row title “AVERAGE” in cell B30 (right-justify using bold and uppercase letters).

14. In row 30, use the AVERAGE function to calculate the average amount for columns O, P and Q. Make each average bold.

15. Change all cells to Arial font, size 12.

16. Autofit the "PRODUCER" column. Click here for help.

17. Format the numbers in the "REVENUE" and "TICKET PRICE" columns as currency with 2 decimal places.

18. In cell B1 enter your name.

19. In cell B2 enter the date.

20. Center the data in cells B1 and B2.

21. Print the filtered spreadsheet in portrait orientation showing gridlines. Make the spreadsheet fit on one page with all data showing, but without changing font size or type. Do NOT use the Fit to 1 page feature. How do I show gridlines?

22. Print the filtered spreadsheet, in portrait orientation, on one page, showing all formulas, showing gridlines and showing row and column headings. Use the Fit to 1 page feature. How do I show row and column headings? How do I show row and column headings?

23. Create a clustered column chart that uses the following data: “PRODUCER”, “TICEKETS SOLD", and “REVENUE" on the filtered spreadsheet. Make sure that the producer names appear on the X-axis.
>Title the chart “Tickets Sales” and include your name as part of the title.
>Label the X-axis of the chart “Producer”.
>Label the Y-axis of the chart “Ticket Data”.
>Create the chart as a new sheet.
>Change the font of the producer names to Times New Roman font, size 14.

24. Print the column chart.