Google Sheets L1

You want to use Google Forms and Google Sheets to collect and track different aspects of your students' work. Match the usage with its correct tool.

• Sheets:

  1, 2, 3

  Forms:

  4, 5

• Sheets:

  1, 2, 4

  Forms:

  3, 5

• Sheets:

  1, 2, 5

  Forms:

  3, 4

• Sheets:

  1, 3, 5

  Forms:

  2, 4

If you're exploring a Google Sheet with your workmates, you can create a filter view that only changes your view of the data. Which two actions that you can take?

• • Create and share filter view links that display data with specific keywords

• • Save and name multiple filter views for quick access and sorting later

• • Share different filter view links with different people, so each person sees the most relevant information

• • Filter views are currently available

What are the possible usage of Google Sheet? Please select 4.

• • Analyze data

• • Protect data from changes

• • Create a gradebook to track scores

• • Namelist

• • Notepad

A teacher in the class just finished summarizing her class scores. She would like to know which formulation can be used to get an average score for her class exam paper according to subjects. Choose 1 best answer.

• • =SUM

• • =AVERAGE

• • =PROPER

• • =CONCATENATE

• • =SPLIT

Mr Jim is searching for charts that are available in Google sheets to represent his data. Which of the following charts are available in Google Sheets? Select 4 correct answers.

• • Bar chart

• • Column chart

• • Line chart

• • Map 

• • Calendar