I need help with these 6 excel problems

3. 6. 7. 8. 4.IIIIIIIIIII.2.IIIIII Manipulate worksheet data Open the SummarizeValues workbook in Excel, and then perform the following tasks: 1. Combine the IF and RAND functions into formulas in cells H3:H27 that display TRUE if the value is less than 0.3 and FALSE otherwise. 2. Use AutoCalculate to find the SUM, AVERAGE, and COUNT of cells G12:G16. 3. Remove the COUNT summary from the status bar and add the MINIMUM summary. 4. Create a SUBTOTAL formula that finds the average of the values in cells G3:G27. 5. Create an AGGREGATE formula that finds the maximum of values in cells G3:G27. 6. Create an advanced filter that finds the unique values in cells F3:F27. If any of cannot s Rememb Page 1 of 1 Page 367 AutoSave Off He SummarizeValues - Read-Only - Excel Search Easton E File Home Insert Page Layout Formulas Data Review View Share Comments fx Calculate Now Help Define Name Use in Formula Name Manager Create from Selection Defined Names ? AL e AutoSum Recently Financial Logical Text Date & Lookup & Math & More Used Time Reference Trig Functions Function Library e, Trace Precedents Pix Show Formulas a Trace Dependents Error Checking FRemove Arrows - Evaluate Formula Insert Function Loa Watch Window Calculation Options Calculate Sheet Formula Auditing Calculation H13 B C D E E F G H H J K L M N P Q R S s T U V w 1 Summary Investigate 2 3 4 5 6. 7 8 9 10 11 12 13 14 ExceptionID EX101 EX102 LAVA EX103 EX104 EX105 EX106 EX107 EX108 EX109 EX110 LALU EX111 EN EX112 NAR EX113 EX114 Pusar EX115 EX116 Us EX117 Evo EX118 EX119 va EX120 Puma EX121 EX122 EX123 EX124 EX125 PackageID PD119 PD120 0120 PD121 PD122 PD123 - PD124 PD125 . PD126 PD127 - PD128 co PD129 PD130 PD131 PD132 POGOS PD133 42 PD134 OR PD135 PD136 *** PD137 4 PD138 4 PD139 PD140 PD141 PD142 PD143 Date Center Route 3/20/2019 Northeast RT310 3/20/2019 Midwest RT892 3/20/2019 Northwest RT424 1727 3/20/2019 Northeast W othed RT995 3/20/2019 Midwest RT827 Wwca 3/20/2019 Central RT341 3/20/2019 Central Wanda RT864 3/20/2019 Central RT277 3/31/2019 South RT983 W ! 3/31/2019 Southwest RT827 W12 4 3/31/2019 South RT942 1974 3/31/2019 South RT940 som 10 3/31/2019 Southwest RT751 4/1/2019 Midwest RT436 pears 4/1/2019 Midwest RT758 4/1/2019 Midwest M179040 Min RT529 14 - 4/1/2019 Northeast RT243 wa 4/1/2019 Northeast RT189 Watch 4/1/2019 Northwest R1714 peace 4/2/2019 Central RT151 nam . tras 4/2/2019 Midwest RT543 TOO 4/2/2019 Southwest RT208 4/2/2019 South RT145 4/2/2019 Central RT250 4/2/2019 Midwest RT852 Cost 12.08 14.88 13.61 10.64 15.26 29 18.86 15.71 18.50 19.87 18.01 19.85 15.61 12.84 13.94 42 17.55 1076 19.78 19.07 17.36 11.38 15.02 90 13.90 490 11.86 14.99 14.14 19.35 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 15 16 17 18 19 20 21 22 23 24 25 26 27 28 By Route Ready + 80% 9:50 PM Type here to search N a W 10/27/2020