Activity 6: Sleepy Pie Chart



Activity 5: Sleepy Pie Chart

Essential Learning Skills: creating a Pie Chart, comparing two groups of data, chart formats including labels, titles, legends, moving charts on the spreadsheet, creating a footer, and setting up portrait format.

1. Open a new Spreadsheet file.

2. Ms. Brittany recently polled all the students attending SAOC. One of the questions she asked was, “Do you get enough sleep each night?” Enter the following information, which represents the responses.

Enough Sleep

Yes 53

No 100

3. Pie Chart

Choose a Pie Chart when you want to make comparisons based on parts of the whole.

• Select the spreadsheet data.

• Go to the insert tab and use the Charts group, and choose either the first 2-D pie chart option or the 3-D pie chart option.

• You should not need to make any changes in Step 2.

• Add a title, and make any other changes you wish to make on the format of the chart. Make sure percents are shown.

• After finishing the last step, you chart should look similar to this. . . .

4. Finishing

a. In the footer, type Activity 5, press enter and type your name.

b. Don’t forget to print preview to double check that your chart is just the way you want it.

c. Go to File and select Save. Name the file YourName Excel Act 5.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download