Chat with us, powered by LiveChat Painted Paradise Resort Quarter 1 Entertainment Log Excelsheet Help | Abc Paper
+1(978)310-4246 credencewriters@gmail.com
  

apply the steps to the workbook excel. and thank you
alshammary_e04_grader_h2_entertainment.xlsx

yo16xlbu04graderps2hw___entertainment_13_instructions.docx

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
20190402030536alshammary_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
20190402030536alshammary_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
20190402030536alshammary_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
20190402030536alshammary_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
20190402030536alshammary_e04_grader_h2_entertainment.xlsx
Entertainment Type
Live – Country
Live – Jazz
Live – Cover Band
Live – Piano
DJ
Other
20190402030536alshammary_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

Our essay writing service fulfills every request with the highest level of urgency.
attachment

error: Content is protected !!