Which of the following is an example of a conditional aggregate function? A)=IF(AND(C7B3, D8B3, D8B3),"PAY","NO PAY") D)=IF((SUM(A1:A7)7),"PAY","NO PAY")

Question

Which of the following is an example of a conditional aggregate function? A)=IF(AND(C7>B3, D8<=5),"PAY","NO PAY") B)=IF(OR(C7>B3, D8<=5),"PAY","NO PAY") C)=IF(NOT(C7>B3),"PAY","NO PAY") D)=IF((SUM(A1:A7)>7),"PAY","NO PAY")

Quizplus · Accepted Answer

The IF function in option D checks if the sum of values in A1 to A7 is greater than 7, and returns "PAY" if true or "NO PAY" if false. This is an example of a conditional aggregate function as it aggregates (sums) values based on a condition. Options A, B, and C are also examples of the IF function, but they do not involve any aggregation of data.

Which of the Following Is an Example of a Conditional