Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

20 Hide the legend. Add data labels for categories and percentages: remove value data labels. Change the font size to 16 pt, bold, and Black,

image text in transcribed
20 Hide the legend. Add data labels for categories and percentages: remove value data labels. Change the font size to 16 pt, bold, and Black, Text 1 font color for the data labels. 21 Explode the Masterwork Anniversary Edition slice by 15% and change the fill color to Light Blue. 22 Display the Christensen worksheet, click in any cell within the dataset, convert the data to a table, assign a table name Collection, and apply Green, Table Style Light 14. 23 Apply a conditional format to the range J9:354 that highlights cells where the value is greater than 200% with Green Fill with Dark Green Text. 24 Sort the dataset by Type of Art in alphabetical order and then within Type of Art, sort by Current Value from largest to smallest. 25 Set a filter to display art that equals Sold Out as the status. 26 Add a total row to display the sum of the Issue Price, Paid, and Current Values columns. Remove the total for the Note column. 20 Hide the legend. Add data labels for categories and percentages: remove value data labels. Change the font size to 16 pt, bold, and Black, Text 1 font color for the data labels. 21 Explode the Masterwork Anniversary Edition slice by 15% and change the fill color to Light Blue. 22 Display the Christensen worksheet, click in any cell within the dataset, convert the data to a table, assign a table name Collection, and apply Green, Table Style Light 14. 23 Apply a conditional format to the range J9:354 that highlights cells where the value is greater than 200% with Green Fill with Dark Green Text. 24 Sort the dataset by Type of Art in alphabetical order and then within Type of Art, sort by Current Value from largest to smallest. 25 Set a filter to display art that equals Sold Out as the status. 26 Add a total row to display the sum of the Issue Price, Paid, and Current Values columns. Remove the total for the Note column

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

Step: 3

blur-text-image

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

Microsoft SQL Server 2012 Unleashed

Authors: Ray Rankins, Paul Bertucci

1st Edition

0133408507, 9780133408508

More Books

Students also viewed these Databases questions