Exam 4: Applying Logic in Decision Making

Dates are stored as ____.

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.

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

The ____________________ of a company is based on the assets and liabilities listed on its balance sheet.

In the formula =ROUND(AVERAGE(B1:B10),0), the function ____ is considered to be nested.

The formula NOT(7<10) returns the value ____________________.

To prove that both of these statements are TRUE-1) Either Rule #2 or Rule #3 is TRUE or both are TRUE, and 2) Rule #1 is FALSE-the correct formula is ____.

Use the logical construct of OR(A1) to change a single TRUE to FALSE or a single FALSE to TRUE.

The > symbol represents the ____________________ relational operator.

Instead of "Call," Nathan has decided to list the due date for those customers who have a FALSE value in column C. Customers with a TRUE value in column C should still generate a "Don't Call" value. His formula now looks like ____.

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

If Nathan entered the dates shown in column B directly into a formula, Excel would interpret the entry as a(n) ____.

=OR(I3>90,I4>90,I5>90,I6>90) returns a TRUE value if the values in cells I3, I4, I5, and I6 all contain values of 90 or less. ____________________

In a decision tree, a logical test is represented by a(n) ____ shape.

The NOT function essentially changes the value ____.

In the formula =B2=C2, the second equal sign is interpreted as ____.

You can change the formatting of a cell quite easily using the formatting buttons on the ____ tab.

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. ____________________

The formula =NOT(K3:K21) will result in an answer of ____ if all cells in the range are TRUE.

The Highlight Cells Rules submenu options called Equal To identify either duplicate values with a specific format or unique values. ____________________