1) Try: Exercise 34 page and Exercise 35 page.
These exercises reviews charting (graphing) in spreadsheets. Answer the following questions in your notebook:
a) Name the types of graphs that can be created in the spreadsheet program you are using?
There are several types of graphs that can be created in the Excel spreadsheet program. Users are able to insert bar, pie, line, area, scatter and graphs and charts. As well there are special charts such as doughnut, bubble, radar, surface and stock charts.
b) Outline the steps to create a graph
To create a graph using the data in your spreadsheet, simply copy the data that you would like to include in your graph. Next, select the Insert tab and select which graph or chart you would like to use in the chart tab. A graph will be created by the program and you can add additional features to the graph by clicking on Design, Layout and Format. In these tabs found in the chart tools tab that automatically pops up once a graph is created; users can add axis and chart titles, data labels, colours and can change the design of the chart.
c) How do you print to a PDF file from your spreadsheet program?
To print a PDF file from the Excel spreadsheet program select the PDF tab than click save as PDF. This will save the spreadsheet that you have created as a PDF on your computer. To print a PDF click on the File tab, Print, select the printer that you would like to use as PDF complete. This will save your document as PDF on your computer.
2) Print the following spreadsheets to PDF files, upload the PDF files to google drive (or another cloud storage area) and link them into your notebook here: