Exam 4: Applying Logic in Decision Making

In cases where you want to test criteria between a range of values, placing the logical tests in a specific order-either from highest to lowest or lowest to highest-____.

The syntax of the NOT function is as follows: ____.

One of the easiest ways to use conditional formatting is to apply preset formats such as ____.

TRUE and FALSE are referred to as Boolean logical values.

Each value in the AND function can consist of cell references or a range of cells and functions that reduce to a single TRUE or FALSE value. ____________________

Relational expressions begin with a(n) ____.

A(n) ____________________ function is a Boolean logical function that returns one value if a specified condition evaluates to TRUE, and another value if the specified condition evaluates to FALSE.

The function =C2="Hello" uses relational operators to evaluate text labels. ____________________

MATCHING Identify the letter of the choice that best matches the common logical construct. -OR(A1:A4)

The syntax of the AND function is as follows: ____.

To perform the task of displaying "credit approved" or "credit denied" based on the corresponding Boolean value in column H, you can write a formula in cell I3 containing an IF function, as follows: ____.

Unlike cell referencing within a worksheet, the default for conditional formatting is a(n) ____ cell reference.

Dun & Bradstreet's ® credit rating includes a classification ranging from ____ indicating the net worth category of the company.

You can use dates in ____.

Use the NOT function to change a TRUE value to FALSE or a FALSE value to TRUE. ____________________

Relational operators can be used to evaluate dates.

The result of the formula =B3<C3 where cell B3=5 and cell C3=4 is ____.

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

To test if neither L3 nor M3 is TRUE, you can use the none of construct.

Chloe is creating an Excel spreadsheet using a number of formulas to help make some business decisions regarding her company's customers. Please refer to the figure above as you answer the questions below. -Chloe also wants to know if total purchases ever fall below $150,000. The current value is $162,000. She writes the formula ____.