Excel Functions Quiz

What does the VLOOKUP function do?

• Counts the number of cells that meet a condition

• Creates a chart based on selected data

• Searches for a value in a table and returns a corresponding value

• Calculates the sum of a range of cells

What is the syntax for the VLOOKUP function?

• =VLOOKUP(lookup_value, col_index_num, table_array, [range_lookup])

• =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• =VLOOKUP(table_array, lookup_value, col_index_num, [range_lookup])

• =VLOOKUP(col_index_num, lookup_value, table_array, [range_lookup])

Which function is used to search for a value horizontally?

• XLOOKUP

• VLOOKUP

• LOOKUP

• HLOOKUP

What is the purpose of the XLOOKUP function?

• To search a range and return the first match found

• To create a pie chart

• To sum a range of values

• To count the number of cells

Which of the following is NOT a common type of chart in Excel?

• Matrix Chart

• Pie Chart

• Bubble Chart

• Histogram

What does the IF function do in Excel?

• Sums a range of values

• Creates a chart based on data

• Counts the number of cells in a range

• Performs logical tests and returns values based on conditions

What is the syntax for the COUNTIF function?

• =COUNTIF(value1, value2)

• =COUNTIF(range, value)

• =COUNTIF(range, criteria)

• =COUNTIF(criteria, range)

What does the SUMPRODUCT function do?

• Multiplies arrays together and sums the results

• Creates a chart based on data

• Adds up numbers in a range

• Counts the number of cells that meet a condition

Which of the following is a valid syntax for the SUM function?

• =SUMIF(range, criteria)

• =SUM(number1, [number2], ...)

• =SUM(value1, value2)

• =SUM(range)

Which function would you use to find the total sales for a specific condition?

• MAX

• SUMIF

• AVERAGE

• COUNT