Question 1

In the formula =(1+2)/3<>10, the numbers 1 and 2 are added after they are divided by 3.
____________________

Accepted Answer

before

Question 2

Dun & Bradstreet's credit rating includes a composite credit appraisal score that ranges from ____.
A) 1 to 4
B) 1 to 10
C) 1 to 100
D) A to Z

Accepted Answer

Dun & Bradstreet's composite credit appraisal score ranges from 1 to 4, with 1 indicating the highest level of creditworthiness and 4 indicating a higher risk of business failure.

Question 3

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

Accepted Answer

argument

Question 4

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

Accepted Answer

This is the definition of an AND function. It only returns TRUE if all the arguments are TRUE.

Question 5

Dun & Bradstreet's credit rating includes a classification ranging from ____ indicating the net worth category of the company.
A) 5A to HH
B) 1A to ZZ
C) 2B to 2Z
D) 1 to 100

Accepted Answer

Dun & Bradstreet's credit rating system includes a classification that ranges from 5A to HH, indicating the net worth category of the company.

Question 6

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

Accepted Answer

The NOT function is used to reverse the value of its argument, turning TRUE to FALSE and vice versa.

Question 7

The result of the formula =100>MAX(5,10,20) is FALSE. ____________________

Accepted Answer

tRUE
true
true

Question 8

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

Accepted Answer

The NOT function returns the opposite value of the logical argument. If the argument is FALSE, the NOT function returns TRUE. If the argument is TRUE, the NOT function returns FALSE.

Question 9

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

Accepted Answer

Duplicate Values
Duplicate values
duplicate values

Question 10

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

Accepted Answer

This is correct. To apply an icon set and modify criteria rules, you need to select the cell(s) and then click on the Conditional Formatting button to open the drop-down menu.

Question 11

The result of the formula =B3>=C3 where cell B3 contains the date 1/1/2010 and cell C3 contains the date 12/31/2009 is ____.
A) TRUE
B) FALSE
C) ERROR
D) EQUAL

Accepted Answer

The formula compares if the date in cell B3 is greater than or equal to the date in cell C3. Since 1/1/2010 is after 12/31/2009, the formula will evaluate to TRUE.

Question 12

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

Accepted Answer

The function uses the relational operator "=" to compare the value in cell C2 with the text label "Hello". If they match, the function returns TRUE, otherwise it returns FALSE.

Question 13

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

Accepted Answer

tRUE
true
true

Question 14

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

Accepted Answer

This is because the rules are checked in the order in which they appear in the rules list, and once a rule is matched, no further rules are evaluated for that specific cell.

Question 15

Some examples of relational logical functions are AND, OR, and NOT.
____________________

Accepted Answer

Boolean
boolean

Question 16

The Conditional Formatting tools allow you to insert colored bars (called info bars) in addition to standard formatting. ____________________

Accepted Answer

data bars

Question 17

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.
A) 1 to 5
B) 1 to 4
C) 1 to 9
D) 1 to 99

Accepted Answer

The answer of The financial stress risk class is a...

Question 18

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

Accepted Answer

1
one

Question 19

You can use the ____ logical functions AND, OR, and NOT.
A) Boolean
B) Bradstreet
C) relational
D) simple

Accepted Answer

The terms "AND", "OR", and "NOT" are associated with Boolean logic, which deals with true and false values. Therefore, the best choice would be A) Boolean.

Question 20

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

Accepted Answer

fALSE
false
false

Quiz 4: Applying Logic in Decision Making

In the formula =(1+2)/3<>10, the numbers 1 and 2 are added after they are divided by 3. ____________________

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

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

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

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

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

The result of the formula =100>MAX(5,10,20) is FALSE. ____________________

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

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

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

The result of the formula =B3>=C3 where cell B3 contains the date 1/1/2010 and cell C3 contains the date 12/31/2009 is ____.

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

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

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

Some examples of relational logical functions are AND, OR, and NOT. ____________________

The Conditional Formatting tools allow you to insert colored bars (called info bars) in addition to standard formatting. ____________________

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.

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

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

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