Google Sheets Functions Quiz

Google Sheets Functions Quiz

10th Grade

10 Qs

quiz-placeholder

Similar activities

IoT Chapter 2 Review

IoT Chapter 2 Review

9th - 12th Grade

14 Qs

Quiz Microsoft Excel

Quiz Microsoft Excel

9th - 12th Grade

10 Qs

Thukable SC Assessment 2

Thukable SC Assessment 2

7th - 12th Grade

15 Qs

Spreadsheet Rumus statistik

Spreadsheet Rumus statistik

10th Grade

10 Qs

Cryptography

Cryptography

6th Grade - University

15 Qs

Python - Year 8

Python - Year 8

3rd Grade - University

10 Qs

Recuperação - Pensamento Computacional - 1ª Série NEM

Recuperação - Pensamento Computacional - 1ª Série NEM

9th - 12th Grade

12 Qs

Grade 7 MS Excel Quiz

Grade 7 MS Excel Quiz

7th - 10th Grade

10 Qs

Google Sheets Functions Quiz

Google Sheets Functions Quiz

Assessment

Quiz

Computers

10th Grade

Practice Problem

Hard

Created by

Migma Dorji

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the TRIM function do in Google Sheets?

Removes extra spaces from text

Combines multiple cells into one

Looks up a value in a table

Calculates the average of a range

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function is used to combine text from multiple cells?

VLOOKUP

TRIM

CONCATENATE

SUMIF

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of the VLOOKUP function?

To calculate the sum of a range

To find a value in a vertical column

To remove spaces from text

To average a set of numbers

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function would you use to look up data horizontally?

HLOOKUP

SUMIFS

AVERAGEIF

TRIM

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the SUMIF function do?

Adds numbers based on a condition

Calculates the average of a range

Looks up a value in a table

Combines text from multiple cells

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the difference between SUMIF and SUMIFS?

SUMIF is for horizontal data, SUMIFS is for vertical

There is no difference

SUMIF averages data, SUMIFS sums data

SUMIF uses one condition, SUMIFS uses multiple

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function calculates the average based on a condition?

CONCATENATE

TRIM

SUMIF

AVERAGEIF

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?