I have no idea how to do this any help with every single step?

​

Office 2013 – myitlab:grader – Instructions Exploring Excel 05 H1 Fine Art Dealer
Project Description:
You are an analyst for an authorized Greenwich Workshop® fine art dealer
(www.greenwichworkshop.com). Customers are especially fond of James C. Christensen’s art. The
Subtotals worksheet contains a list of artwork released in 2010-2012. You want to calculate
subtotals by Type of art (e.g. Limited Edition Canvas) for Issue Price and Est. Price. The Art
worksheet contains artwork from 2004-2006. Studying this data will help you discuss value trends
with art collectors.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step Points
Possible Instructions 1 Start Excel. Open the downloaded Excel file named
exploring_e05_grader_h1_start.xlsx. 0 2 In the Subtotals worksheet, sort the data by Type and then by Name of Art, both in
alphabetical order. 5 3 In the Subtotals worksheet, use the Subtotals feature to identify the highest Issue
Price and Est. Value by Type. 5 4 Use the Art worksheet to create a blank PivotTable on a new worksheet named
PivotTable. 5 5 Include the Type, Release Date, and Issue Price fields in the PivotTable. Remove the
Release Date field and add the Est. Value field to the PivotTable. 5 6 Modify the two VALUES fields to determine the Average Issue Price and Average
Est. Value instead of the Sum. Change the custom name to Average Issue Price
and Average Est. Value, respectively. 7 Format the two VALUES fields with Accounting Number type with zero decimal
places. 5 8 Insert a calculated field on the right side of the PivotTable to calculate the
percentage increase in value from the Issue Price to the Est. Value. Accept the
default field name, Field1. 5 9 Format the calculated field with Percent type with two decimal places. Use the
custom name Percentage Change. 5 Updated: 07/17/2013 1 10 E_CH05_EXPV2_H1_Instructions.docx Office 2013 – myitlab:grader – Instructions Step Exploring Excel 05 H1 Points
Possible Instructions 10 Type Type in cell A3 and Overall Averages in the cell containing the text Grand
Total. 5 11 Set a filter to display only sold-out art (indicated by Yes). 5 12 Apply Pivot Style Medium 5, display banded columns, and display banded rows. 13 Use the Art worksheet to create a PivotChart on a new sheet named PivotChart.
Change the chart type to Clustered Bar. 5 14 Include the Type, Issue Price, and Est. Value fields. Set a filter to display only soldout art (indicated by Yes) for the PivotChart. 10 15 Hide the field buttons in the PivotChart. Insert a chart title above the chart and
type 2005-2007 Art. 5 16 Format the value axis with Accounting with zero decimal places. Apply 8-pt size to
the category axis and value axis. Apply 7-pt size to the legend. 5 17 Adjust the size of the PivotChart for the range D1:K14. 5 18 Sort the data in the PivotChart’s PivotTable in reverse alphabetical order by Type.
Type Art Type in cell A3 and type Overall Averages in the cell containing the
text Grand Total. 5 19 Ensure that the worksheets are correctly named and placed in the following order
in the workbook: Subtotals, PivotTable, PivotChart, Art. Save the workbook. Close
the workbook and then exit Excel. Submit the workbook as directed. 0 Total Points Updated: 07/17/2013 2 10 100 E_CH05_EXPV2_H1_Instructions.docx

 

Name of Art
Tie That Binds, The
Tie That Binds, The
Angel Unobserved
Jonah
Tempus Fugit
Benediction
Benediction
Golden Ball, The
Pilates
Oldest Angel, The
Grace
Chess Match, The
Chess Match, The
Chess Match, The
Butterfly Knight
Shakespearean Fantasy
Shakespearean Fantasy
College of Magical Knowledge Personal Commission
College of Magical Knowledge Personal Commission
Nest, The
Desirable Above All Other Fault
Three Wise Men in a Boat
Hold to the Rod, the Iron Rod
Arise and Shine Forth
Pilgrim Angel
Two Sisters
Arise and Shine Forth
Arise and Shine Forth
One Light
Guardian in the Woods
Guardian in the Woods
Man Taking a Leek on a Tiled Wall for a Walk
Lawyer More than Adequately Attired in Fine Print, A
Princess in the Tower
Passage by Faith
Passage by Faith
Christmas Pig, The Type
Limited Edition Print
Limited Edition Canvas
Smallwork Canvas Edition
Anniversary Edition Canvas
Smallwork Canvas Edition
Masterwork Anniversary Edition
Anniversary Edition Canvas
Limited Edition Canvas
Smallwork Canvas Edition
Anniversary Edition Canvas
Open Edition Canvas
Museum Edition Canvas
Limited Edition Canvas
Limited Edition Print
Smallwork Canvas Edition
Masterwork Canvas Edition
Limited Edition Canvas
Anniversary Edition
Anniversary Edition
Limited Edition Canvas
Open Edition Canvas
Limited Edition Canvas
Limited Edition Print
Masterwork Canvas Edition
Smallwork Canvas Edition
Anniversary Edition Canvas
Open Edition Canvas
Poster
Anniversary Edition Canvas
Limited Edition Canvas
Limited Edition Print
Smallwork Canvas Edition
Anniversary Edition Canvas
Limited Edition Canvas
Limited Edition Print
Limited Edition Canvas
Smallwork Canvas Edition Issue Price
$
250
$
750
$
225
$
425
$
195
$
995
$
495
$
325
$
275
$
395
$
125
$
2,950
$
695
$
225
$
225
$
950
$
495
$
950
$
495
$
495
$
195
$
295
$
175
$
1,250
$
225
$
695
$
395
$
20
$
245
$
395
$
195
$
195
$
475
$
245
$
165
$
475
$
195 Est. Value
$
250
$
750
$
541
$
425
$
195
$
995
$
495
$
325
$
275
$
395
$
125
$
1,070
$
852
$
225
$
322
$
1,301
$
495
$
950
$
495
$
495
$
195
$
295
$
175
$
1,250
$
225
$
695
$
395
$
20
$
245
$
395
$
195
$
195
$
475
$
245
$
165
$
475
$
195 Art
Type
Dusk
Limited Edition Canvas
St. Brendan The Navigator
Limited Edition Canvas
St. Brendan The Navigator
Limited Edition Print
Once Upon a Time
Masterwork Anniversary Edition
Enoch Altarpiece framed, The
Limited Edition Canvas
Messenger, The
Limited Edition Print
Poofy Guy on a Short Leash
Limited Edition Canvas
Poofy Guy on a Short Leash
Limited Edition Print
St. Nicholas of Myra
Limited Edition Canvas
Twilight
Limited Edition Canvas
Twilight
Limited Edition Print
Royal Processional, The
Masterwork Anniversary Edition
Saint with White Sleeves
Limited Edition Canvas
Saint with White Sleeves
Limited Edition Print
Bride, The
Limited Edition Canvas
Bride, The
Limited Edition Print
Madonna with Two Angeles framed
Limited Edition Canvas
Cecelia
Masterwork Canvas Edition
Cecelia
Limited Edition Print
Pink Ribbon, The
Open Edition Print
Finding Fish
Litho Hand Colored Print
Gift for Mrs. Claus, The
Anniversary Edition
Pink Ribbon, The
Limited Edition Canvas
If Pigs Could Fly
Limited Edition Canvas
Listener, The
Limited Edition Canvas
Listener, The
Limited Edition Print
Michael the Archangel Battles the Dragon While Almost N Limited Edition Canvas
Michael the Archangel Battles the Dragon While Almost N Masterwork Canvas Edition
Michael the Archangel Battles the Dragon While Almost N Limited Edition Print
Responsible Woman, The
Anniversary Edition Canvas
Men and Angels
Limited Edition Canvas
Men and Angels
Limited Edition Print
Angel with Epaulet
Limited Edition Canvas Release Date Sold Out
Jan-04 Limited Availability
Jan-04 Yes
Jan-04 Limited Availability
Mar-04 Yes
Jun-04 Yes
Jun-04
Aug-04 Limited Availability
Aug-04 Limited Availability
Aug-04 Yes
Oct-04 Yes
Oct-04 Limited Availability
Jan-05 Yes
Mar-05 Yes
Mar-05 Limited Availability
May-05 Yes
May-05 Yes
Jun-05 Limited Availability
Aug-05 Yes
Sep-05 Yes
Sep-05
Oct-05
Oct-05 Yes
Oct-05 Limited Availability
Jan-06 Limited Availability
Mar-06 Yes
Mar-06 Limited Availability
Apr-06 Limited Availability
Apr-06 Yes
May-06 Limited Availability
Aug-06 Yes
Sep-06 Yes
Sep-06 Yes
Dec-06 Yes Issue Price
$
495
$
250
$
140
$
1,750
$
1,595
$
775
$
495
$
160
$
260
$
495
$
160
$
1,250
$
395
$
150
$
475
$
145
$
595
$
995
$
195
$
30
$
775
$
425
$
250
$
325
$
650
$
195
$
775
$
1,450
$
175
$
650
$
375
$
135
$
150 Est. Value
###
###
###
$
3,920
###
###
###
$
178
###
###
$
173
###
$
419
###
$
600
$
251
###
$
1,070
$
767
###
$
1,066
$
488
###
###
###
$
281
###
###
###
$
1,448
$
1,495
$
248
$
173

• 1493184120-Loredo_exploring_e05_grader_h1_start.xlsx

ComputerScienceExpert

(11)

Status NEW Posted 26 Apr 2017 05:04 AM My Price 11.00

-----------

Attachments

file 1493184125-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer