9_3_10

Activity 1 - READ

To make it easier to view lots of data on a spreadsheet there are various options to change the way that you view the data. These settings can usually be found in the view settings of a spreadsheet package.

The settings available in both Google Sheets and Microsoft Excel are:

• View Gridlines
• Freeze Panes
• Show Formulae

Other settings related to layout features are the print settings. These allow you to choose exactly how a spreadsheet is printed. The most popular setting is:

• Fit to page
• Headers and Footers

Activity 2 - Watch the tutorials to find out how to use these skills

In Microsoft Excel...

In Google Sheets...

Continue to add to your guide with the new skills learned this session.

Think about when you might use these features to make your spreadsheets easier to read.

Students will need some time to practice the different formulas in the tutorials. It may be best to let students work through these tutorials independently.