NEW
Font size
WorksheetsGoogle Sheets Fundamentals
Total questions: 29
Worksheet time: 16mins
When a column or row reference can be updated it does not have what symbol in front of it?
@
%
#
$
A logical expression evaluates either a True or False statement.
True
False
What is the argument in this function? =Max(B3:B15)
B3
Max
B3:B15
B15
What symbol designates that a cell has an absolute cell reference associated with it?
@
#
$
&
Which of the following functions adds together the values in a range of cells?
MAX
SUM
AVERAGE
COUNT
Does the data header information have to be BOLD to make sorting of data easier?
NO
YES
Conditional formatting is used when you want to highlight negative numbers by red text.
True
False
Filtering in a spreadsheet hides the data you do not want to see.
True
False
When you want to apply total sales in dollars to a cell which number format would you choose?
Percentage
Date
Currency
What does it mean to merge cells?
apply a border around a set of cells
center the text content in the center of the cell
combine cells into a single cell
split a single cell into multiple cells
What column or row references would be updated when you copy the formula? = sum(C3:$d25)
Column D and Row 25
Column C and Row 3 and Row 25
Column C and Row 3
Column D and Row 3
Which of the following functions returns the largest number from the range of cells?
SUM
AVERAGE
MIN
MAX
If A2=4 and B2=3, what would the following function return?
=IF(A2+B2<10,"In-Progress","Done")
"In-Progress"
"Done"
What column or row references are updated when you copy the formula =C$6+10?
Row 6
Value 10
Column C and Row 6
Column C
When you hide a column it doesn't appear, but the data is still there.
True
False
Which column and row references are updated when you copy the formula =c$10-d$5?
Row 10 and 5
Column C and D
Column C and Row 10
Column D and Row 5
What formula uses relative cell references?
5*10=20
$A$6+30
F18+F19/2
$B$9/100
What set of data is in descending order?
4, 3, 1, 2
7/1/2017, 6/2/2017, 5/3/2018, 4/2/2016
grapes, pineapples, bananas, oranges
sheep, rabbits, ponies, ostriches
If A2=6 and B2=8, what would the following function return?
=IF(A2+B2<10,"In-Progress","Done")
"Done"
"In-Progress"
What are the operands in this formula?
A
B
C
D
Would you click letter D to access the sort and filter commands?
YES
NO
Where would you click to hide a column?
A
B
C
D
Do you change the cell format to a date by clicking on the letter C?
YES
NO
Where would you click on the Tool bar to add a border around a cell?
A
B
C
D
E
Where would you click to show a hidden column?
A
B
C
D
E
When you are merging several cells together would you click on Letter D?
YES
NO
What function should be entered into B7 to calculate the total budget?
=CALCULATE(B3:B6)
=AVERAGE(B3:B6)
=SUM(B3:B6)
=SUM(B3-B6)
What are the operators in the formula?
A
B
C
D
Is Column B being used to filter this spreadsheet?
YES
NO
