NEW
Font size
WorksheetsGoogle Sheets
Total questions: 29
Worksheet time: 15mins
Which letter on the image is a Column?
A
B
C
D
Which method is best for selecting the cells highlighted in red?
Click and drag the mouse to select the cells.
Press the Shift key and click on the cells.
Press the Ctrl key and click on the cells.
Press the Alt key and click on the cells.
Where would you click to select a column?
A
B
C
D
Which keyboard shortcut would you press to copy cells that are selected in a spreadsheet?
Ctrl+Z
Ctrl+X
Ctrl+V
Ctrl+C
Which letter on the image is a Row?
A
B
C
D
Which letter on the image is a Cell?
A
B
C
D
Which option would you use to select the cells?
Press the Ctrl key and click on the cells.
Click and drag the mouse to select the cells.
Press the Shift key and click on the cells.
Press the Alt key and click on the cells.
In the formula =A3/B3, what part of the formula is the "/"?
An operator
An operand
Which of the following uses a function to calculate the total value for cells B2 through B5?
=SUM(B2:B5)
=B2+B3+B4+B5
=13.5+6.08+7.53+45.1
=B1++B5
Which option would give you the value of 2?
=MIN(A2:B5)
=MAX(A2:B5)
=AVERAGE(A2:B5)
=SUM(A2:B5)
Where is the formula bar located?
A
B
C
D
What function would you use to add B3:B6?
=SUM(B3:B6)
=CALCULATE(B3:B6)
=SUM(B3-B6)
=AVERAGE(B3:B6)
Which of the following functions adds a range of cells and then divides by the number of cell entries?
MAX
MIN
AVERAGE
SUM
Which of the following functions returns the smallest number from a range of cells?
MAX
SUM
AVERAGE
MIN
What symbol is used to designate an absolute cell reference?
%
$
@
!
Which column and row references are updated when you copy the function: =SUM($B5:D$15)?
Column B and row 5
Column B and row 15
Column D and row 5
Column D and row 15
Which column and row references are updated when you copy the formula: =$A$9-B2?
Column A and B
Column A and Row 9
Column B and Row 2
Row 9 and 2
Which column and row references are updated when you copy the formula: =F$5+12?
Row 5
Value 12
Column F
Column F and row 5
What are the operators in the formula?
A
B
C
D
What are the operands in the formula?
A
B
C
D
In a spreadsheet all formulas must begin with what symbol?
!
=
+
-
Which of the following is ascending order?
A-Z
Z-A
AZ-ZA
ZA-BA
Which set of data is in descending order?
A-Z
Z-A
AZ-ZA
AZ-BZ
What does filtering data in a spreadsheet do?
Hides the data you are looking for.
Hides data that you do not want to see.
Shows all the data in the spreadsheet.
Shows data that did not meet the criteria.
Where would you click to access the filter commands?
A
B
C
D
E
Columns are labeled by _____
Numbers
Symbols
Letters
Colors
Rows are labeled by _____
Numbers
Letters
Symbols
Colors
True or False - You can have multiple sheets within the same Google Sheet Document
True
False
Which Google Application has been your favorite?
Google Docs
Google Slides
Google Sheets
