NEW
Font size
S
M
L
XL
WorksheetsGoogle Sheets Skills
Total questions: 11
Worksheet time: 6mins
Name
Class
Date
1.
Allows you to narrow down data in your worksheets
a)
Sorting
b)
Filtering
c)
Absolute Cell Reference
d)
Merge Cells
2.
A relative cell reference does NOT change when copied to another cell.
a)
True
b)
False
3.
Which calculation comes first in the sheets formula 3^2/5+(12-3)?
a)
3^2
b)
5 + 12
c)
12 - 3
d)
2/5
4.
What symbol must be placed before and after the column letter to create an absolute reference?
a)
#
b)
?
c)
/
d)
$
5.
The name of a cell (for example, A1) is its cell ________.
a)
address
b)
heading
c)
range
d)
content
6.
The following symbols are recognized as mathematical operators within Google Sheets
a)
*
b)
X
c)
p
d)
'
7.
Why would you want to freeze rows in your spreadsheet?
a)
To limit the data that can be entered in the frozen row
b)
Scroll through the spreadsheet continuing to see frozen rows
c)
To modify only the frozen rows
d)
To control the rows from being edited by collaborators
8.
Which function would you use to add the values of several cells?
a)
SUM
b)
AVERAGE
c)
MIN
d)
MAX
9.
If you wanted to arrange your data by column A from highest to lowest value, you would _____ it.
a)
Sort
b)
Filter
c)
Add
d)
Reference
10.
You would use this function to get the highest value in a range of cells
a)
SUM
b)
AVERAGE
c)
MIN
d)
MAX
11.
=(A1:A8) is an example of a cell _______.
a)
reference
b)
range
c)
address
d)
content
Reset
