Feb 21

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:

Exercise 8

Exercise 17

Exercise 18 #1

Exercise 18 #2

Exercise 24

Exercise 25

Exercise 26

Exercise 29 #1

Exercise 29 #2

Exercise 34 #1

Exercise 34 #2

Exercise 35 #1

Exercise 35 #2

Exercise 35 #3

Exercise 35 #4

Exercise 35 #5

Exercise 35 #6

BONUS:

Exercise 22 & 27

Exercise 36 #1

Exercise 36 #2

Exercise 36 #3

Exercise 36#4

Exercise 36 #5

Exercise 36 #6

Exercise 36 #7 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s