Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I finished most of the project but am stuck on these 3 points. Please advise where to goto to change this. 16. Format the value

I finished most of the project but am stuck on these 3 points. Please advise where to goto to change this.

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

17. Adjust the size of the PivotChart for the range D1:K14.

18. Sort the data in the PivotCharts 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.image text in transcribed

Sold out Yes Row Labels Sum of Issue Price Sum of Est. Value 425 Anniversary Edition 88 Anniversary Edition Canvas 650 1,448 4645 Limited Edition Canvas 5,937 475 Limited Edition Print 1,266 Masterwork Anniversary Edition 3000 5,170 2445 Masterwork Canvas Edition 2,520 Grand Total 16828 11640 Sold Out Sum of Issue Price Sum of Est. Value 2005-2007 Art Masterwork Canvas Masterwork Anniversary. Type Limited Edition Print r Values Limited Edition Sum of Est. Value Canvas Sum of Issue Price Anniversary Edition. Anniversary Edition 2000 4000 6000 8000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Extinction Governance Finance And Accounting

Authors: Jill Atkins, Martina Macpherson

1st Edition

0367492989, 978-0367492984

More Books

Students also viewed these Finance questions