Excel Functions Quiz

What Excel function is used to search for a value in a table and return a corresponding value?

• MATCH

• INDEX

• VLOOKUP

• HLOOKUP

What happens when you press Enter after typing an Excel formula?

• The formula is evaluated and returns an error if it's incorrect

• The formula is evaluated and returns an error if it's correct

• The formula is evaluated and returns its result without error checking

• The formula is ignored and no result is returned

What is the default file extension for an Excel workbook?

• .docx

• .pptx

• .xlsx

• .txt

In Excel, what does the VLOOKUP function do?

• Looks up values horizontally across a row

• Looks up values vertically in a column

• Summarizes data in a table

• Sorts data in ascending order

What does the conditional formatting rule "Format only cells that contain" allow you to do?

• Format cells based on their content

• Format entire rows based on a cell's content

• Format entire columns based on a cell's content

• Format only blank cells

Which function would you use to count the number of cells in a range that meet a specific condition?

• COUNT

• COUNTA

• COUNTIF

• COUNTBLANK

How can you modify the COUNT function to count only cells that contain numbers greater or equals to 50 in the range A1?

• =COUNT(A1:A10, "=>50")

• =COUNTIF(A1:A10, "=>50")

• =COUNTIF(A1:A10, >50)

• =COUNTIF(A1:A10, ">50")

What does the formula =COUNTIF(A1:A10, "*") do?

• Counts all numeric cells in the range.

• Counts all text cells in the range.

• Counts all non-blank cells in the range.

• Counts all cells with errors in the range.

4. What is the result based on  =COUNTIF(C3:C24,"*Hotel*") and the table from below?

• 2

• 3

• 5

• 7

What is the formula for counting the numbers between 10 to 20 between cell E1 to E24?

• =COUNTIF(E1:E24,">10") - COUNTIF(E1:E24,">20")

• =COUNTIF(E1:E24,"10") - COUNTIF(E1:E24,">20")

• =COUNTIF(E1:E24,">10") - COUNTIF(E1:E24," 20")

• =COUNTIF(E1:E24,"10") - COUNTIF(E1:E24," 20")