AutoSave Off) Week 1 Homework MBA 665 (1) Search Bukky Aiyamenkhue BA File Home Insert Draw Page Layout Formulas Data Review View Automate Help Comments Share Define Name By Trace Precedents f Show Formulas AutoSum Recently Financial Logical Text Date & Lookup & Math & More Name Use in Formula Calculate Now Insert Trace Dependents Error Checking Watch Calculation Function Used Time Reference . Trig Functions Manager Create from Selection Remove Arrows Evaluate Formula Window Options Calculate Sheet Function Library Defined Names Formula Auditing Calculation G21 B 1 The distance between any two cities can be approximated by the formula: " 2 =69*SQRT((lat city1-lat city2)^2 + (long city1-long city2)^2) 3 The table below contains the data needed to fill in the chart in yellow. Use VLOOKUPS to solve.. 4 max 10 points 5 Lat Long 6 New York 40.7 73.9 HINT: The table contains the latitude and longitude for each city. 7 Boston 423 710 The cities in cells A30:A50 represent what should be city1 in your formulas. 8 Philadelphia 40.0 75.1 The cities in cells B29:V29 represent what should be city2 in your formulas. 9 Charlotte 35 2 80.8 It makes the formula easier to write if we use Named Ranges for the table, city1, and city2. 10 Atlanta 33 8 84 4 *This is a very complicated formula, do not give up. To help you determine if you are on the right track 11 New Orleans 30.0 89 9 the answer for New York to Boston in 229 (rounded). 12 Miami 25.8 80 2 13 Dallas 32.8 96 8 14 Houston 29 8 95.4 15 Chicago 41 8 87.7 16 Detroit 42 4 83.1 17 Cleveland 41.5 81 7 18 Indy 39.8 86 1 19 Denver 39.8 104 9 20 Minneapolis 45.0 93 3 21 Phoenix 112.1 22 Salt Lake City 40 8 1119 23 LA 34.1 1184 24 SF 37 8 122.6 25 SD 32.8 117.1 26 Seattle 122.4 27 28 New Orleans Miami Dallas Houston Chicago Detroit Cleveland Indy 29 New York Boston Philadelphia Charlotte Atlanta Q1 Q2 03 04 05 06 Ready x Accessibility: Investigate 8:34 PM Type here to search 84 Tem. 3/26/2023AutoSave (@ Off) H Week 1 Homework MBA 665 (1) Search Bukky Aiyamenkhue BA - X File Home Insert Draw Page Layout Formulas Data Review View Automate Help Comments Share fx Define Name By Trace Precedents fx Show Formulas AutoSum Recently Financial Logical Text Date & Lookup & Math & . More Name "Use in Formula Calculate Now Trace Dependents Error Checking Insert Watch unction Used v Time * Reference . Trig Functions Manager Create from Selection FX Remove Arrows Evaluate Formula Calculation Calculate Sheet Window Options Function Library Defined Names Formula Auditing Calculation 139 2 Salt Lake City 40.8 111.9 LA 34.1 118.4 4 SF 37.8 122.6 ISD 32.8 117.1 Seattle 41.6 122.4 New York Boston Philadelphia Charlotte Atlanta New Orleans Miami Dallas Houston Chicago Detroit Cleveland Indy 0 New York Boston 229 200 Philadelphia 324 283 Charlotte 514 393 4 Atlanta 267 248 New Orleans 461 380 6 Miami 729 669 Dallas L243 1,145 Houston 228 97 9 Chicago 984 531 0 Detroit 320 317 1 Cleveland 115 97 2 Indy 325 304 Denver 1 297 1,297 Minneapolis 877 800 Phoenix 1,521 1.297 16 Salt Lake City 504 14 LA 644 449 SF 386 290 SD 513 380 Seattle 709 366 Q1 Q2 Q3 04 05 06 + Ready 1x Accessibility. Investigate 100% Type here to search T 9: 55 F ~ (() 8:35 PM 3/26/2023 FA CO F5 F6 F7 O+ F8 F9 F10 F11 F12 Del 28 Co Prt Sc Insert