Activity 9: Comparing Data in a Line Chart
Activity 8: Comparing Data in a Line Chart
Essential Learning Skills: creating a Line Chart, comparing two groups of data, changing chart formats including labels, titles, legends, moving charts on the spreadsheet, creating a footer, and setting up Landscape format.
1. Open a new Spreadsheet file.
2. It’s June and the manager of the school store at Baker Middle School is getting ready to order supplies for next September. The manager wants to examine trends over the past two years before making any ordering decisions. Type the following information into the spreadsheet file.
3. Format Changes
• Widen the columns that need to be widened.
• Center the contents of columns B and C.
• Format the numbers in columns B and C to be displayed as currency.
3. Create a line chart.
• Select the contents of cells A1 through C5.
• Click the Chart Wizard button form the Standard Toolbar.
• Choose Line and select the sub-type you desire.
• Give your chart a title and make any format changes you may like.
• Your chart should look something like this . . . . .
4. Finishing
• In the footer, type Activity 8, press enter and type your name.
• Don’t forget to print preview to double check that your chart is just the way you want it.
• Go to File and select Save. Name the file SS Act 8.
• Only when instructed to print, print in landscape format.
• Submit through Edmodo or as directed by your teacher.
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- plotting in excel
- how to make a line graph with multiple lines
- statistics for everyone
- a beginner s guide to simrad chartplotters
- activity 9 comparing data in a line chart
- step by step 1 select data to include in a chart
- sample hiring process step chart
- activity 8 making a line chart
- how to make an excel line graph ms brannagan s page
Related searches
- activity 9 2 cellular respiration answers
- comparing data sets calculator
- create line chart in excel
- secant line in a circle
- excel comparing data in 2 worksheets
- comparing data in excel columns
- convert data in a column in pandas
- comparing characters in a story
- comparing two sets of data in excel
- pie chart data in excel
- how to put a line in html
- activity 9 2 modeling cellular respiration