Problems

1. The file Stock.xlsx contains monthly stock returns for General Motors and Microsoft. Name the ranges containing the monthly returns for each stock, and compute the average monthly return on each stock.

2. Open a worksheet and name the range containing the cells A1:B3 and A6:B8 as Red.

3. Given the latitude and longitude of any two cities, the file Citydistances.xlsx computes the distance between any two cities. Define range names for the latitude and longitude of each city and ensure that these names show up in the formula for total distance.