1. (TOTAL 24 points)

Refer to worksheet Question 3. You have to use MATCH and INDEX functions to determine the distance between Cities 1 and 2 given in cell C12 and F12.

1. Use MATCH function in cell C13 to determine the row number of City 1 (6 points)
2. Use MATCH function in cell F13 to determine the column number of City 2 (6 points)
3. Use INDEX function in cell D18 to determine the distance between City 1 and 2. Please reference the row number and the column number obtained in cells C13 and F13 respectively in your INDEX formula (12 points)

Note: Please verify that the formula results update themselves anytime you change the city names in C12 and F12.

AutoSave orr Data Review View Tell me Formulas Home Insert Draw Page Layout Wrap Te: X Calibri (Body) 11 A A E es a. A Merge & Paste I U B & Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for D18 x fx H 1 J K G F A E B D 1 1 Boston 2 Chicago 3 Dallas 4 Denver 5 LA 6 Miami 7 Phoenix 8 Seattle 2 3 4 5 6 7 8 9 10 11 12 Boston 0 983 1815 1991 3036 1539 2664 2612 Chicago 983 0 1205 1050 2112 1390 1729 2052 Dallas 1815 1205 0 801 1425 1332 1027 2404 Denver 1991 1050 801 0 1174 1332 836 1373 LA 3036 2112 1425 1174 0 2757 398 1909 Phoenix 2664 1729 1027 836 398 2359 Miami 1539 1390 1332 1332 2757 0 2359 3389 Seattle 2612 2052 2404 1373 1909 3389 1482 0 1482 0 City 1 Boston City 2 Seattle Row # Column # Use MATCH function Use MATCH function 13 14 15 16 17 18 19 Distance Use INDEX function. Reference the cells containing the MATCH formulas in your INDEX function 20 21 22 23 24 25 26 27 28 29 30