Final Excel

FINAL EXAM – Excel

Insert the following table into Sheet1 of an Excel Spreadsheet, keeping the cell references consistent.

• Copy the following table into a new Excel spreadsheet.Be sure to keep the cell data the same.
• Save your work as Carmen Sanchez_Q2
• At cell E3 enter the column titleSales Totals
• At cell F3 enter the column title Theatre Commission
• At cell A8 enter the column title Total: Tickets and Sales
• Find the sales amount for each concert
  • Create a formula and be sure to use an ABSOLUTE cell reference
  • Base the formula on the Adult, Child and Group prices in cells B10 and B12
• Find the Concert totals for Attending adults, children and groups and the total sales for all the concerts
• Find the Theatre?s Commission based on the Sales totals for each concert
  • Use an IF function to determine how much the theatre makes based on each show
  • Use an ABSOLUTE cell reference
  • Determine what is the TOTAL Commission the theatre makes
• Center the title (A1) across the table A1:F1
• Center the subtitle at B2 across the table B2:D2
• Center, Bold and make Italic the column titles
• Bold the Row titles
• Use the AutoFit Option to fix the column widths
• Change the Font, Font Size and Color of your Title
  • You Choose
• Change the font, font size and color of table cells
  • You choose
• Format the table to your liking.
• Be sure to format for the dollar amounts
• Adjust column widths again
• Change the name of the worksheet to CONCERT SALES
• Color the tab GREEN
• Change the page orientation to Landscape
• Use conditional format on the Sales Totals to highlight sales below $400,000.00
  • Use a Blue Background and Bold White letters
• Create a Column Chart showing the Concert and Ticket Sales
• Move the Graph to a new worksheet
  • Call the worksheet Ticket Sales and color the tab GREEN
  • ADD axis titles and ADD data labels
• Enter your name, Student ID number, Date and Instructor Name underneath the table at A15
• Re-Order the tabs so the chart is the 2^nd worksheet
• Complete the Document Properties with your name, subject and TAGS (min of 3)

CALCULATIONS

CONDITIONAL FORMAT

GRAPH