Exam 4: Applying Logic in Decision Making

The first argument of the IF function is the logical_test, and can consist of ____.

When using the none of construct, if Rule #1, Rule #2, and Rule #3 all result in the value FALSE for a customer, then the statement "None of the rules are true" is ____.

The ____________________ of the NOT function is as follows: NOT(logical1).

List three types of conditional formatting and the steps you would take to apply them to your worksheet.

Chloe also intends to send out a letter congratulating those customers who have the value TRUE in all three columns of C, D, and E. She now wants to write a formula to generate a TRUE value if a customer matches this criteria. The logical construct would be ____.

Nathan wants to fill in the words "Call" and "Don't Call" on the spreadsheet based on the value in column C. He will list "Call" if the value is FALSE and "Don't Call" if the value is TRUE. What is the formula Nathan could write?

With conditional formatting, if both types of formatting cannot be applied to the cell simultaneously, the rule that appears first in the rules list overrides other rules for that specific cell. ____________________

For a(n) AND function to be TRUE, all of its arguments must be TRUE. ____________________

Use the ____ button to launch the New Formatting Rule dialog box.

By nesting levels of ____ functions, multiple sets of criteria can be sequentially analyzed until a final value is returned.