Solved

Which of the Following Is an Example of a Conditional

Question 36

Multiple Choice

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")

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q31: All of the following statements are TRUE

Q32: Quotes,shown as a(n)_ symbol,not the curly double

Q33: A(n)_ aggregate function incorporates calculation and a

Q34: The correct syntax for the COUNTIF function

Q35: The AVERAGEIFS function expands on the AVERAGEIF

Q37: A nested IF requires one or more

Q38: The function =IF(SUM(Trans_Qty)>E20,"Goal Met","Under Goal")is an example

Q39: All of the following statements are TRUE

Q40: Data that is manually calculated and typed

Q41: All of the following statements are TRUE