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 cities.

3. Mark Cuban and the Dallas Mavericks 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?

4. 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.

5. The file Nbadistances.xlsx shows the distances 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?