The first formula totals the numbers in the eighth row (row 17) of the distances array; the formula totals the numbers in the eighth column (column j) of the distances array. in either ca find that the total distance from seattle to the other cities is 15,221 miles, as you can see in fig problems 1. use the index function to compute the distance between los angeles and phoenix and the distance between denver and miami. 2. use the index function to compute the total distance from dallas to the other seven cities listed in figure 4-1. jerry jones and the dallas cowboys are embarking on a road trip that takes them to chicago, denver, los angeles, phoenix, and seattle. how many miles will they travel on this road trip? 3. the file product. xlsx contains monthly sales for six products. use the index function to compute the sales of product 2 in march. use the index function to compute total sales during april. 4. 5. the file nbadistances. xlsx shows the distance between any pair of nba arenas. suppose you begin in atlanta, visit the arenas in the order listed, and then return to atlanta. how far would you travel? use the index function to solve problem 10 of chapter 3, "lookup functions." here is the problem again: the file employees. xlsx contains the ranking that each of 35 workers has given (on a 0-10 scale) to three jobs. the file also gives the job to which each worker is assigned. use a formula to compute each worker's ranking for the job to which the worker is assigned 6. the index nction