Spreadsheet 1D

Use the data in the spreadsheet below to create a spreadsheet and graph that shows the percentage of past year drug use by drug for 12th graders in 2007.

1. Merge cells A1 and B1 and type: 2007 Monitoring the Future Study.

2. Title cell A2: Drug

3. Title cell B2: Prevalence

4. Fill in the data using the spreadsheet. Instead of two columns, make one long list.

5.The numbers under "Prev." should be put in percentage format.

6. Then use the spreadsheet to create a graph/chart of your choosing that shows the data.

7. Type your name into the header.

8. Print your spreadsheet and chart to printer Dell 1710

9. Save your workbook as "Spreadsheet1D" and put in your projects folder.