Problems

1. The file Mavs.xlsx contains statistics for the great 2002–2003 Dallas Mavericks basketball team. Player names are listed in column A, statistical categories are listed in row 3, and statistical results are listed in rows 4–20. Change the worksheet so that all player names are listed in the same row and all statistical categories are listed in the same column.

2. Field goal percentage, free throw percentage, and three-point percentage are listed as decimals. For example, Steve Nash makes 91.9 percent of his free throws, which is listed as .919. Change the worksheet so that all shooting percentages are listed as a number from 1 through 100.

3. The file Productpaste.xlsx contains data on quarterly sales for four products. Copy this data to another range so that quarterly sales are read across instead of down. Link your copied data to the original data so your computation of annual sales in the copied data range will reflect changes entered in rows 5–8.

4. The file Productsalespaste.xlsx contains sales of products x, y, and z (in thousands of units). Convert this sales data to sales in actual units. Hint: Remember you can use the Ctrl key (as explained in Chapter 1, “Range Names”) to select a non-contiguous range of cells.