Hello gundev

I got a other question, I am working on a other homework assignment. This time it is on PivotTables. I am confused with the process, if there is a way you can explain how to accomplished the table. I will attached the files. The step I am confused is on three, if you can also check to see if I did step 2 correctly. Please

Thank you

 

Ofce 2013 – myitlab:grader – InstructionsExcel ProjectEXP ECH05 H3 - Fiesta Dinnerware 2.1Project Description:Your Aunt Laura has been collecting Fiesta dinnerware, a popular brand from the Homer LaughlinChina Company, since 1986. You help her maintain an inventory. So far, you and Aunt Laura havecreated a table of color numbers, color names, year introduced, and year retired, if applicable. In asecond table, you entered color numbers, item numbers, items, current value, and source.Previously, youhelped her research current replacement costs from Homer Laughlin’s Web site(www.hlchina.com), Replacements, Ltd. (www.replacements.com), and eBay (www.ebay.com);however, you believe the retired colors may be worth more now. Laura is especially interested inthe values of retired colors so that she can provide this information for her insurance agent. You willbuild a PivotTable and add slicers to help her with the analysis.Instructions:For the purpose o± grading the project you are required to per±orm the ±ollowing tasks:StepInstructionsPointsPossible1Openexploring_e05_grader_h3_Fiesta.xlsxand save it asexploring_e05_grader_h3_Fiesta_LastFirst.xlsx.0.0002Create a blank PivotTable from within the Items table to analyze multiple tables. Place the PivotTableon a new worksheet and name the worksheetRetired Colors.10.0003Display the names of both tables in the PivotTable Fields task pane. Display the Color names as ROWSand the sum of the Replacement Value field as VALUES. Create a relationship between the Items tableusing the Color Number field and the Colors table using the Number field.12.0004Add a Report FILTER to display aggregates for retired colors only (use the Retired field). Note thatcurrent colors do not have a retirement date, so you must filter out the blanks.12.0005Apply the Pivot Style Medium 7.5.0006Format the values with Accounting Number Format with two decimal places.7.0007In cell B3, create a custom heading namedReplacement Value. ChangeRow Labelsin cell A3 toRetired Colors.4.0008If necessary, display the Excel Options dialog box, click Customize Ribbon on the left side of the dialogbox, click to select the POWERPIVOT check box in the Customize the Ribbon section on the right side,and then click OK. Use the Calculated Fields command to create a new calculated field. Enter theformula to multiply[Sum of Replacement Value]by1.15. Add the calculated field to the Values area ofthe PivotTable.10.0009In cell C3, type the custom nameUpdated Replacement Values. Word-wrap and center the label. Setthe Column C width to12.6.000Updated: 11/11/20141Current_Instruction.docx

Unlocks remaining 

Purchase more unlocksUnlock Solution

Ofce 2013 – myitlab:grader – InstructionsExcel ProjectStepInstructionsPointsPossible10Apply the same number format for the updated values that you did for the Replacement Values column.7.00011Add slicers for the Color field. Select these colors to display: Apricot, Chartreuse, Lilac, Marigold, PearlGray, and Sapphire.12.00012Apply the Slicer Style Light 6 style.5.00013On the Retired Colors sheet, create a footer with your name on the left side, the sheet name code in thecenter, and the file name code on the right side.10.00014Ensure the worksheets are in the following order: Color List, Retired Colors, Collection. Save and closethe workbook, and submit the file as directed.0.000Total Points100.000Updated: 11/11/20142Current_Instruction.docx

NumberColorIntroducedReTred100White1986101Black1986102Cinnabar20002010103Rose19862005104Apricot19861998105Cobalt Blue1986106Yellow19872002107Turquoise1988108Periwinkle Blue19892006109Sea Mist Green19912005113Lilac19931995114Persimmon19952008116Sapphire19961997117Chartreuse19971999118Pearl Gray19992001119Juniper20002001320Sunfower2001323Plum2002324Shamrock2002325Tangerine2003326Scarlet2004327Peacock2005328Heather20062008329Evergreen20072010330Ivory2008331Chocolate20082012332Lemongrass2009333Marigold20082012334Paprika2010335Flamingo2012

• 1494562698-Gonzalez_exploring_e05_grader_h3_ 205pmFiesta.xlsx
• 1494562699-EXP_ECH05_H3_-_Fiesta_Dinnerware_21_Instructions.docx

ComputerScienceExpert

(11)

Status NEW Posted 12 May 2017 03:05 AM My Price 11.00

-----------

Attachments

file 1494562701-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer