Building a New Computer Lab

SOLs CT 6-8.4 - 6-8.6, CT 6-8.8

Follow these directions to create a spreadsheet that explains the costs of creating a new computer lab at a school.

Step 1 - Create the following spreadsheet:

Step 2 - In Column D find the total cost for each item. This is the formula for multiplication: =(b2*c2).

Step 3 - In cell D10 find the total cost for the lab. =sum(d2:d9)

Step 4 - Create the following chart:

  1. You do not need to include column B or C, so hide them by right-clicking the columns letter and selecting Hide
  2. You do not need to include row 10 in your chart so do not highlight it.
  3. Create a 3D pie chart that looks like the example chart.
  4. Maximize Excel
  5. Add labels by going to the Design tab, then look at the Quick Layout group in the ribbon.