Google Workspace, Session 6: Processing numerical data using Google Sheets, Part 2

Welcome to Google Workspace, Session 6.

In this session – Processing numerical data using Google Sheets, Part 2 – you will build on what you learned about Google Sheets in Session 5. You will create a marksheet, learn how to perform calculations using formulae, and create charts and graphs. 

By the end of the session, you will:

• have produced a marksheet
• know how to use formulae to perform calculations (addition, subtraction, multiplication and division)
• understand the order of preference
• understand the difference between and among Cell Names, Ranges and References
• know how to use basic functions to solve simple problems (MIN, MAX, SUM, COUNT and AVERAGE)
• identify problems based on error indicators (#VALUE, #NAME, #NUM, #REF and #DIV/0)
• understand how to troubleshoot basic errors in formulae and functions
• know how to work with sheets in a spreadsheet (insert, delete and rename)
• know how to perform calculations using functions (COUNTA, COUNTBLANK, ROUND and COUNTIF)
• be able to present numerical data
• know how to create graphs/charts from given data and choose appropriate graph types (column, line and pie)
• be able to edit graphs (chart title, axis titles, data labels and legend)
• understand how to troubleshoot basic problems in graphs

We suggest that you download the Class Notes first so you can follow along during the training.