wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Google Sheets Quizizz

Total questions: 50

Worksheet time: 58mins

Name
Class
Date
1.
All formulas in Google Sheets begin with the following symbol:
a)
+
b)
-
c)
=
d)
%
2.
Which is the correct formula to add cells A1 to A5?
a)
=SUM(A1+A5)
b)
=SUM(A1:A5)
c)
=A1+A2+A3
d)
=SUM(A1:A4)
3.
What is the name of a vertical section of a spreadsheet as selected in the image?
a)
row
b)
cell
c)
column
d)
format
4.
Select ___________________ from the functions menu to find the smallest value in a group.
a)
max
b)
min
c)
sum
d)
average
5.
Select ______________ from the functions drop-down menu to add a set of numbers together. 
a)
average
b)
count
c)
max
d)
sum
6.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
7.
Columns are labeled by ______________.
a)
numbers
b)
letters
c)
symbols
d)
colors
8.
Rows are labeled by __________.
a)
numbers
b)
letters
c)
symbols
d)
colors
9.

Using this picture, what would the formula be to find the average in B16 for the given set of data?

a)

+AVERAGE(B2:B13)

b)

=AVERAGE(B2:B13)

c)

=AVERAGE(A2:A13)

d)

+AVERAGE(A2:A13)

10.
In a Google Spreadsheet, you can manually type the function/formula in a cell if the operation is not available in the function drop-down list.
a)
True
b)
False
11.

Which sequence of keyboard shortcuts would you use to COPY information from one cell to another?

a)

Ctrl+X then Ctrl+V

b)

Ctrl+C then Ctrl+V

c)

Ctrl+X then Ctrl+Z

d)

Ctrl+V then Ctrl+Z

12.
You can have multiple sheets within the same Google Sheet document.
a)
True
b)
False
13.
What number should be in E1 (based on the formula)?
a)
1
b)
2
c)
5
d)
9
14.
A ____________ is where a row and column meet.
a)
sheet
b)
formula
c)
blank
d)
cell
15.
It is possible to insert images in Google Sheets
a)
True
b)
False
16.
What is this icon?
a)
sheets
b)
slides
c)
docs
d)
classroom
17.
What is this icon?
a)
sheets
b)
docs
c)
classroom
d)
youtube
18.
What is this icon?
a)
slides
b)
chrome
c)
drive
d)
classroom
19.
What is this icon?
a)
drive
b)
slides
c)
sheets
d)
classroom
20.

What does the AVERAGE function do?

a)

Adds all the numbers together

b)

Finds the middle value in a list

c)

Finds the highest value

d)

Finds the lowest value

21.

If you want to change the background color of a cell, you should use:

a)

The Fill Color tool

b)

The SUM function

c)

The Sort tool

d)

The Delete button

22.

Which of the following is NOT a function in Google Sheets?

a)

SUM

b)

AVERAGE

c)

PRINT

d)

MIN

23.

What function should be entered into B7 to calculate the total budget?

a)

=SUM(B3:B6)

b)

=CALCULATE(B3:B6

c)

=SUM(B3-B6)

d)

=AVERAGE(B3:B6)

24.

Google sheets is useful for sorting data and calculating numbers.

a)

True

b)

False

25.

What would you click to add borders to all your cells?

a)
b)
c)
d)
26.

Which icon will change the color of the cell?

a)
b)
c)
d)
27.

How can you center the title of your spreadsheet in a single large cell in Google Sheets?

a)

Select All button

b)

Merge cells

c)

Auto size the column

d)

Right-click and choose from the menu

28.

Spreadsheets are a great way to _____________ information.

a)

spread

b)

organize

c)

add

d)

subtract

29.

The location of this cell is...

a)

B 1

b)

A 1

c)

C 1

d)

0 0

30.

How do you drag and drop in Google spreadsheets?

a)

Right click on the cell and select drag.

b)

Double click on a cell and then drag it to where you want it.

c)

Hover over the outer blue edge of the selected cell until the hand appears and drag it to where you want to drop it.

d)

Hover over the center of the selected cell until the hand appears and drag it to where you want to drop it.

31.

What is the purpose of adding headings to a spreadsheet in Google Sheets?

a)

Headings help organize and categorize data in the spreadsheet.

b)

It adds a title to the sheet for decoration purposes.

c)

Headings allow you to format the text in various styles and colors.

d)

All the above.

32.

What does this button do?

a)

Merge the cells

b)

Border the cells

c)

Change the alignment in the cells

d)

Change the color in the cells

33.

How do you resize your row or column?

a)

click the row or column> merge cells

b)

click on the row or column borders> drag it to the desired size

c)

click on the row or column> format> resize> choose measurements

d)

click on the row or column> insert> new row or column

34.

What does this button do?

a)

Border the cells

b)

Merge the cells

c)

Change the alignment in the cells

d)

Change the color in the cells

35.

Wrap text:

a)

when cells wrap a word

b)

cells that are ready for data entry

c)

this will automatically modify a cell's height, allowing the cell's contents to be displayed on multiple lines

d)

cells that have no information

36.

Why do formulas make spreadsheets more powerful?

a)

They allow for automatic calculations and data analysis.

b)

They make the spreadsheet look more colorful.

c)

They reduce the file size of the spreadsheet.

d)

They increase the loading time of the spreadsheet.

37.

In order to perform calculations in Google Sheets which button do you select on the toolbar?

a)

++  

b)

Σ\Sigma  

c)

xy←\overleftarrow{xy}  

d)

==  

38.

You can use Spreadsheets to create graphs.

a)

Yes

b)

No

c)

Sometimes

39.

What does autofill do in Sheets?

a)

Allows you to add the content within multiple cells together

b)

Changes the size of the cell to fit the words or data within

c)

Changes the font, text size, text color, etc.

d)

Completes a series of text, numbers, or dates

40.

Which cursor represents AUTOFILL

a)

b)
c)

d)
41.

What is Google Sheets comparable to?

a)

Microsoft Word

b)

Google Docs

c)

Microsoft Excel

d)

Microsoft Powerpoint

42.

What is the first thing you should do when you create a Google Sheet?

a)

Save it

b)

Name it

c)

Double check where you saved it

d)

Start entering information in the spreadsheet

43.
Used to collect data and charts
a)
Docs
b)
Slides
c)
Sheets
d)
Forms
44.
Why is there no Save button for your files?
a)
No changes are ever saved.
b)
Google Drive uses autosave, which automatically and immediately saves your files as you edit them.
c)
The Save button is in the “File” submenu.
d)
You “Right-Click” to get the Save function. 
45.

Dr. Wiley needs to create a budget for his doctor's office? Which application should he use?

a)

Google Sheets

b)

Google Slides

c)

Google Docs

46.

A soccer league wants to calculate its average attendance per game. Which application should the league use?

a)

Google Slides

b)

Google Sheets

c)

Google Docs

47.

What is the keyboard shortcut for copy?

a)

Ctrl+P

b)

Ctrl+V

c)

Ctrl+C

d)

Ctrl+Z

48.

Mr. Tone wanted to see which student received the highest score on the last Quizizz. In his spread sheet he used the ______________ function to identify the highest score.Mi

a)

Sum

b)

Average

c)

Count

d)

Max

e)

Min

49.

Betty has a spreadsheet of sales for her bakery for a month. In one column she lists the amount of donuts sold each day. If she wanted to find out what day she sold the LEAST amount of donuts she would use the _________________ function.

a)

Sum

b)

Average

c)

Count

d)

Max

e)

Min

50.
Which of the following is a correctly named cell?
a)
8B
b)
B8
c)
8-B
d)
BB-8

Similar Resources on Wayground

Math Review 2nd Grade

55 questions

Math Review 2nd Grade

quiz

Worksheet

•

2nd Grade - University

BF10 Unit 3 and 4

49 questions

BF10 Unit 3 and 4

quiz

Worksheet

•

6th Grade

Fundamentals of Entrepreneurship

50 questions

Fundamentals of Entrepreneurship

quiz

Worksheet

•

7th Grade

Business Studies 3rd Term EXAM 2021/2022 ACADEMIC SESSION

50 questions

Business Studies 3rd Term EXAM 2021/2022 ACADEMIC SESSION

quiz

Worksheet

•

7th Grade

Yr10Loungerlizards

47 questions

Yr10Loungerlizards

quiz

Worksheet

•

1st - 6th Grade

Topic 3 Accounting Cycles

50 questions

Topic 3 Accounting Cycles

quiz

Worksheet

•

1st Grade - University

Year 8 Econs & Business - Weeks 1-2

50 questions

Year 8 Econs & Business - Weeks 1-2

quiz

Worksheet

•

8th Grade

IBT Final Exam

50 questions

IBT Final Exam

quiz

Worksheet

•

6th - 12th Grade