Question 1

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

Accepted Answer

A)  can save a considerable amount of work 
B)  will generate more work 
C)  will have no bearing on the amount of work 
D)  is not recommended

Question 2

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

Accepted Answer

A)  NOT(logical1) 
B)  NOT(logical1,logical2,...) 
C)  NOT(reference1) 
D)  NOT(value1,value2,...)

Question 3

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

Accepted Answer

A)  Data Bars 
B)  Color Scales 
C)  Icon Sets 
D)  all of the above

Question 4

TRUE and FALSE are referred to as Boolean logical values.

Accepted Answer

A) True 
 B)False

Question 5

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

A) True 
 B)False

Question 6

Relational expressions begin with a(n) ____.

Accepted Answer

A)  equal sign 
B)  quotation mark 
C)  question mark 
D)  parenthesis

Question 7

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.

Accepted Answer

The answer of A(n) ____________________ function is a Boolean logical...

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) #1 
B) #2 
C) #3 
D) #4 
E) #5
F)#6
G)#7
H)#8

Question 10

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

Accepted Answer

A)  AND(logical1,logical2,...) 
B)  AND(value1,value2,...) 
C)  AND(ref1,ref2,ref3,...) 
D)  AND(if then,false then)

Question 11

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

Accepted Answer

A)  =IF(H3,"credit approved","credit denied") 
B)  =IF(H3,"credit denied","credit denied") 
C)  =IF("credit denied","credit denied",H3) 
D)  =IF H3 ("credit denied","credit denied")

Question 12

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

Accepted Answer

A)  relative 
B)  absolute 
C)  complex 
D)  simple

Question 13

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

Accepted Answer

A)  5A to HH 
B)  1A to ZZ 
C)  2B to 2Z 
D)  1 to 100

Question 14

You can use dates in ____.

Accepted Answer

A)  relational expressions 
B)  arithmetic expressions 
C)  both a and b 
D)  neither a nor b

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

Relational operators can be used to evaluate dates.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A)  TRUE 
B)  FALSE 
C)  ERROR 
D)  EQUAL

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A)  =SUM(B5:B9)150 
D)  =AND(B5:B9)<=150

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.