Narrative

Greenwich Workshop Project Description: You atomic number 18 an analyst for an art movement that is an authorized Greenwich Workshop® mulct art dealer. You prepared a list of artwork by James Christensen and need to channelise the selective information using an analysis, subtotals, PivotTables, and PivotCharts to wait on you in analyzing the data, which you will do in this project. Instructions: For the figure of grading the project you are required to perform the pursuance tasks: Step| Instructions| Points come-at-able| 1| Start Excel. Download, save, and blossom forth the file named Exploring_e05_Grader_EOC.xlsx. | 0| 2| Sort the data on the Subtotals worksheet first by the reference towboat, then by the fraud column, both in alphabetical order. | 4| 3| Subtotal the data at each multifariousness in Type. Identify the highest exit price, estimated value, and percent increase.| 10| 4| Add an automatic outline to the Subtotals worksheet. Group th e first and uttermost name columns. Collapse the label columns, and then collapse columns created by the outline (G, H, and I).| 7| 5| Create a PivotTable on a refreshed worksheet using the data on the Christensen worksheet in the range A1:J19. Use the Type, Est. revalue, and homecoming Price fields and exercise the default locations in the PivotTable Layout.| 8| 6| Modify the make out Price and Est.

ottoman determine to determine the add up issuance price and average estimated market value by type.| 6| 7| put down a calculated field named % transfer in look upon to determine the percent change in values by type. Format the values in the new column as percentages with two decimal places. Format the values in the! fair of Issue Price and Average of Est. Value columns as bill values with no decimal places.| 11| 8| put down the custom name Average Issue Price for the issue price column. Enter Average Est. Value for the estimated value column. budge Row Labels in the first column to Art Type.| 3| 9| Set a trace filter to endanger only sold-out art. Filter the card to...If you want to witness a full essay, order it on our website: OrderEssay.net

If you want to get a full information about our service, visit our page: write my essay