Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Capstone exercise excel 2016 chapter 1

25/04/2021 Client: muhammad11 Deadline: 2 Day

Author: Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. CMPTR Excel 2016 | Chapter 15: SAM Project 1a Silver Screen Cinemas CREATING AN ADVANCED WORKBOOK Deborah Adu not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. Silver Screen Cinemas Standard Tick Event ID PU-0805-1,2 PR-0806-3,4 Date 08/05/16 08/06/16 08/07/16 08/08/16 08/09/16 08/10/16 08/11/16 08/12/16 08/13/16 Screens 1,2 3,4 3,4,5 2,5 6,7 6,7 5,8 5,8 7,8,9 Movie Spacewalk 4 Cross the Range The Great Gamble A Touch of Gold Dry Heat The Perfect Home Minutes in Mississippi Before the Visit Impossible Task 2 Total Event Type Tickets Public 60 Private 90 Special 120 Private 60 Public 90 Public 90 Private 60 Private 60 Special 120 Profit per Tic Ticket Type Standard Tickets VIP Tickets Standard Tickets VIP Tickets Tickets Remaining Sold Tickets 48 60 72 46 32 65 20 31 45 12 30 48 14 58 25 40 29 75 Ticket Price $ $ $ $ $ $ $ $ $ 10 15 25 15 10 10 15 15 25 Total Tickets Remaining Tickets Sold Tickets 15 25 30 15 25 25 15 15 30 6 18 15 11 16 0 9 7 13 9 7 15 4 9 25 6 8 17 Ticket Price $ $ $ $ $ $ $ $ $ 15 25 40 25 15 15 25 25 40 Tickets Sold 54 78 87 57 48 65 29 38 58 Total Revenue Profit per Ticket Type Ticket Type Standard Tickets VIP Tickets Center Revenue Percentage 80% 65% House Staff Required Extra Setup? Silver Screen Cinemas 42 Silver Screen Drive Austin, TX 78718 Info@sscine.example.com 877-530-3643 Contact Information Name Estela Degen Address 1 1883 Corral Park Road Address 2 City Austin State TX Postal Code 78709 Phone Number 543-625-9668 Email Address e.k.degan@example.com Silver Subscriber Yes Event ID Movie 0 The Great Gamble 0 Minutes in Mississippi Date Ticket Type Cost 8/7/2016 VIP $ 40,00 8/11/2016 Standard $ 15,00 Order # Order Date Delivery Option 1853 7/24/2016 Digital Delivery Charges Pick-up $ Digital $ Mail $ Quanity 1,50 2,50 Total 8 $ 320,00 53 $ 795,00 Subtotal Subscriber Discount Delivery Total $ 1.115,00 $ 1.115,00 CMPTR Excel 2016 | Chapter 15: SAM Project 1a Silver Screen Cinemas CREATING AN ADVANCED WORKBOOK GETTING STARTED • Open the file CMPTR_EX16_15a_FirstLastName_1.xlsx, available for download from the SAM website. • Save the file as CMPTR_EX16_15a_FirstLastName_2.xlsx by changing the “1” to a “2”. o • If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically. With the file CMPTR_EX16_15a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. o If cell B6 does not display your name, delete the file and download a new copy from the SAM website. PROJECT STEPS 1. You are employed at Silver Screen Cinemas, a luxury movie theater that pairs a full restaurant experience with the big screen. The theater features nine screens and three types of events, as well as a full-sized kitchen and wait staff. Your manager has asked you to make a spreadsheet to keep track of ticket sales and revenue from each film. Switch to the August Movies worksheet. In cell A11, type SP-0807-3,4,5. Select the range A9:A17, and then use Flash Fill to fill the values into the range A12:A17. 2. Clear the conditional formatting rule from the range E9:E17. 3. Because of the limited amount of seating for each screen, it would be helpful to have a visual cue to quickly see when the number of remaining tickets gets low. In the range H9:H17, use conditional formatting to apply Highlight Cells Rules to cells with a value less than 15 with Light Red Fill with Dark Red Text. 4. In the range L9:L17, use conditional formatting to apply Highlight Cells Rules to cells with a value less than 10 with Light Red Fill with Dark Red Text.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

University Coursework Help
Math Guru
Pro Writer
Smart Accountants
24/7 Assignment Help
Engineering Guru
Writer Writer Name Offer Chat
University Coursework Help

ONLINE

University Coursework Help

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$16 Chat With Writer
Math Guru

ONLINE

Math Guru

I have read your project details. I can do this within your deadline.

$36 Chat With Writer
Pro Writer

ONLINE

Pro Writer

I have read and understood all your initial requirements, and I am very professional in this task.

$38 Chat With Writer
Smart Accountants

ONLINE

Smart Accountants

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$22 Chat With Writer
24/7 Assignment Help

ONLINE

24/7 Assignment Help

I have read and understood all your initial requirements, and I am very professional in this task.

$18 Chat With Writer
Engineering Guru

ONLINE

Engineering Guru

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$18 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Conservation of energy at the skate park answers - Drill press safety quiz - Health and human development unit 1 and 2 - 10 amp h bridge - Market mapping bbc bitesize - Lady shaw building cuhk - Breezypythongui - Problem solution persuasive speech outline - Gagne model of learning - Boy at the window poem analysis - Sam walton jay z by george packer - Seamus heaney the call - Jeffrey lu jasper jones - Hamlet act 1 questions pdf - Https edu gcfglobal org en excel2016 - Apm employment services blacktown - Eliminate reduce raise create grid - Federal Reserve and the Great Recession Analysis - A candidate for mayor in a small town has allocated - Research paper 10 pages - Forwarder receiver design pattern - Chick fil a international expansion - Capella university organizational chart - A bond quote of 82.25 in dollars is equal to: - John butler trio and keith urban - Ima statement of ethical professional practice citation - Latin america and the caribbean david clawson pdf - Pharmacology - British universities and colleges sport - What is an anti pattern for teams during pi planning - Need help on two assignments Quality Control - In leaves no step had trodden black figure of speech - Weather station model practice answers - Drafting materials and tools drawing instrument - Austin brown unchained melody - Girls global education fund ggef - Communication - Short Writing #2 (SW-2): Research Action Plan - Commonwealth bank eftpos help - Learn lboro ac uk - Www atrrs army mil channels chrtas - The invisible goldmine strategy - Nursing Theory - Appeal to fear examples - Http testingforschools com code - Weighted moving average forecast calculator - How to open fiori launchpad from gui - How to draw a frequency polygon in excel - Biomedical optics express template - Identify a reform that took place during the Progressive era. This could include Constitutional amendments, movements among women or laborers, changes in technology, changes in family structure, and changes in laws. - PowerPoint due in 8 hours - Blog 2 - Andrew jackson's letter to the cherokee - Worldventures cancellation and refund - Diagnostic Assignment - Resource pooling in cloud computing examples - Assignment - Criticize snidely crossword puzzle clue - Osha test questions and answers - Apply - Your Career - Significance of Air Freight in Military Aviation - Why did kfc discontinue honey bbq wings - Passwords must have at least one uppercase a z - The espresso lane to global markets cage analysis - DQ - Rock cycle fill in the blank worksheet and answers - First computer inventor name - Calculate ka from pka - Discussion Question 1 week 9 - Bus419 project proposal - Volar by judith ortiz cofer central idea - Evaporation and intermolecular forces - A positive charge is kept (fixed) at the center inside a fixed spherical neutral conducting shell. - Weight Loss and Societal Influences - My father's hands calvin worthington questions - University of sydney endnote - Casestdy - HCA320 Assignment Mod 2: - Shangri-la sapelo wooden kitchen trolley - Philosophy - Chocolate diamond rings at jc penneys - Explain the analogy twain uses in paragraph 3 - Asme b30 8 pdf - 6 Pages: 6 References - Double entry journal template - Complete a rough draft of the problem/solution proposal assignment. - 0 100 rule earned value - L oreal case study analysis - Savitramma and the diet medicine - Gattaca movie questions biology answers - Non sequitur examples in commercials - Identify where and how ikea has achieved cost leadership - Cover Letter Draft for Peer Review - Java joptionpane while loop example - How does psychology affect your everyday life - Discussion Board 2: Beach Mouse Experiment - Week 2 nurs 500 - Camp fred loser song lyrics - Jp morgan mason - Denver airport case study project management