Exam 4: Applying Logic in Decision Making

To remove all of the conditional formatting on a worksheet, select the Conditional Formatting button, select ____ in the drop-down menu, and then click Clear Rules from Entire Sheet.

The syntax of the NOT function evaluates ____.

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

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

The > symbol represents the ____________________ relational operator.

The term ____ means that a function contains additional formulas and/or functions as one or more of its arguments.

The ____________________ function evaluates a list of logical arguments to determine if at least one argument is TRUE.

When using an IF function, if customers with overdue payments fall into only one category (90 days, 60 days, or 30 days), ____.

In conditional formatting, the last rule created will appear ____ the list, unless you change the order of the rules.

NOT(FALSE) returns the value ____.

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

The term ____________________ means that a function contains additional formulas and/or functions as one or more of its arguments.

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

The <> symbol is the relational operator that means ____________________.

Nathan is in charge of collections, and is putting together a list of customers to call. Please refer to the figure above as you answer the questions below. -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?

The ____________________ function evaluates only one logical argument to determine if it is FALSE.

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

Nathan is in charge of collections, and is putting together a list of customers to call. Please refer to the figure above as you answer the questions below. -Nathan wants to develop a list of customers with past due balances. He will write the formula for one customer and copy it to the remaining rows. A correct formula would be ____.

Note that an only construct always has a positive condition to be evaluated and a(n) ____________________ condition to be evaluated.

If logical_test results in a(n) ____________________ value, Excel evaluates the value_if_true argument.