**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:

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