Exam 4: Applying Logic in Decision Making

NOT(H2=2) returns the value FALSE assuming that cell H2 contains any value other than 2. ____________________

The financial stress risk class is a rating from ____, indicating the risk of a company in financial distress, where 1 represents businesses with the lowest probability of risk.

The result of the formula =C1<=D1 where cell C1 contains the label "AA" and cell D1 contains the label "BB" is ____.

logical_test is the ____________________ argument of the IF function.

To apply an icon set and modify criteria rules, highlight the cell(s) to be formatted and then click the Conditional Formatting button to open the Conditional Formatting drop-down menu. ____________________

In a decision tree, if there is one action to take if the test is TRUE and another action to take if it is FALSE, these actions are presented in ____.

The NOT function essentially changes the value ____.

Briefly describe five of the eight Highlight Cells Rules submenu options that are found on the Conditional Formatting drop-down menu. The options are Greater Than, Less Than, Between, Equal To, Text that Contains, A Date Occurring, Duplicate Values, and More Rules.

The formula ="Goodbye">"Hello" returns the value ____________________ because Goodbye comes alphabetically before Hello.

In the construct =AND(NOT(K3),NOT(L3),NOT(M3)), you are listing ____.