Review for Conditional Functions

You have a range of data with some empty cells. You need to count the number of non-empty cells. Which function would you use?

• COUNTA

• SUMIF

• AVERAGEIF

• COUNTIF

What is the syntax for the COUNTIF function?

• =COUNTIF(range, criteria)

• =COUNTIF(criteria,range)

• =COUNTA(range, criteria)

• COUNTIF(range, criteria)

You want to calculate the average score for a particular category of data. Which function would you use?

• AVERAGEIF

• COUNTIF

• SUMIF

• MAX

What is the purpose of the AVERAGEIF function?

• To count the number of cells in a range that meet a certain condition

• To sum the values in a range that meet a certain condition

• To evaluate a logical test and return a value if the test is true, and another value if the test is false

• To calculate the average of a range of cells that meet a certain condition

What is the syntax for the AVERAGEIF function?

• =AVERAGEIF(search range,criteria, average range )

• AVERAGEIF(range, criteria)=AVERAGEIF(search range,criteria, average range )

• =AVARAGEIF(search range,criteria, average range )

• =AVERAGE(search range,criteria, average range )

Which function can be used to sum the values in a range that meet a certain condition?

• SUM

• SUMIF

• SUMA

• COUNTA

Suppose you have a list of students and their scores in different subjects. Which function can you use to count the number of students who passed a particular subject?

• COUNTA

• SUMIF

• AVERAGEIF

• COUNTIF

You want to calculate the average score of female students in a particular subject. Which function should you use?

• COUNTA

• COUNTIF

• SUMIF

• AVERAGEIF

You have a list of products sold and their prices. You want to calculate the total revenue generated by a particular product. Which function should you use?

• COUNTA

• SUMIF

• AVERAGEIF

• COUNTIF

What is the correct syntax for the SUMIF function when adding up the values in range B1:B10 that meet a certain condition in range A1:A10?

• =SUMIF(A1:A10, criteria, B1:B10)

• SUMIF(A1:A10, criteria, B1:B10)

• =SUMIF(A1:A10, B1:B10)

• =SUMIF(B1:B10, criteria, A1:A10)