WorksheetsGoogle Sheets Quiz
Total questions: 20
Worksheet time: 16mins
Name
Class
Date
1.
What is a vertical section of a spreadsheet
a)
row
b)
addition
c)
column
d)
format
2.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
3.
B1 is a?
a)
row
b)
column
c)
cell
d)
sheet
4.
What number is in D1?
a)
1
b)
2
c)
blank
d)
4
5.
All formulas in Microsoft Excel and Google Sheets begin with the following symbol:
a)
+
b)
-
c)
=
d)
%
6.
Opening a new file in this app is called a
a)
row
b)
column
c)
cell
d)
sheet
7.
What number should be in E1 (based on the formula)?
a)
1
b)
2
c)
5
d)
9
8.
Which is the correct formula to add cells A1 to A5?
a)
=SUM(A2+A5)
b)
=SUM(A1:A5)
c)
=A1+A2+A3
d)
=SUM(A1:A4)
9.
Which letter on the image is a Column?
a)
A
b)
B
c)
C
d)
D
10.
Which letter on the image is a Row?
a)
A
b)
B
c)
C
d)
D
11.
If I want to make a cell a particular color, which button would I click on?
a)
arrow 1
b)
arrow 2
c)
arrow 3
d)
arrow 4
12.
In a Google Spreadsheet, the numbers down the left side represent __________.
a)
Rows
b)
Columns
c)
Headers
d)
Functions
13.
In a Google Spreadsheet, where a column and row intersect is called a ________.
a)
Rectangle
b)
Square
c)
Cell
d)
Intersection
14.
In a Google Spreadsheet, you can format a column by clicking on the $ sign in the toolbar to format it as ___________.
a)
Numbers
b)
Automatic
c)
Decimals
d)
Currency (money)
15.
In a Google Spreadsheet, selecting the SUM function from the toolbar will perform what mathematical option?
a)
Subtraction
b)
Multiplication
c)
Division
d)
Addition
16.
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
17.
Google Sheets is used to?
a)
Add numbers.
b)
Make charts (graphs).
c)
Put information in columns and rows.
d)
All of the above.
18.
Select ___________________ from the functions menu to find the average in a group.
a)
max
b)
average
c)
sum
d)
min
19.
What is a vertical section of a spreadsheet?
a)
row
b)
cell
c)
column
d)
format
20.
Select ___________________ from the functions menu to find the smallest value in a group.
a)
max
b)
min
c)
sum
d)
average
100 %
