Excel Exercise 11 Formatting Worksheets


Open the file and save it as MSI Report 8
  1. Activate the Sales Comparison sheet and select the range A1:E9. Copy the selected range to the Clipboard. Activate Sheet2 and paste the selected range to the corresponding cells in Sheet2. Apply the Classic 1 Autoformat to this range
  2. Insert a new worksheet (Insert, Worksheet) and return to the Sales Comparison sheet and copy the range A1:E9 to the corresponding cells in the new sheet. Apply the 3D Effects2 Autoformat to this range
  3. Use the delete sheet command from the edit menu to delete the Title Sheet sheet
  4. Move the Sales Comparison sheet so it is the third sheet in the workbook and save.