Day 63

Upon completion of Lesson 7, you will be able to:

  • Move between worksheets in a workbook.
  • Rename worksheets.
  • Change the color of sheet tabs.
  • Reposition worksheets.
  • Hide and unhide worksheets.
  • Insert and delete worksheets.
  • Create cell references to other worksheets.
  • Print all or part of workbooks.

Project 7-1

  1. Open the Rainfall Data File. Rename the workbook as Rainfall Records followed by your initials.
  2. Rename the worksheets and change the sheet tab colors as listed below:
    • Worksheet New Name Tab Color
      Sheet 1 Annual Blue
      Sheet 2 January Light Blue 3
      Sheet 3 February Light Blue 2
      Sheet 4 March Light Blue 1

       

  3. In the Annual worksheet, in cell B3, display the total rainfall recorded in the January worksheet in cell B34.
  4. In the Annual worksheet, in cell B4, display the total rainfall recorded in the February worksheet in cell B31.
  5. In the Annual worksheet, in cell B5, display the total rainfall recorded in the March worksheet in cell B34.
  6. Close the workbook.

Project 7-2

  1. Open the Voting Data File. Rename the workbook as Voting Tally followed by your initials.
  2. Rename the worksheets and change the sheet tab colors as listed below:
    • Worksheet New Name Tab Color
      Sheet1 District 5 Red
      Sheet2 P107 Yellow
      Sheet3 P106 Purple
      Sheet4 P105 Green

       

  3. Reposition the worksheets so they appear in the following order: District 5, P105, P106, and P107.
  4. In the District 5 worksheet, in cell D7, enter a formula that adds the values in cell C5 of each of the precinct worksheets.
  5. In the District 5 worksheet, in cell D9, enter a formula that adds the values in cell C7 of each of the precinct worksheets.
  6. In the District 5 worksheet, in cell D11, enter a formula that adds the values in cell C9 of each of the precinct worksheets.
  7. In the District 5 worksheet, in cell D13, enter a formula that adds the values in cell C11 of each of the precinct worksheets.
  8. Close the workbook.

Project 7-3

  1. Open the Alamo Data File. Save the workbook as Alamo Amalgamated followed by your initials.
  2. Change the sheet tab colors as listed below:
    • Worksheet Tab Color
      Consolidated Green
      Alamogordo Light Green 3
      Artesia Light Blue 3

       

  3. In the Consolidated worksheet, in cell D6, enter a formula that adds the values in cell B6 of the Alamogordo and Artesia worksheets.
  4. In the Consolidated worksheet, in cell D7, enter a formula that adds the values in cell B7 of the Alamogordo and Artesia worksheets.
  5. In the Consolidated worksheet, in cell D9, enter a formula that adds the values in cell B9 of the Alamogordo and Artesia worksheets.
  6. In the Consolidated worksheet, in cell D10, enter a formula that adds the values in cell B10 of the Alamogordo and Artesia worksheets.
  7. Close the workbook.

Project 7-4

  1. Open the United Data File. Save the workbook as United Circuitry followed by your initials.
  2. Change the worksheet tab colors as listed below:
    • Worksheet Tab Color
      Year Red
      January Purple
      February Orange
      March Blue

       

  3. In the Year worksheet, in cells B5, B6, and B7, display the total January monthly production for Circuits 370, 380, and 390. These values are recorded in the January worksheet in the range F4:F6.
  4. In the Year worksheet, in cells C5, C6, and C7, display the total February monthly production for each circuit. These values are recorded in the February worksheet in the range F4:F6.
  5. In the Year worksheet, in cells D5, D6, and D7, display the total March monthly production for each circuit. These values are recorded in the March worksheet in the range F4:F6.
  6. Close the workbook.