WorksheetsDA02: Sheet 1
Total questions: 10
Worksheet time: 2mins
Q.
What number should be in E1 (based on the formula)?
5
9
10
20
All formulas in Google sheets begin with the following symbol:
$
=
%
&
What is the name of the selected cells?
C6
A1:E15
E1
B4:D8
Columns and rows are labeled by ______________.
Columns: numbers
Rows: letters
Columns: letters
Rows: numbers
Columns: symbols
Rows: numbers
Columns: numbers
Rows: symbols
What is the little triangle in the top right corner of a cell? It means there is a ________ with that cell.
black: note
gold: comment
black: comment
gold: note
black: comment
gold: error
black: error
gold: comment
A ____________ is where a row and a column meet.
table
formula
sheet
cell
What is shown for the selected column in the red mark?
B2:B16
2:2
B:B
B1
1. to add a set of numbers.
2. to find the smallest value in a group.
1. SUM
2. MIN
1. ADD
2. FIND
1. ADD
2. SMALL
1. SUM
2. SMALL
Text wrapping in Sheets means the text will be on more than 1 line within the cell.
True
False
What is a Sheet feature to limit choices in a cell or range to do data quality control?
Data validation
Filter
Sort
Protected sheet and range
