Answer asap please!

1.00 Point: XL Step 10.2.5: Use Flash Fill File Review SIMS Share B Home Insert Page Layout Formulas Data 2 Show Queries Connections s From Table Properties New Refresh Query Do Recent Sources All- Edit Links Get & Transform Connections 2. A Al Sort e10h2Commodities_Solution - Excel View Tell me what you want to do.. & Clear 2 To Reapply 8-19 What If Forecast Filter Text to Advanced Columns - Analysis - Sheet Sort & Filter Data Tools Forecast Get External Data Group Ungroup - Subtotal Outline 02 6907 G H P Q R F State CT Enter the column heading Zip Code in cell 01 and enter 06907 in cell 02 Apply Zip Code Number Format to cell 02. Use Flash Fill to copy the zip codes down completing the column Copy the range 01:06 to G1G6 Copy the range A1:G6 and paste only the values back into the same range (A1:G6) [the contents in the range 11:06 will automatically be deleted] 1 L M N Broker_ID First Nam. Last Name Address City State Zip Code 1656 JULIUS STJAMES 426 Sydne Stamford CT 06907 69071 4980 CHRISTY WILKS 317 Mink Delray Be FL 33483 1697 JACK CAMBY 745 Jasper Santa Ros: FL 32459 8348 MARK FERNENDI 569 Post Dale IN 47523 4382 JASMINE JONES 82 Tradew Aguadilla PR 00605 FL FL IN PR D E 1 Address City 2 426 Sydney Park Circle Stamford 3 317 Mink Court Delray Beach 4 745 Jasper Lane Santa Rosa Beach 5 569 Postmark Drive Dale 6 82 Tradewind Drive Aguadilla 7 8 9 10 11 12 13 14 15 16 17 18 4 of 4 Attempts Remaining: 15 View All C Reset 1.00 Point: XL Step 9.2.2: Insert 3-D Formulas File Home Insert Page Layout SIMS Share X Arial 10 -R e09h2Indianapolis - Excel Formulas Data Review View Tell me what you want to do 9 ER General I Conditional Formatting Format as Table - $ - % 09 Cell Styles - Alignment Number Styles Insert - Be E- Ex Delete Paste BIU - A 00 EB Format - Cells Sort & Find & Filter Select- Editing Clipboard Font G H j K L M N In cell F3, insert a 3-D formula to sum the Athletic Apparel Dept. Totals for all four quarters. Use the fill handle to copy the formula through cell F10. Apply Accounting Number Format to the range F3.F10 Set column F's width to auto. E3 for 'Otr4'1E3 A B D E F 1 Circle City Sporting Goods 2 Department Qt1 Q12 Otr3 Otra Dept. Total 3 Athletic Apparel S 360,294 32 $ 160,086 50 S 430,611.06 $ 355,957 21 4 Exercise Equipment S 326,434.64 $ 389.875.27 S 322.452.84 S 187,324.52 5 Footwear $ 129,396.59 $ 92.782.16 $ 66,251.06 $ 47,504.47 6 Camping Gear S 249,874.87 5 385 465.94 $ 239,756.71 $ 437,661.78 7 Football $ 304,098.47 $ 243,744.04 $ 322,711.33 $ 414,889.96 8 Baseball S 247.420.88 $ 246.002.89 $ 327,373.70 S 305,406,90 9 Soccer $ 329,656.33 $ 399,529.09 $ 422,878.19 $ 353,077.29 10 Basketball $ 422,889 30 $ 247,831.85 S 327,372.72 S 327,991,70 11 Quarterly Total 12 13 14 15 16 17 18 19 20 Qtri Otr2 Qtr3 0tr4 Yearly Totals 3 3 of 4 Attempts Remaining: 13 E View All C Reset Save Submit