Excel Functions Quiz

What does the SUM function do in Excel?

• Finds the maximum value in a set of values.

• Calculates the average of a set of values.

• Counts the number of cells that contain numbers.

• Adds a series of numbers.

Which function calculates the average of a range based on a single condition?

• AVERAGEIF

• MAX

• SUMIF

• COUNTIF

What does the IF function allow you to do?

• Make decisions based on conditions.

• Count cells that meet criteria.

• Sum values based on criteria.

• Extract specific portions of text.

Which function is used to find the maximum value in a set of values?

• SUM

• MIN

• AVERAGE

• MAX

What does the VLOOKUP function do?

• Calculates the present value of an investment.

• Searches for a value in the first column of a table.

• Counts the number of cells that meet multiple criteria.

• Extracts specific portions of text from a string.

Which function would you use to calculate the future value of an investment?

• PV

• FV

• NPV

• IRR

What is the purpose of the COUNTIF function?

• To calculate the average of a range.

• To count the number of cells that meet a single criterion.

• To find the minimum value in a set.

• To sum values based on criteria.

Which function can be nested for more complex conditions?

• AVERAGE

• COUNT

• IF

• SUM

What does the LEFT function do?

• Returns characters from the end of a text string.

• Returns characters from the start of a text string.

• Counts the number of cells that contain numbers.

• Calculates the average of a range.

Which function is used to calculate the internal rate of return?

• NPV

• FV

• IRR

• PMT