Multiple Choice
Choose a(n) ____ function if the problem requires you to make a decision and then generate different values depending on whether the logical test results in a TRUE or FALSE value.
A) IF
B) AND
C) OR
D) NOT
Correct Answer:

Verified
Correct Answer:
Verified
Q20: Excel interprets the formula =Goodbye>Hello, with no
Q21: The result of the formula =100>MAX(5,10,20) is
Q22: MATCHING<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg" alt="MATCHING
Q23: The AND function evaluates a list of
Q24: An IF function is a Boolean logical
Q26: The OR function returns a value of
Q27: The Conditional Formatting Rules Manager dialog box
Q28: The formula =OR(25<24,MIN(1,10)<2,3<=2+1) returns a _ value.<br>A)
Q29: In the formula =(1+2)/3<>10, Excel evaluates _
Q30: MATCHING<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg" alt="MATCHING