NEW
Font size
WorksheetsExcel Quiz 2
Total questions: 14
Worksheet time: 7mins
The IF Statement takes a logical test and determines a result that is either True or False.
True
False
If the cell B2 is 68, what will this IF function give you as a result? =IF (B2>60, 'pass', 'fail')
60
pass
fail
Which of the formulas below contain the correct syntax (formula arguments) for the VLOOKUP function?
=VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
=VLOOKUP(table_array, lookup_value, col_index_num, range_lookup)
=VLOOKUP(lookup_value, table_array, col_index_num, value)
Which of the following is NOT possible with VLOOKUP?
You can lookup values located in a different worksheet.
You can lookup values located in a column to the right of the column that contains the lookup value.
You can lookup values located in a column to the left of the column that contains the lookup value.
What is a Pivot Table?
A table containing data that is organized horizontally.
A table used to calculate financial pivot values.
A tool used to summarize data.
A table containing only black, grey and white formatting
The formula that adds values in a specified range that meet a certain condition or criteria is called:
SUMIFS
SUMIF
COUNTIF
SUBTOTAL
The formula used to make the error return value of a function look "pretty" or clean and non-confusing is:
IFERROR
IF
ERROR
VLOOKUP
To combine text that is in two different cells, use the formula:
COMBINE
MATCH
CONCATENATE
SUBTOTAL
Which conditional formatting feature can be used to identify duplicate values on a worksheet?
Data Bars
Highlight Cell Rules
Top / Bottom Rules
Color Scales
To count how many cells have text in them, use the function:
COUNT
COUNTIF
COUNTA
TEXT
You can have multiple sheets within the same Google Sheet document.
False
True
A sales manager has requested the highest sale for the first quarter. Which function will be used?
SUM
HIGHEST
MAX
TOTAL
Samantha needs to total the cell range A1 to A10. What is the MOST efficient method to find the answer?
Label
Value
Formula
Function
Adding two cells
SUM(A1:A9)
ADD(A1:A9)
SUMIF(A1:A9)
NONE OF THE ABOVE
