Exam 4: Applying Logic in Decision Making

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

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

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

PAYDEX® provides a score from 1 to 100, with 100 representing the worst payment record. ____________________

Dun & Bradstreet's ® credit rating includes a composite credit appraisal score that ranges from ____.

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 result of the formula =(1+2)/3<>10 is ____________________.

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

Identify the letter of the choice that best matches the relational operator used in the formula. -Less than

If you entered the date 1/1/2014 directly into a formula, Excel interprets the entry as a ____.

=OR(FALSE,TRUE,TRUE) results in the final value of ____.

Excel provides ____ tools, which are tools you can use to identify a set of conditions and specify the formatting if those conditions are met.

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

One approach to determining if none of the credit rules is TRUE for a specific customer is to figure out if each rule results in a FALSE value.

Identify the letter of the choice that best matches the relational operator used in the formula. -Greater than

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. -The CEO of Chloe's company reviews the chart and hands her this formula: AND(C5,NOT(OR(C5:E5))). The formula will be entered for Aster Construction, and then copied to the remaining rows. Which companies, if any, will return a TRUE value as a result of this formula?

In the formula =IF(F9>0,G$2,IF(E9>0,G$3,IF(D9>0,G$4,0))), Excel will evaluate the first IF function ____.

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

You can use the ____ logical functions AND, OR, and NOT.

Briefly describe each of the arguments in an IF function: IF(logical_test,value_if_true,value_if_false).