### Free Educational Resources

• > Exploring Excel 05 H1 Fine Art Dealer
+

# Exploring Excel 05 H1 Fine Art Dealer

##### Rating:
(1)
• (0)
• (0)
• (0)
• (0)
• (1)
Author: matthew stock
##### Description:

http://homework.plus/exploring-excel-05-h1-fine-art-dealer/

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

Instructions

Points Possible

1

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.

10

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

(more)
##### Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

No credit card required

26 Sophia partners guarantee credit transfer.

226 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 21 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial