e04 grader h2 Entertainment

Anonymous
timer Asked: Apr 15th, 2019
account_balance_wallet $10

Question Description

Project Description:

The Painted Paradise Resort & Spa is a favorite spot for many locals to visit on a Friday night because of the live entertainment in the Silver Moon Lounge. The lounge has quarterly contracts with 13 popular local bands; each band will play in the lounge once a quarter. Lounge manager Will Diaz would like to keep track of quarterly and yearly expenses for the entertainment. He has started a workbook but has asked you to complete it. You will begin by summarizing the quarterly worksheets and consolidating the data. You will also share a copy with the assistant manager to update any necessary items.

The WORD FILE IS AN INSTRUCTION ONLY. SO YOU DON'T HAVE TO DO ANYTHING ON IT.

Unformatted Attachment Preview

Quarter 1 Entertainment Log Date 1/5/2018 1/12/2018 1/19/2018 1/26/2018 2/2/2018 2/9/2018 2/16/2018 2/23/2018 3/2/2018 3/9/2018 3/16/2018 3/23/2018 3/30/2018 Entertainment Name Wolfpack Silver Eagles Harmonious Harmony Perfect Piano Paradise Just Jazz Puttin on the Hits Singing in the Rain Almost Paradies Dusty Boots Rockin Reds Simple Sounds Scerenity Too Hot to Hold Type Live - Country Live - Cover Band Other Live - Piano Live - Jazz Other Live - Country Live - Jazz Live - Country Live - Cover Band DJ Live - Piano Live - Cover Band Total 20190415023824alfarj_e04_grader_h2_entertainment.xlsx Hours Performed 3 4 4 3 3 4 3 3 3 4 4 3 4 $ $ $ $ $ $ $ $ $ $ $ $ $ Price 450,00 495,00 425,00 400,00 475,00 400,00 425,00 475,00 490,00 525,00 425,00 450,00 525,00 Quarter 2 Entertainment Log Item 4/6/2018 4/13/2018 4/20/2018 4/27/2018 5/4/2018 5/11/2018 5/18/2018 5/25/2018 6/1/2018 6/8/2018 6/15/2018 6/22/2018 6/29/2018 Entertainment Name Wolfpack Silver Eagles Harmonious Harmony Perfect Piano Paradise Just Jazz Puttin on the Hits Singing in the Rain Almost Paradies Dusty Boots Rockin Reds Simple Sounds Scerenity Too Hot to Hold Type Total 20190415023824alfarj_e04_grader_h2_entertainment.xlsx Hours Performed Price 4 4 4 3 3 4 3 3 3 3 4 4 4 Quarter 3 Entertainment Log Item 7/6/2018 7/13/2018 7/20/2018 7/27/2018 8/3/2018 8/10/2018 8/17/2018 8/24/2018 8/31/2018 9/7/2018 9/14/2018 9/21/2018 9/28/2018 Entertainment Name Wolfpack Silver Eagles Harmonious Harmony Perfect Piano Paradise Just Jazz Puttin on the Hits Singing in the Rain Almost Paradies Dusty Boots Rockin Reds Simple Sounds Scerenity Too Hot to Hold Type Total 20190415023824alfarj_e04_grader_h2_entertainment.xlsx Hours Performed Price 3 4 4 3 3 4 4 3 3 4 4 3 4 Quarter 4 Entertainment Log Item 10/5/2018 10/12/2018 10/19/2018 10/26/2018 11/2/2018 11/9/2018 11/16/2018 11/23/2018 11/30/2018 12/7/2018 12/14/2018 12/21/2018 12/28/2018 Entertainment Name Wolfpack Silver Eagles Harmonious Harmony Perfect Piano Paradise Just Jazz Puttin on the Hits Singing in the Rain Almost Paradies Dusty Boots Rockin Reds Simple Sounds Scerenity Too Hot to Hold Type Total 20190415023824alfarj_e04_grader_h2_entertainment.xlsx Hours Performed Price 3 4 3 3 4 4 4 3 3 3 4 3 4 Yearly Entertainment Log Entertainment Wolfpack Silver Eagles Harmonious Harmony Perfect Piano Paradise Just Jazz Puttin on the Hits Singing in the Rain Almost Paradies Dusty Boots Rockin Reds Simple Sounds Scerenity Too Hot to Hold Total Price 20190415023824alfarj_e04_grader_h2_entertainment.xlsx Entertainment Type Live - Country Live - Jazz Live - Cover Band Live - Piano DJ Other 20190415023824alfarj_e04_grader_h2_entertainment.xlsx Office 2016 – myitlab:grader – Instructions Excel Project YO16_XL_BU04_GRADER_PS2_HW - Entertainment 1.3 Project Description: The Painted Paradise Resort & Spa is a favorite spot for many locals to visit on a Friday night because of the live entertainment in the Silver Moon Lounge. The lounge has quarterly contracts with 13 popular local bands; each band will play in the lounge once a quarter. Lounge manager Will Diaz would like to keep track of quarterly and yearly expenses for the entertainment. He has started a workbook but has asked you to complete it. You will begin by summarizing the quarterly worksheets and consolidating the data. You will also share a copy with the assistant manager to update any necessary items. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Open the downloaded Excel file, e04_grader_h2_Entertainment.xlsx. Save your file as e04_grader_h2_Entertainment_LastFirst, using your last and first name. Enable Content if necessary. 0.000 2 Group the Q1 through Q4 worksheets. Change the color of the worksheet tabs to White, Background 1, Darker 50%. 8.000 3 With the worksheets still grouped, on the Q1 worksheet, select cell range E4:E16. Fill All across the sheets (Q1:Q4). 24.000 4 With the worksheets still grouped, on the Q1 worksheet, select cell range A3:E3. Fill the Formats across the worksheets (Q1:Q4). 24.000 5 With the worksheets still grouped, enter a formula in cell E17 to calculate the total of column E prices. 8.000 6 A data validation to select from the Type list from the Type worksheet has been created on the Q1 worksheet but is not on the Q2 through Q4 worksheets. With the worksheets still grouped, on the Q1 worksheet, select cell range C4:C16. Fill All across the sheets. Ungroup the worksheets. 12.000 7 On the Year worksheet, in cell range B4:B16, enter a 3D formula using the SUM function to calculate the total amount spent on each entertainment group during Q1:Q4. In cell B17, enter a formula to total the Price column. 10.000 8 Hide the Type worksheet. Save the workbook. 6.000 9 If necessary, add the Compare and Merge Workbooks button to the Quick Access Toolbar. Share the workbook, and then save a copy of the workbook as e04_grader_h2_Entertainment2_LastFirst, using your last and first name. Note, Mac users will not add the Compare and Merge Wookbooks button to the Quick Access Toolbar. 0.000 You received notification from the entertainment group Singing in the Rain that the price of Updated: 10/23/2017 1 Current_Instruction.docx Office 2016 – myitlab:grader – Instructions Step Excel Project Points Possible Instructions their services has increased to 450. Make this price adjustment on the Q1:Q4 worksheets in cell E10. Save and close the workbook, but leave Excel open. 10 Open e04_grader_h2_Entertainment_LastFirst. Compare and merge the workbook with e04_grader_h2_Entertainment2_LastFirst. Save all the changes on a new worksheet. Stop sharing the workbook. Note, for Mac users the Merge command can be found on the Tools menu. 8.000 11 Save the workbook, exit Excel, and then submit your e04_grader_h2_Entertainment_LastFirst file as directed by your instructor. 0.000 Total Points Updated: 10/23/2017 2 100.000 Current_Instruction.docx ...
Purchase answer to see full attachment

Tutor Answer

ProfessorArthur
School: Rice University

At...

flag Report DMCA
Review

Anonymous
awesome work thanks

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors