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 2nd worksheet
  • Complete the Document Properties with your name, subject and TAGS (min of 3)

A

B

C

D

E

1

Yearly Summary of Concerts

2

Tickets Sold

3

Adult Sales

Child Sales

Group Sales

4

Christmas Concert

7852

2150

450

5

Easter Eggstravaganza

6975

1165

250

6

Summer Concert

9871

2300

675

7

Broadway Special

11250

975

1268

8

9

10

Adult Ticket Price

35.95

Commission

normal

$400,000

11

Child Ticket Price

17.85

11.3%

16.10%

12

Group Sale Ticket Price

29.85

CALCULATIONS


CONDITIONAL FORMAT

GRAPH

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-8hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now

Do you have an upcoming essay or assignment due?

All of our assignments are originally produced, unique, and free of plagiarism.

If yes Order Paper Now