Excel Functions Quiz

What is an expression in Excel?

• A method for counting sales

• A type of equation that returns a value

What does nesting mean in Excel?

• Using a function as an argument within another function

• Refining the retail end of a business

What does the IF function do in Excel?

• Performs specific actions based on conditions

• Totals up sales figures in a long list

What is the format for an IF function in Excel?

• =IF(logical_test,value_if_true,value_if_false)

• =IF(value_if_true,logical_test,value_if_false)

What does the SUMIF function do in Excel?

• Adds certain data based on a condition

• Calculates the average score of students

What is the format for a SUMIF statement in Excel?

• =SUMIF(range, criteria, sum_range)

• =SUMIF(criteria, range, sum_range)

What does the COUNTIF function do in Excel?

• Adds certain data based on a condition

• Counts the number of items in a range based on a criteria

What is the format for a COUNTIF statement in Excel?

• =COUNTIF(range, criteria)

• =COUNTIF(criteria, sum_range)

What does the COUNTIFS function do in Excel?

• Calculates the average score of students

• Counts the number of items in a range based on multiple criteria

What is the format for a COUNTIFS statement in Excel?

• =COUNTIFS(criteria_range1, criteria1, criteria_range2, criteria2, ...)

• =COUNTIFS(criteria_range1, criteria_range2, criteria1, criteria2, ...)