"STEP BY STEP INSTRUCTIONS PLEASE, DO NOT ATTEMPT TO ANSWER IF YOUR UNSURE"

(A1:E327)

(A1:E357)

EX16_XL_CHO5_GRADER ML2_HW- Fiesta Collection 1.1 Project Descriptiorn Instructions: For the purpose of grading the project you are required to perform the following tasks: Points Possible Step Open exploring e05_grader h3 Fiesta.xisx and save it as exploring_e05_grader_h3_Fiesta_LastFirst.xlsx. 0.000 Create a relationship between the Items table using the Color Number field and the Colors table using the Color Number field. Create a blank PivotTable from within the Items table on the Collection worksheet to analyze multiple tables. Add the data to the data model. Place the PivotTable on a new worksheet and name the worksheet Retired Colors. Name the PivotTable Retired. 2 10.000 Display the names of both tables in the PivotTable Fields task pane. Display the Color field as rows and the sum of the Replacement Vaue field as values. 3 12.000 Add a filter to display aggregates for retired colors only using the Retired field. Note that current colors do not have a retirement date, so you must filter out the blanks. 4 12.000 Apply the Pivot Style Medium 7. Note, depending on the version of Office used, the style name may be Light Green, Pivot Style Medium 7 5 5.000 In the Retired Colors sheet, format the values with Accounting Number Format with two decimal places. 6 4.000 In cell B3, create a custom heading named Replacement Value. Change Row Labels in cell 4.000