Practice Working with Sheets and Data
In this exercise, you’ll create a workbook from an existing worksheet, make a copy of the worksheet within the workbook, and rename the new worksheet. Then you’ll delete rows of data and selected cells, shifting and reformatting the remaining data so that it’s legible. Finally, you’ll insert a new worksheet and populate it with selections of data from other sheets.
SET UP Open the AirQuality workbook from the ~/Documents/Microsoft Press/ 2008OfficeMacSBS/WorkSheets/ folder. This workbook consists of eight worksheets: one containing data for all of the United States and the others for specific regions.
In the lower-left corner of the workbook window, at the left end of the sheet tabs, click the Last Sheet ...