Excel Functions Quiz

You have a list of full names in column A and need to separate first names and last names into separate columns. Which function(s) would be most useful?

• CONCATENATE

• TEXTSPLIT

• VLOOKUP

• COUNTIF

If you want to merge first and last names into a single column but use a space between them, which function would be best?

• CONCATENATE

• TEXTJOIN

• SUMIF

• INDEX & MATCH

You need to count how many times 'Pending' appears in a list of order statuses. Which function should you use?

• COUNTIF

• VLOOKUP

• IF

• CONCATENATE

If you have a list of sales transactions and want to sum only the sales from a specific region, which function would be best?

• SUMIF

• TEXTJOIN

• TEXTSPLIT

• MID

You need to look up an employee’s department based on their ID number from a separate table. Which function would be most useful?

• INDEX & MATCH

• VLOOKUP

• COUNTIF

• Both a and b

You have a column of product codes where the first three characters represent the product category. How can you extract just the category code?

• LEFT

• RIGHT

• MID

• Both a and c

If you want to return the last four digits of a phone number from a full phone number column, which function would you use?

• MID

• RIGHT

• CONCATENATE

• COUNTIF

You need to determine if a student has passed or failed based on their score, displaying 'Pass' if the score is 50 or higher and 'Fail' if it’s below. Which function should you use?

• VLOOKUP

• IF

• CONCATENATE

• TEXTJOIN

How can you dynamically combine multiple text values from different cells with a delimiter of your choice?

• TEXTJOIN

• CONCATENATE

• COUNTIF

• SUMIF

If you want to check whether an employee is in a list of active employees and return 'Yes' or 'No' accordingly, which function(s) would help?

• IF + COUNTIF

• SUMIF

• CONCATENATE

• TEXTSPLIT