Insert a PivotTable and a PivotChart 15. Create a PivotTable on the...

Image transcription text

EA4_A1_Inventory_Chegg.xIsx > Vincent Giron VG AutoSave (C Of) H Search Comment File Home Formulas Data Review View Share Insert Page Layout Help Insert O Calibr - 11 AA ab Wrap Text General Delete * Conditional Format as Cell Sort & Find & Analyze Sensitivity Paste BIU CA EEE EE Merge & Center * 6 % 9 70 30 Formatting * Table St Styles * Format * " Filter * Select v Data Style Cells Editing Analysis Sensitivity Clipboard Fon Alignment Number M: M D G Educational Endeavors - Inventory Listing Total Categories = =COUNTA(A5:A62) Average Inventory Maximum Minimum Inventory Country of Product Ending Inventory Ending Inventory Ending Inventory Ending Inventory Ending Inventory Balance Balance - Year 1 Balance - Year 2 Balance - Year 3 Balance - Year 4 Year 5 Number of Years Balance Inventory Balance Balance 4 Product Category Manufacture Department Online Rating 11480 14350 9450 6860 'Construction Paper'!817 =COUNT(E5:15) *=AVERAGE(E5:15 MAX (E5:15) =MIN(E5:15) Construction Paper Canada Arts & Crafts 3 of 5 *=AVERAGE(E6:16) =MAX(E6:16) =MIN(E6:16) 6 Crayons United States Arts & Crafts 2 of 5 24108 0 26978 25256 24682 =COUNT(E6:16) 11480 17220 =COUNT(E7:17) X=AVERAGE(E7:17) MAX(E7:17) =MIN(E7:17) 7 Markers United States Arts & Crafts 3 of 5 12710 *=AVERAGE(EB:18) MAX(ES:18) =MIN(EB:18) 8 Glue United States Arts & Crafts 5 of 5 9184 17794 9758 8036 =COUNT(ES:18) =MIN(E9:19) 9 Adhesives Canad Arts & Crafts 2 of 5 4018 516 3444 1148 1722 =COUNT(E9:19) X=AVERAGE(89:19) =MAX(E9:19) 6314 5740 5740 5740 6027 =COUNT(E10:110) *=AVERAGE(E10:110) =MAX(E10:110) -MIN(E10:110 10 Clay, Dough, and Tools Ireland Arts & Crafts 5 of 5 5453 =COUNT(E11:111) *=AVERAGE(E11:111 -MAX(E11:111) MIN(E11:111) 17 Craft Kits & Projects Canada Arts & Crafts 5 of 5 6765 Arts & Crafts 2009 2296 =COUNT(E12:112) =AVERAGE(E12:11 =MAX(E12:112) =MIN(E12:112) 12 Craft Materials United States 30422 37884 =COUNT(E13:113) =AVERAGE(E13:113) =MAX(E13:113) =MIN(E13:113) 13 Drawing Ireland Arts & Crafts 2 of 5 35588 32718 28126 40754 34440 =COUNT(E14:114) =AVERAGE(E14:114) =MAX(E14:114) =MIN(E14:114) 14 Paint Ireland Arts & Crafts 3 of 5 40754 42476 43050 30135 =AVERAGE(E15:115) =MAX(E15:115 =MIN(E15:115) 15 Paint Brushes & Accessories Australia Arts & Crafts 3 of 5 28/00 28700 31570 30422 =COUNT(E15:115) 19516 =COUNT(E16:116) *=AVERAGE(E16:116 =MAX(E16:116) =MIN(E16:116) 16 Paper New Zealand Arts & Crafts 1 of 5 20664 2152 22386 20951 New Zealand Arts & Crafts 3 of 5 15498 14350 14924 15211 =COUNT(E17:117) *=AVERAGE(E17:117) =MAX(E17:117) =MIN(E17:117) 17 Racks & Storage 7462 14924 =COUNT(E18:118) *=AVERAGE(E18:118) =MAX(E18:118) =MIN(E18:118) 15 Stamp Pads & Stampers Canada Arts & Crafts 5 of 5 26978 Active 2009 2181 5166 5453 =COUNT(E19:119) X=AVERAGE(E19:119) =MAX(E19:19) =MIN(E19:119) 19 Soft Active Play Canada 3 of 5 6429 4879 6314 6084 5625 =COUNT(E20:120) X=AVERAGE(E20:120 =MAX(E20:120) =MIN(E20:120) 20 Active Kits United States Active 1779 =COUNT(E21:121) X=AVERAGE(E21:121 =MAX(E21:121 -MIN(E21:121) 21 Balls United State Active 3 of 5 o 1722 MAX(E22:122 =MIN(E22:122) 22 Gross Motor Skills United States 3 of 5 35588 3042 17220 2870 =COUNT(E22:122) *=AVERAGE(E22:122) =COUNT(E23:123) =AVERAGE(E23:123 =MAX(E23:123) =MIN(E23:123) 23 Indoor Play Equipment Canada Active 2 of 5 26404 2755 28126 1492 15211 12628 10906 =COUNT(E24:124) *=AVERAGE(E24:124 =MAX(E24:124) =MIN(E24:124) 24 Play Structures United States Active 2 of 5 13202 2 of 5 22960 2410 24969 25256 27552 =COUNT(E25:125) *=AVERAGE(E25:125 =MAX(E25:125) MIN(E25:125) 25 Sand & Water New Zealand Active =MIN(E26:126) Australia Active 2 of 5 o 10332 =COUNT(E26:126) X =AVERA GE(E26:126) =MAX(E26:126 26 Teacher's Resources =COUNT(E27:127) *=AVERAGE(E27:127) MAX[E27:127) =MIN(E27:127) 27 Trikes & Riding Active 2 of 5 18655 17220 22099 20664 15498 =COUNT(E28:128) *=AVERAGE(E28:128 =MAX(E28:128 MIN(E28:128) 26 Alphabet Knowledge Ireland nguage 3 of 5 24108 23247 22099 22386 25256 =COUNT(E29:129) !=AVERAGE(E29:129) =MAX(E29:129) =MIN(E29:129 29 Games & Puzzles 35875 33292 30709 Australia anguage 3 of 5 35014 29426 20090 -COUNT(E30:130) X=AVERAGE(E30:130) =MAX(E30:130) -MIN(E30:130 30 Grammar Ireland Language 3 of 5 o 1722 -COUNT(E31:131) =AVERAGE(E31:131 =MAX(E31:131 =MIN(E31:131) 1 Interactive Books & Software United States Language 3 of 5 2296 2583 35875 =COUNT(E32:132) =AVERAGE(E32:132) MAX(E32:132) (ZEI:ZE3)NIW= 32 Journals & Paper United States Language 5 of 5 37310 34440 35588 36162 =AVERAGE(E33:133 =MAX(E33:133) =MIN(E33:133) 33 Language Easel Ireland Language 3 of 5 54530 58548 50512 =COUNT(E33:133) 79499 65780 =COUNT(E34:134) =AVERAGE(E34:134) =MAX(E34:134) -MIN(E34:134 34 Reading Comprehension Ireland Language 3 of 5 78064 80360 75768 =COUNT E35:135 =AVERAGE(E35:135 =MAX(E35:135) =MIN(E35:135 35 Rhyming Ireland anguage 5 of 5 49364 47068 24772 =MIN(E36:136 24969 27839 =COUNT(E36:136) *=AVERAGE(E36:136 =MAX (E36:136) 36 Sentence Building Australia 22960 4108 o 16072 12054 =COUNT(E37:137) X=AVERAGE(E37:137) =MAX(E37:137 -MIN(E37:137) 37 Sight Words New Zealand Language 2 of 5 17220 29848 30422 29274 28126 =COUNT(E38:138) =AVERAGE(E38:138) =MAX(E38:138) =MIN(E38:138) Addition & Subtraction New Zealand Mathematics 1 of 5 32144 8151 5510 =COUNT(E39:139) X=AVERAGE(E39:139) =MAX(E39:139) =MIN(E39:139) 39 Counting & Numeracy Canada Mathematics 3 of 5 4879 6601 8553 918 3157 =COUNT(E40:140) X=AVERAGE(E40:140) =MAX(E40:140) =MIN(E40:140) 40 Curriculum Resources New Zealand Mathematics 1 of 3 1837 2583 34440 =COUNT(E41:141) =AVERAGE(E41:141) =MAX(E41:141) -MIN(E41:141) 1 Exploring Manipulatives Australia Mathematics 5 of 5 =AVERAGE(E42:142 =MAX(E42:142) =MIN(E42:142) 42 Geometry Ireland Mathematics 5 of 5 45920 4821 46494 7462 0 =COUNT(E42:142) 301 S 55104 13202 =COUNT(E43:143) *=AVERAGE(E43:143 =MAX(E43:143) =MIN(E43:143) 43 Measurement & Classifying New Zealand Mathematics 3 of 5 40754 42476 45346 -COUNT(E44:144) !=AVERAGE(E44:144) =MAX(E44:144) =MIN(E44:144) 44 Operations United States Mathematics 43624 7462 1722 15498 =COUNT(E45:145) *=AVERAGE(E45:145) =MAX(E45:145) =MIN(E45:145) 45 Algebraic Thinking Australia Mathematics 1 of 5 32144 55104 =COUNT(E46:146) *=AVERAGE(E46:146) =MAX(E46:146) =MIN(E46:146) Carts & Storage Australia Block Play 2 of 5 o D 47 Jumbo Block Block Play 2 of 5 5510 5051 4994 3444 4190 =COUNT(E47:147) X=AVERAGE(E47:147) =MAX(E47:147) -MIN(E47:147) New Zealand =MAX(E48:148) MIN(E48:148) 48 Novelty Blocks New Zealand Block Play 2 of 5 3501 30422 33292 31857 2353 =COUNT(E48:148) ! =AVERAGE(E48:148) =COUNT(E49:149) *=AVERAGE(E49:149) =MAX(E49:149) =MIN(E49:149) 49 People & Animals Ireland Block Play S of 5 9184 10332 6601 6027 6888 Block Play 2 of 5 10906 1320 14924 16072 20377 =COUNT(E50:150) *=AVERAGE(E50:150) =MAX(E50:150) =MIN(E50:150 50 Rugs & Mats United States -COUNT(E51:151) X=AVERAGE(E51:151) =MAX (E51:151) MIN(E51:151) 51 Tabletop Blocks Ireland Block Play 3 of 5 20664 2009 17794 14924 13202 =COUNT(E52:152) *=AVERAGE(E52:152) =MAX(E52:152) -MIN(E52:152) 52 Unit Blocks Ireland Block Play 2 of 5 10332 10619 11193 5510 4707 2296 =COUNT(E53:153) X=AVERAGE(E53:153) =MAX(E53:153) =MIN(E53:153) 53 Vehicles New Zealand Block Play 5 of 5 4305 5166 9414 =COUNT(E54:154) X=AVERAGE(E54:154) MAX(E54:154) -MIN(E54:154) 54 Chalk & Dry Erase Australia School Supplies 5 of 5 O 3731 16072 2238 20090 20664 17794 =COUNT(E55:155) *=AVERAGE(E55:155) =MAX(E55:155) MIN(E55:155 55 Crayons Canada School Supplies 3 of 5 21812 =MAX(E56:156) =MIN(E56:156) Canada School Supplies 2 of 5 3731 3559 3674 4420 4190 =COUNT(E56:156) X=AVERAGE(E56:156) 56 Folders & Binders =MAX (E57:157) -MIN(E57:157) 57 Notebooks & Pape Canada School Supplies 3 of 5 40180 4362 42476 36162 28126 =COUNT(E57:157) =AVERAGE(E57:157) -COUNT(E58:158) <=AVERAGE(E58:158) =MAX(E58:158) =MIN(E58:158) 58 Of Office Supplies reland School Supplies 3 of 5 32144 59 P United States School Supplies 3 of 5 52234 50512 49364 44485 41902 =COUNT(E59:159) [=AVERAGE(E59:159) =MAX(E59:159) =MIN(E59:159) Australia School Supplies 2 of 5 28413 23534 24682 31283 29848 =COUNT(E60:160) !=AVERAGE(E60:160) =MAX(E60:160) =MIN(E60:160) Pens & Pencils =MAX(E61:161) =MIN(E61:161) 61 Scissors School Supplies 2 of 5 6888 16072 5211 13776 15785 =COUNT(E61:161) *=AVERAGE(E61:161) 62 Storage 3292 =COUNT(E62:162) *=AVERAGE(E62:162) =MAX(E62:162) =MIN(E62:162) New Zealand School Supplies 5 of 5 36162 22673 =SUM(15:162) 63 1 Totals: =SUM(ES:E62) =SUM(F5:F62) =SUM(G5:G62) =SUM(H5:H62) 64 nventory PivotTable Inventory Listing Construction Paper +

... Show more

Image transcription text

AutoSave . Off) - EA4_A1_Inventory_Chegg.xIsx - Search Vincent Giron VG File Home Insert Page Layout Formulas Data Review View Help Share Comment 11 ~ A" A Insert * Calibri = = =2 de Wrap Text jeneral Ex AY Delete O Paste BIULA SEE E Merge & Center * % " 08 28 Conditional Format as Cell Sort & Find & nalyze Sensitivity Formatting " Table Styles Format * " Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity M X v fx D G H M Educational Endeavors - Inventory Listing Total Categories = Country of Product Ending Inventory Ending Inventory Ending Inventory Ending Inventory Ending Inventory Number Average Maximum Minimum Product Category Manufacture Department Online Rating Balance - Year 1 Balance - Year 2 Balance - Year 3 Balance - Year 4 Balance - Year 5 of Years Inventory Balance Inventory Balance Inventory Balance 5 C Construction Paper Canada Arts & Crafts 3 of 5 11,480 $ 14,350 9,450 6,860 $ 8,075 5 X $ 10,043 14,350 6,860 6 C Crayons United States Arts & Crafts 2 of 24,108 $ 26,978 6 $ 24,68 5 $ 26,978 $ 7 Markers United States Arts & Crafts 3 of 5 12,710 11,480 $ .7,220 8,282 $ 17,220 $ 8 Glue United States Arts & Crafts 5 of 5 9.184 17,794 I S 9,758 $ 8,03 8,954 $ 4 $ Adhesives Canada Arts & Crafts 2 of 5 4,018 $ 5,166 3,444 $ 1,148 $ 1,722 3,100 $ 6 $ 1,148 10 clay, Dough, and Tools reland Arts & Crafts 5 of 5 6,314 $ 5,740 $ 5,740 S 5,740 $ 6,027 5,912 $ 5 , 740 11 Craft Kits & Projects Canada Arts & Crafts 5 of 5 6,765 $ 7,462 $ S $ 5,453 * S 7,462 2 S 12 Craft Materials United States Arts & Crafts 2 of 5 2,009 $ 1,148 $ 2,296 1,091 $ 13 Drawing reland Arts & Crafts 2 of 5 35,588 32,718 $ 30,422 $ 7,88 32,948 $ $7,884 28,12 14 Paint Ireland Arts & Crafts 3 of 5 10,754 S 42,476 $ D S 4 $ 34,440 D S 34,440 15 Paint Brushes & Accessories Australia Arts & Crafts 3 of 5 28,700 $ 28,700 $ 30,422 $ 30,135 ! S 29,905 31,570 5 28,700 16 Paper New Zealand Arts & Crafts 1 of 5 20,664 21,525 $ 6 S 20,951 9,51 * S 21,008 22,386 $ 19,516 17 Racks & Storage New Zealand Arts & Crafts 3 of 5 16,072 5 15,498 $ 14,350 $ 4 S 5,211 15,211 16,072 $ 14 350 18 Stamp Pads & Stampers Canada Arts & Crafts 5 of 5 26,978 $ 7,462 S 4,924 * $ 26,978 $ 19 Soft Active Play Canada Active 5 of 5 2,009 $ 2,181 1 S 5,453 $ 4,30 3 S 5,453 $ 2,009 20 Active Kits United States Active 3 of 5 5,429 $ 4,879 $ 4 $ 6,084 $ 5,62 5.866 $ 4,879 21 Balls United States Active 3 of 5 1,722 1,779 XS 3 S 22 Gross Motor Skills United States Active 3 of 5 35,588 5 2 $ 17,220 0 $ * s 17,220 $ 3 $ 23 Indoor Play Equipment Canada Active 2 of 5 26,404 $ 27,552 $ 28,126 26,404 $ 26,404 g S 26,978 $ 26,40 24 Play Structures United States Active 2 of 5 2 S 14,924 $ 15,211 8 S 10,906 5 X8 13,374 1 S 10,90 25 Sand & Water New Zealand Active 2 of 5 22.960 S 24.969 25.256 5 27.552 S 27.55 2 S 22.960 26 Teacher's Resources Australia Active 2 of 5 10,332 5X $ i S 27 Trikes & Riding Australia Active 2 of 5 18,655 $ 22,099 20,664 $ 15,498 18,827 22,09 15,49 8 Alphabet Knowledge reland Language 3 of 5 24,108 $ 23,247 $ 22,099 $ 22,386 25,256 5 X 23,419 $ 25,25 is 22,099 29 Games & Puzzles Australia Language 3 of 5 35,875 1 S 33,292 $ 28,126 $ 30,709 5 ! 32,603 $ 35,875 28,126 30 Grammar reland anguage 3 of 5 S 3,444 $ 20,090 * s 4,707 20,090 31 Interactive Books & Software United States Language 3 of 5 2,583 S 1,722 2,583 $ 32 Journals & Paper United States Language 5 of 5 37,310 $ 34,440 3 S 36,162 $ 35,875 85,875 $ 37,310 $ 34,440 33 Language Easels Ireland Language 3 of 5 54,530 58 ,548 3 S 50,512 $ 44,715 $ 59,983 34 Reading Comprehension Ireland Language 3 of 5 78,064 $ 80,360 $ 75,768 $ 79,499 $ 65,780 5 VS 75,894 65,780 35 Rhyming Ireland Language 5 of 5 49,364 14,772 5 S 28,241 1 S 36 Sentence Building ustralia Language 2 of 5 22,960 $ 24,108 24,969 27,839 9,975 $ 27,839 $ 37 Sight Words New Zealand Language 2 of 5 17,220 O S S 16,072 12,054 * s 9,069 $ 17,220 $ 38 Addition & Subtraction New Zealand Mathematics 1 of 5 32,144 29,848 2 S 0,422 29,274 28,126 32,144 28,126 39 Counting & Numeracy Canada Mathematics 3 of 5 4 879 $ 6,601 3 151 8.553 S 5,510 6,739 8,553 $ 4.879 40 Curriculum Resource New Zealand Mathematics 1 of 5 1.837 2,583 $ 918 $ 3,15 5 X 1,699 3,157 $ 41 EX Exploring Manipulatives Australia Mathematics 5 of 5 S 4,440 34,440 S 42 Geometry Ireland Mathematics 5 of 5 45,920 5 48,216 $ 7,462 5 29,618 $ 48,216 $ 43 Measurement & Classifying New Zealand Mathematics 3 of 5 55,104 13,202 $ 5 % 13,661 $ 55,104 $ 44 Operations United States Mathematics 3 of 5 43,624 42,476 $ 15,346 $ 24,682 39,376 $ 45,34 24,682 45 Algebraic Thinking Australia Mathematics 1 of 5 32,144 $ 7,462 1,722 $ 15,498 11,365 $ 32,144 46 Carts & Storag Australia Block Play 2 of 5 S 55,104 1 S 5,104 47 Jumbo Blocks New Zealand Block Play 2 of 5 5,510 $ 5,051 4,994 4 S 3,444 4,190 5 X $ 4,638 5 5,510 3,444 48 Novelty Blocks New Zealand Block Play 2 of 5 35,014 $ 0,42 3,292 $ 1,857 3,534 5 ! 30,824 $ 35,014 $ 23,534 49 People & Animals Ireland Block Play 5 of 5 9,184 $ 10,332 1 $ 6,027 $ 6,888 5 $ 10,332 6,027 50 Rugs & Mats United States Block Play 2 of 5 10,906 13,202 $ 14,924 $ 16,072 $ 20,377 5 % 15,096 $ 20,377 10,906 51 Tabletop Blocks reland Block Play 3 of 5 20,664 20,090 $ 17,794 $ S * $ 11,710 $ 52 Unit Blocks reland Block Play 2 of 5 10,332 2 S 1,193 4,924 3,202 5 X 12.054 $ 14,924 0,332 53 Vehicles New Zealand Block Play 5 of 5 4,305 5,510 $ 4,707 $ 2,296 4,397 $ 5,510 $ 2,296 54 Chalk & Dry Erase Australia School Supplies 5 of 5 S 3,731 9,414 $ 16,072 XS 5,843 $ 16,072 $ 55 Crayons Canada School Supplies 3 of 5 21,012 22,386 20,090 $ 20,664 $ 17,794 5 X 20,549 $ 22,386 17,79 56 Folders & Binders Canada School Supplies 2 of 5 3,731 5 3,559 3,674 $ 4,420 $ 4,190 5 X $ 3,915 4,420 $ 3,559 57 Notebooks & Paper canada School Supplies 3 of 5 40,180 $ 42,476 6.162 $ 8,12 5 8 8,114 $ 43,624 $ 28,12 58 Office Supplies reland School Supplies 3 of 5 32,144 4 $ $ S 7,462 5 X 7,921 $ 32,144 $ 59 Paint United States School Supplies 3 of 5 52,234 $ 50,512 19,364 4 $ 4,485 41,902 5 ! 47,699 $ 52,234 $ 41,902 60 Pens & Pencils Australia School Supplies 2 of 5 28,413 23,534 $ 24,682 31,283 $ 29,848 5 ! 27,552 5 31,283 23,534 61 Scissors reland School Supplies 2 of 5 6 838 16,072 $ 15,211 $ 6 S 15,785 * s 16,072 $ 6,888 Storag New Zealand School Supplies 5 of 5 S S 36,162 33,292 18,425 $ 36,162 63 Totals: 11,47,590 $ 10,43,212 $ 10,46,094 $ 9,37,200 $ 9,30,032 64 Inventory PivotTable Inventory Listing Construction Paper +

... Show more

Image transcription text

Insert a PivotTable and a PivotChart 15. Create a PivotTable on the Inventory Listing tab based on the inventory balances displayed for all five years. 16. Rename the new worksheet tab containing the PivotTable. 17. Display the Year 5 Inventory Balances within the Pivot Table with: . Country of Manufacture in the Rows area . Product Category in the Columns area . A filter that excludes the Active product department 18. Add a slicer that limits the data to product categories that earned at least a 3 of 5 online rating. 19. Create a 3-D Clustered Column PivotChart and display the Online Rating category in the legend. 20. Position the PivotChart and slicer in a logical manner. 21. Save and close the file.

... Show more