Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hello, I need help with the following steps, or questions: 11 Select the range B3:D3 and apply these formats: wrap text and Align Right horizontal

Hello, I need help with the following steps, or questions:

image text in transcribed

11

Select the range B3:D3 and apply these formats: wrap text and Align Right horizontal alignment. Set the height of Row 3 to 60 and set the width of Columns B through D to 10. (Columns B:D). Type Type of Art in cell A3 and Average of All Art in cell A11.

2

12

Set a filter to display only sold-out art (indicated by Yes).

2

13

Apply Light Blue, Pivot Style Light 23 and display banded columns. Note, depending upon Office version used, style name may be Pivot Style Light 23.

2

14

Insert a slicer for the Sold Out field, change the slicer height to 1.5 inches and apply the Light Blue, Slicer Style Dark 1. Move the slider below the PivotTable. Note, depending upon the Office version used, the style name may be Slicer Style Dark 1.

2

15

Insert a timeline for the Release Date field, change the time period to YEARS, change the timeline width to 4 inches, and move the timeline below the slicer. Note, Mac users continue to the next step.

1

16

Create a clustered bar PivotChart from the PivotTable. Move the PivotChart to a new sheet named PivotChart. Hide the field buttons in the PivotChart. Note, Mac users, select the range A3:D10 and insert a clustered bar chart. Ensure that the legend displays the field names from row 3, and then move the chart to a new sheet named PivotChart.

2

17

Add a chart title and type Values for Sold-Out Art. Apply chart Style 12.

2

18

Apply 11 pt font size to the value axis and the legend.

2

19

Create a footer on all worksheets (except Art) with your name in the left section, the sheet name code in the center section, and the file name code in the right section.

2

20

Ensure that the worksheets are correctly named and placed in the following order in the workbook: Subtotals, PivotChart, Sold Out, Art. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.

0

1 Title 2 Sleeper Lost in Dr2ams 3 Sleeper Lost in Dreams 4 Touching the Her of God 5 Portrait with Red 3eries s Isabella 7 Isabella 8 Once Upon a Time 9 Bride, Thie 10 Madonna with Two Angeles framed 11 Ceceli 12 Cecelia 13 Gift for Mrs. Claus, The 14 Michael the Archengel Battles the Dragon While Alm Masterwork 15 Responsible Worr an, The 16 Menand Angels Type Limited Edition Canvas Limited Edition Print Limited Edition Print Limited Edition Canvas Limited Edition Canvas Limited Edition Print Masterwork Anniversary Edition Limited Edition Print Limited Edition Canvas Masterwork Limited Edition Print Anniverary EditionCanras Release Date ssue Price Est. Value Jan-03 $ 295$3,990 Jan-03 $ 135 $ 1,750 Mar-03 185 326 Jun-03 295 415 Oct-03 35$425 Oct-03 150 $ 385 Mar-04 1750 $ 4,695 275 Jun-05 595 625 Ag 05 995 1,038 Sep-05 195 745 Oct-05 425 475 r-06 1,450 $ 1,950 Aug-06 6501,500 06 375 1,250 May-05 145 Anniverary Edition Canras Limited Edition Canvas

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

Database Design And SQL For DB2

Authors: James Cooper

1st Edition

1583473572, 978-1583473573

More Books

Students also viewed these Databases questions

Question

Compare levels of resolution in conflict outcomes?

Answered: 1 week ago

Question

Strategies for Managing Conflict Conflict Outcomes?

Answered: 1 week ago