Write an Excel formula in cell VACATION!B21 to determine what percent of families will be vacationing in South America. FYI: Cell vacation!B21 is already formatted using the percent icon O=COUNTIF("South America". F4:F9)/COUNT(B4:39) O=COUNTIF(F4:F9."South America")COUNT(B4:39) =100 COUNTIF(B4:B9,"South America")/COUNT(F4:F9) =100 COUNTIF(F4:F9."South America")/COUNT(B4:B9) TRAVEL PACKAGE FORMATION de O Part TE TITA 100AL THE G Erre C. TO INT TOUTES XLNO C D re SON 12 TEM 14.000 O O Le Some 3 TAS TERTPAMILY Travel Court Travel Centet Awane Tweel 12 Fanny Direto Tre Altre AM Tulo 27000000000000000 14 Al 12.000 HOOTED 15 We BE78000000000 11000 TE 10 W E 1000000 1 7.00020000 151 10 We 3170.00 GOU 19 20 people at Commercete Asia 21 pretcher? 22 the miles te Asire there to ridere TRA 23 In the preparater 49 TELE 24 Whether with the terme 2004 25. What the merge Lowest Travel A? Wegfare for familiegte Anithathew 20 Best OnWate 5700000 TRUE Wibe total destination for face 0721 VACATION B D Country Japan Norway Chile 2 Currency yen kroner peso 3 Currency/S 109.67 6.93 594 46 COUNTRY E Peru nuevo 3.35 G Thailand China bhat yuan 39.7 329 1 Cost of fuelgallon 2 Miles/gallon B $100 120 1 Cost of trip Tip 2 50 5% 3 $10.000 7% 4 $16000 10% 5 $25 000 12 6 $30,000 15% UNITS TIDS