NEW
Font size
WorksheetsExcel recap
Total questions: 10
Worksheet time: 5mins
What is the purpose of using Vlookup in Excel?
To search for a value in a table and return a corresponding value from another column.
To insert a new row in the spreadsheet
To change the font style of a cell
To calculate the sum of a range of cells
What are the four arguments of the Vlookup function?
lookup_value, table_array, row_index_num, and range_lookup
search_value, data_array, col_index_num, and exact_match
value_to_find, array_to_search, index_num, and approximate_match
lookup_value, table_array, col_index_num, and range_lookup
What are some common errors that occur when using Vlookup and how can they be resolved?
Double-checking the table array, using relative cell references, and ensuring the exact match option is selected.
Forgetting to input the lookup value
Using absolute cell references
Not specifying the exact match option
Which of the following is the correct syntax for the IF function?
=IF(condition, value_if_true, value_if_false)
=IF(value_if_true, condition, value_if_false)
=IF(value_if_false, condition, value_if_true)
=IF(value_if_true, value_if_false, condition)
If the formula =IF(A1>10, "Yes", "No") is used in cell B1 and the value in A1 is 8, what will B1 display?
Yes
No
Error
True
What is the output of =IF(A1>10, "Above 10", IF(A1>5, "Between 6 and 10", "5 or below")) if A1 contains the value 6?
Above 10
Between 6 and 10
5 or below
Error
Which of the following is the correct syntax for the COUNTIF Function?
=COUNTIF(range, criteria )
=COUNT(RANGE)
=COUNTA(RANGE)
=COUNTBLANK(RANGE)
If you want to count cells with any type of data (and not just numbers), simply replace COUNT by________ .
countblank
counta
countb
max
What symbol is used in order to make a cell reference an ABSOLUTE CELL REFERENCE?
%
*
?
$
