Excel Activity 02

Post date: Apr 27, 2015 4:24:04 PM

            • Essential Questions:How can learning spreadsheet software help you be successful in the future?

Lesson Essential Question:

            • How can spreadsheets be used to communicate data effectively?

Directions:

1. Open Microsoft Excel 2013

2. Like we've done in Microsoft Word, go to File then Recent and open “Activity 1 and 2"

3. Select everything from A-4 to F-11. Go to the Insert tab, locate Charts, and click Column.

4. Look to the far right of the ribbon and click Move Chart. Here you can click "New Sheet:" and name it Chart. This will move your chart to a new sheet and call it Chart. You need to change it from chart1 to just chart.

5. Your Spreadsheet can have multiple sheets. On the bottom left, click on Sheet 2 to view your chart. Double click on Sheet 2 and change the name to "Chart." Use your mouse to drag it to the left and put it in front of Sheet1.

6. Make sure you are in the Chart sheet and select your chart. Go to Chart tools-Design and click Select Data. Remove the test so only the Average is shown.

7. You can change what information is displayed and what type of graph. How is this helpful in showing the information?

8. Save your work and submit to Edmodo.