Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Index and Match You would like to take a trip to the following cities in the order listed in column C of the CityDistanceData worksheet.
Index and Match You would like to take a trip to the following cities in the order listed in column C of the CityDistanceData worksheet. Complete each of the tasks using the table of Major Cities and Distances to Other Major Cities data at the bottom of the CityDistanceData worksheet. (1.1) Complete range by calculating the distance between each city and the next city in the list. a. Place your calculation for the first distance in cell b. Use the INDEX function. c. Note that you will not calculate a distance in cell (D27) since there is not a city below Dallas on the bottom of the list. d. Reference range of the Table of Major Cities and Distances in your formula. e. The position of each city in the list of cities is included in column C and should be referenced in your formula. f. Reuse your formula to complete column D. (1.2) Calculate the total distance traveled. a. Place your calculation in cell D29. b. Use the SUM function. c. Reference the individual distances between the cities you calculated in the last step. (1.3) Calculate the row number for each city in column G of the table in range a. Place your calculation for the first row number in cell b. Use the MATCH function. c. Reuse your formula to complete column I by calculated the row number for all of the cities in column G. (1.4) Calculate the column number for each city in column H of the table in range a. Place your calculation for the first column number in cell b. Use the MATCH function. c. Reuse your formula to complete column J by calculated the row number for all of the cities in column H. (1.5) Calculate the distances between each pair of cities on the table in range a. Place your calculation for the first distance in cell b. Use the INDEX function. c. Reference the calculations of the row and column numbers calculated in the last two tasks. d. Reuse your formula to calculate the remaining distances in column K of the table
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started