What is a function in Google Sheets?

Google Sheets: Working with Functions Quiz

Quiz
•
Information Technology (IT)
•
8th Grade
•
Easy
EDITH KATZFEY
Used 1+ times
FREE Resource
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
Similar Resources on Quizizz
10 questions
sheets

Quiz
•
8th Grade
10 questions
Câu hỏi về hàm SUMIF

Quiz
•
8th Grade
15 questions
Latihan Soal

Quiz
•
8th Grade
10 questions
Presentation Software Quiz Class 8

Quiz
•
8th Grade
10 questions
Post Test Aplikasi Kantor

Quiz
•
8th Grade
15 questions
Quiz Pre Test APlikasi Perkantoran

Quiz
•
8th Grade
14 questions
Google sheets

Quiz
•
7th Grade - University
10 questions
UHB Informatika Kelas VIII

Quiz
•
8th Grade
Popular Resources on Quizizz
25 questions
Equations of Circles

Quiz
•
10th - 11th Grade
30 questions
Week 5 Memory Builder 1 (Multiplication and Division Facts)

Quiz
•
9th Grade
33 questions
Unit 3 Summative - Summer School: Immune System

Quiz
•
10th Grade
10 questions
Writing and Identifying Ratios Practice

Quiz
•
5th - 6th Grade
36 questions
Prime and Composite Numbers

Quiz
•
5th Grade
14 questions
Exterior and Interior angles of Polygons

Quiz
•
8th Grade
37 questions
Camp Re-cap Week 1 (no regression)

Quiz
•
9th - 12th Grade
46 questions
Biology Semester 1 Review

Quiz
•
10th Grade