Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
2. Create the following spreadsheet. Your Name UMC Theaters Ticket Sales Theater Cocoplace Sunset Walk Movies at the Riverside Fairway Gables Town and Country Totals ● ● October November 45750 38650 29750 34900 40150 42350 40500 25800 39800 45000 December 52700 42900 22300 32600 47500 Totals Use word wrap for headings Use app formulas for all totals Use borders and fills to create good visual effects Place the title (UMC Theaters Ticket Sales) in merged cells centered across the top of the table Create the following four charts (embedded in the spreadsheet). Be sure to add chart titles and axis titles as shown in the examples. (You may use different color themes.)

2. Create the following spreadsheet. Your Name UMC Theaters Ticket Sales Theater Cocoplace Sunset Walk Movies at the Riverside Fairway Gables Town and Country Totals ● ● October November 45750 38650 29750 34900 40150 42350 40500 25800 39800 45000 December 52700 42900 22300 32600 47500 Totals Use word wrap for headings Use app formulas for all totals Use borders and fills to create good visual effects Place the title (UMC Theaters Ticket Sales) in merged cells centered across the top of the table Create the following four charts (embedded in the spreadsheet). Be sure to add chart titles and axis titles as shown in the examples. (You may use different color themes.)

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question

Look at the images and follow the steps to create the spreadsheet.. Also show each steps in making the graphs given in the images.

2. Create the following spreadsheet. Your Name UMC Theaters Ticket Sales Theater October November December Totals Cocoplace Sunset Walk 45750 42350 52700 38650 40500 42900 Movies at the Riverside 29750 25800 22300 FairWay Gables Town and Country 34900 39800 32600 40150 45000 47500 Totals Use word wrap for headings Use appropriate formulas for all totals Use borders and fills to create good visual effects Place the title (UMC Theaters Ticket Sales) in merged cells centered across the top of the table Create the following four charts (embedded in the spreadsheet). Be sure to add chart titles and axis titles as shown in the examples. (You may use different color themes.) Totals by Month 200000 195000 190000 ITotals 185000 180000 October November December Month Sales
Transcribed Image Text:2. Create the following spreadsheet. Your Name UMC Theaters Ticket Sales Theater October November December Totals Cocoplace Sunset Walk 45750 42350 52700 38650 40500 42900 Movies at the Riverside 29750 25800 22300 FairWay Gables Town and Country 34900 39800 32600 40150 45000 47500 Totals Use word wrap for headings Use appropriate formulas for all totals Use borders and fills to create good visual effects Place the title (UMC Theaters Ticket Sales) in merged cells centered across the top of the table Create the following four charts (embedded in the spreadsheet). Be sure to add chart titles and axis titles as shown in the examples. (You may use different color themes.) Totals by Month 200000 195000 190000 ITotals 185000 180000 October November December Month Sales
Totals by Theater 160000 140000 120000 100000 80000 60000 ITotals 40000 20000 Cocoplace Sunset Movies at FairWay Gables Walk the Town and Riverside Country Theater Sales for Each Theater by Month 60000 50000 ICocoplace 40000 I Sunset Walk 30000 I Movies at the Riverside 20000 IFairWay I Gables Town and Country 10000 October November December Sales for Each Month by Theater 60000 50000 40000 1October 30000 INovember 20000 O December 10000 Cocoplace Sunset Gables Movies at FairWay the Walk Town and Riverside Country Sales
Transcribed Image Text:Totals by Theater 160000 140000 120000 100000 80000 60000 ITotals 40000 20000 Cocoplace Sunset Movies at FairWay Gables Walk the Town and Riverside Country Theater Sales for Each Theater by Month 60000 50000 ICocoplace 40000 I Sunset Walk 30000 I Movies at the Riverside 20000 IFairWay I Gables Town and Country 10000 October November December Sales for Each Month by Theater 60000 50000 40000 1October 30000 INovember 20000 O December 10000 Cocoplace Sunset Gables Movies at FairWay the Walk Town and Riverside Country Sales
Expert Solution
steps

Step by step

Solved in 3 steps with 12 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS