Google Sheets: Working with Functions Quiz

Google Sheets: Working with Functions Quiz

8th Grade

10 Qs

quiz-placeholder

Similar activities

Câu hỏi về hàm SUMIF

Câu hỏi về hàm SUMIF

8th Grade

10 Qs

Presentation Software Quiz Class 8

Presentation Software Quiz Class 8

8th Grade

10 Qs

Post Test Aplikasi Kantor

Post Test Aplikasi Kantor

8th Grade

10 Qs

Quiz Pre Test APlikasi Perkantoran

Quiz Pre Test APlikasi Perkantoran

8th Grade

15 Qs

Google Sheets: Creating Simple Formulas Quiz

Google Sheets: Creating Simple Formulas Quiz

8th Grade

10 Qs

UHB Informatika Kelas VIII

UHB Informatika Kelas VIII

8th Grade

10 Qs

sheets

sheets

8th Grade

10 Qs

Ce știi despre aplicațiile Google?

Ce știi despre aplicațiile Google?

1st Grade - University

10 Qs

Google Sheets: Working with Functions Quiz

Google Sheets: Working with Functions Quiz

Assessment

Quiz

Information Technology (IT)

8th Grade

Easy

Created by

EDITH KATZFEY

Used 1+ times

FREE Resource

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a function in Google Sheets?

A way to create charts

A method to sort data

A tool to format cells

A predefined formula that performs calculations

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What symbol is used to start a function in Google Sheets?

#

=

+

-

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function would you use to find the average of a range of cells?

AVERAGE

SUM

MAX

COUNT

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How are multiple arguments separated in a function?

By a semicolon

By a space

By a comma

By a colon

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the SUM function do?

Finds the minimum value

Adds all the values of the cells

Counts the number of cells

Finds the maximum value

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function would you use to count the number of cells with numerical data?

MIN

AVERAGE

MAX

COUNT

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the correct syntax for the AVERAGE function?

=AVERAGE B1;B9

=AVERAGE(B1:B9)

=AVERAGE B1:B9

=AVERAGE(B1;B9)

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?

Discover more resources for Information Technology (IT)