Google Sheets: Working with Functions Quiz

Google Sheets: Working with Functions Quiz

8th Grade

10 Qs

quiz-placeholder

Similar activities

Google Sheets: Sorting and Filtering Data Quiz

Google Sheets: Sorting and Filtering Data Quiz

8th Grade

10 Qs

MIS-RODOCODO

MIS-RODOCODO

1st Grade - University

8 Qs

KUIS TIK XLS

KUIS TIK XLS

8th Grade

10 Qs

UHB Informatika Kelas VIII

UHB Informatika Kelas VIII

8th Grade

10 Qs

formatif Informatika kelas 8 1

formatif Informatika kelas 8 1

8th Grade

15 Qs

Presentation Software Quiz Class 8

Presentation Software Quiz Class 8

8th Grade

10 Qs

Ulangan Semester Genap

Ulangan Semester Genap

8th Grade

10 Qs

Excel Bases 1

Excel Bases 1

8th Grade

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?