exploring_e05_grader_h3_Fiesta_LastFirst.xlsx (answer) Homework | Page 2

1 Open ​exploring _ e05 _ grader _ h3 _ Fiesta . xlsx and save it 0.000 as​exploring _ e05 _ grader _ h3 _ Fiesta _ LastFirst . xlsx​ .

2 Create a blank PivotTable from within the Items table to

10.000 analyze multiple tables . Place the PivotTable on a new worksheet and name the worksheet ​Retired Colors​ .

3 Display the names of both tables in the PivotTable

12.000

Fields task pane . Display the Color names as ROWS and the sum of the Replacement Value field as VALUES . Create a relationship between the Items table using the Color Number field and the Colors table using the Number field .

4 Add a Report FILTER to display aggregates for retired

12.000 colors only ( use the Retired field ). Note that current colors do not have a retirement date , so you must filter out the blanks .

5 Apply the Pivot Style Medium 7 . 5.000