Excel Functions Quiz

What does the VLOOKUP function do in Excel?

• Finds text within text

• Searches for a value by row and returns corresponding data

• Adds values across a column

• Filters the data

Which function should you use to add all salaries of employees in the 'Sales' department?

• COUNTIF

• SUMIF

• HLOOKUP

• INDEX

What will the formula =IF(A1>10000, 'Eligible', 'Not Eligible') return when A1 = 9500?

• TRUE

• Not Eligible

• Eligible

• FALSE

Which of the following functions checks whether a cell contains a number?

• ISNA

• ISBLANK

• ISNUMBER

• ISTEXT

What is the correct syntax for the SUMIFS function?

• SUMIFS(criteria_range, sum_range)

• SUMIFS(sum_range, criteria_range, criteria)

• SUMIFS(criteria, range)

• SUMIFS(sum_range)

What does HLOOKUP search through?

• First column

• First row

• First cell

• Last column

Which function is useful for handling division-by-zero errors in Excel?

• IF

• INDEX

• IFERROR

• COUNTIFS

What do AND and OR functions return?

• A cell reference

• A formula result

• TRUE or FALSE

• An error message

In the formula =INDEX(C2:C100, MATCH('E123', B2:B100, 0)), what does MATCH do?

• Adds two values

• Looks up a horizontal table

• Finds position of 'E123'

• Replaces text

What is the primary use of the Goal Seek feature in Excel's What-If Analysis?

• To create charts for multiple datasets

• To sort employee data by salary

• To find the input needed to achieve a desired output

• To validate data entry rules