Question 1

The result of the formula =OR(I3:I21>90), where cell I5 is 92, is ____.

Accepted Answer

A)  FALSE 
B)  TRUE 
C)  ERROR 
D)  both a and b 
A)  FALSE 
B)  TRUE 
C)  ERROR 
D)  both a and b B

Question 2

Assuming that cell D4 contains the date 12/31/2013 and cell D1 contains the date 1/1/2014, you could write the formula =D4>=D1, and the result would be ____.

Accepted Answer

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

Question 3

To return a blank cell in an IF function, you can include ____.

Accepted Answer

A)  (" ") 
B)  (? ?) 
C)  () 
D)  (/ /) 
A)  (" ") 
B)  (? ?) 
C)  () 
D)  (/ /) A

Question 4

Up to the maximum of ____ levels of nesting can be used in a formula.

Accepted Answer

A)  24 
B)  48 
C)  60 
D)  64 
A)  24 
B)  48 
C)  60 
D)  64

Question 5

The Dun & Bradstreet ® financial ____________________ risk class is a rating from 1 to 5 indicating the risk of a company in financial distress.

Accepted Answer

The answer of The Dun & Bradstreet ® financial ____________________...

Question 6

You can use relational operators and ____________________ functions to evaluate sets of conditions resulting in TRUE or FALSE values.

Accepted Answer

The answer of You can use relational operators and ____________________...

Question 7

The Excel Conditional Formatting tools allow you to insert small graphics called ____________________.

Accepted Answer

The answer of The Excel Conditional Formatting tools allow you...

Question 8

____ is a kind of shorthand formula showing the structure of the formula without the syntactical details.

Accepted Answer

A)  Pseudocode 
B)  Trial code 
C)  Shorthand code 
D)  Label code 
A)  Pseudocode 
B)  Trial code 
C)  Shorthand code 
D)  Label code

Question 9

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

Accepted Answer

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

Question 10

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

Accepted Answer

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

Question 11

The first argument of the IF function is the logical_test, and can consist of ____.

Accepted Answer

A)  the value TRUE or FALSE 
B)  a reference to a cell containing a TRUE or FALSE value 
C)  a relational expression resulting in a single TRUE or FALSE value 
D)  all of the above 
A)  the value TRUE or FALSE 
B)  a reference to a cell containing a TRUE or FALSE value 
C)  a relational expression resulting in a single TRUE or FALSE value 
D)  all of the above

Question 12

After establishing both the relational operator and the condition, you need to specify the formatting to be applied if the condition is met, including ____.

Accepted Answer

A)  font style and borders 
B)  font type and font size 
C)  both a and b 
D)  neither a nor b 
A)  font style and borders 
B)  font type and font size 
C)  both a and b 
D)  neither a nor b

Question 13

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

Accepted Answer

A)  the beginning of a formula 
B)  a relational operator 
C)  an absolute operator 
D)  a relative operator 
A)  the beginning of a formula 
B)  a relational operator 
C)  an absolute operator 
D)  a relative operator

Question 14

You can "flip" the value of a rule with a(n) ____________________ function to obtain a TRUE value if the rule had a FALSE value.

Accepted Answer

The answer of You can "flip" the value of a...

Question 15

Identify the letter of the choice that best matches the relational operator used in the formula.
-Equal to

Accepted Answer

A) =3+5=8 B) =100>MAX(5,10,20) C) =B310 A) =3+5=8 B) =100>MAX(5,10,20) C) =B310

Question 16

By nesting levels of ____ functions, multiple sets of criteria can be sequentially analyzed until a final value is returned.

Accepted Answer

A)  IF 
B)  AND 
C)  OR 
D)  NOT 
A)  IF 
B)  AND 
C)  OR 
D)  NOT

Question 17

When you encounter the keywords either and or (meaning if either condition is met) followed by a specified outcome, the situation indicates the need for a(n) ____ function.

Accepted Answer

A)  AND 
B)  OR 
C)  NOT 
D)  IF 
A)  AND 
B)  OR 
C)  NOT 
D)  IF

Question 18

The ____________________ function evaluates a list of logical arguments to determine if all of the arguments are TRUE.

Accepted Answer

The answer of The ____________________ function evaluates a list of...

Question 19

List three types of conditional formatting and the steps you would take to apply them to your worksheet.

Accepted Answer

To apply Data Bars, Color Scales, or Ico

Question 20

Excel interprets the formula =Goodbye>Hello, with no quotation marks, by ____.

Accepted Answer

A)  looking for a range named Goodbye and a range named Hello 
B)  looking for a range named Hello and a range named Goodbye 
C)  returning the value TRUE 
D)  returning the value FALSE 
A)  looking for a range named Goodbye and a range named Hello 
B)  looking for a range named Hello and a range named Goodbye 
C)  returning the value TRUE 
D)  returning the value FALSE

The result of the formula =OR(I3:I21>90), where cell I5 is 92, is ____.

Assuming that cell D4 contains the date 12/31/2013 and cell D1 contains the date 1/1/2014, you could write the formula =D4>=D1, and the result would be ____.

To return a blank cell in an IF function, you can include ____.

Up to the maximum of ____ levels of nesting can be used in a formula.

The Dun & Bradstreet ® financial ____________________ risk class is a rating from 1 to 5 indicating the risk of a company in financial distress.

You can use relational operators and ____________________ functions to evaluate sets of conditions resulting in TRUE or FALSE values.

The Excel Conditional Formatting tools allow you to insert small graphics called ____________________.

____ is a kind of shorthand formula showing the structure of the formula without the syntactical details.

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

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

The first argument of the IF function is the logical_test, and can consist of ____.

After establishing both the relational operator and the condition, you need to specify the formatting to be applied if the condition is met, including ____.

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

You can "flip" the value of a rule with a(n) ____________________ function to obtain a TRUE value if the rule had a FALSE value.

Identify the letter of the choice that best matches the relational operator used in the formula. -Equal to

By nesting levels of ____ functions, multiple sets of criteria can be sequentially analyzed until a final value is returned.

When you encounter the keywords either and or (meaning if either condition is met) followed by a specified outcome, the situation indicates the need for a(n) ____ function.

The ____________________ function evaluates a list of logical arguments to determine if all of the arguments are TRUE.

List three types of conditional formatting and the steps you would take to apply them to your worksheet.

Excel interprets the formula =Goodbye>Hello, with no quotation marks, by ____.

Applying Fundamental Excel Skills and Tools in Problem Solving

Solving Problems with Statistical Analysis Tools

Determining Effective Data Display with Charts

Retrieving Data for Computation, Analysis, and Reference

Evaluating the Financial Impact of Loans and Investments

Organizing Data for Effective Analysis

Using Data Tables and Excel Scenarios for What-If Analysis

Enhancing Decision Making with Solver

Troubleshooting Workbooks and Automating Excel Applications

Filters

Exam 4: Applying Logic in Decision Making

The result of the formula =OR(I3:I21>90), where cell I5 is 92, is ____.

Assuming that cell D4 contains the date 12/31/2013 and cell D1 contains the date 1/1/2014, you could write the formula =D4>=D1, and the result would be ____.

To return a blank cell in an IF function, you can include ____.

Up to the maximum of ____ levels of nesting can be used in a formula.

The Dun & Bradstreet ® financial ____________________ risk class is a rating from 1 to 5 indicating the risk of a company in financial distress.

You can use relational operators and ____________________ functions to evaluate sets of conditions resulting in TRUE or FALSE values.

The Excel Conditional Formatting tools allow you to insert small graphics called ____________________.

____ is a kind of shorthand formula showing the structure of the formula without the syntactical details.

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

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

The first argument of the IF function is the logical_test, and can consist of ____.

After establishing both the relational operator and the condition, you need to specify the formatting to be applied if the condition is met, including ____.

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

You can "flip" the value of a rule with a(n) ____________________ function to obtain a TRUE value if the rule had a FALSE value.

Identify the letter of the choice that best matches the relational operator used in the formula. -Equal to

By nesting levels of ____ functions, multiple sets of criteria can be sequentially analyzed until a final value is returned.

When you encounter the keywords either and or (meaning if either condition is met) followed by a specified outcome, the situation indicates the need for a(n) ____ function.

The ____________________ function evaluates a list of logical arguments to determine if all of the arguments are TRUE.

List three types of conditional formatting and the steps you would take to apply them to your worksheet.

Excel interprets the formula =Goodbye>Hello, with no quotation marks, by ____.

Applying Fundamental Excel Skills and Tools in Problem Solving

Solving Problems with Statistical Analysis Tools

Determining Effective Data Display with Charts

Retrieving Data for Computation, Analysis, and Reference

Evaluating the Financial Impact of Loans and Investments

Organizing Data for Effective Analysis

Using Data Tables and Excel Scenarios for What-If Analysis

Enhancing Decision Making with Solver

Troubleshooting Workbooks and Automating Excel Applications

Filters