Question 1

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

Accepted Answer

A)  first 
B)  second 
C)  third 
D)  fourth 
A)  first 
B)  second 
C)  third 
D)  fourth A

Question 2

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

A) True 
 B)False  True

Question 3

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

Accepted Answer

stress

Question 4

In the construct =AND(NOT(K3),NOT(L3),NOT(M3)), you are listing ____.

Accepted Answer

A)  each cell separately 
B)  cell ranges 
C)  cells as absolute references 
D)  cells as mixed references 
A)  each cell separately 
B)  cell ranges 
C)  cells as absolute references 
D)  cells as mixed references

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

When laying out a complex IF function, a good way to proceed is to take the information and represent this process schematically in a bar chart.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

In the formula =(1+2)/310, Excel evaluates ____ first.

Accepted Answer

A)  1+2 
B)  2/3 
C)  310 
D)  3/3 
A)  1+2 
B)  2/3 
C)  310 
D)  3/3

Question 9

The  symbol is the relational operator that means ____________________.

Accepted Answer

The answer of The  symbol is the relational operator...

Question 10

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

Accepted Answer

•The first argument of the IF function i

Question 11

Choose a(n) ____ function if the problem requires you to make a decision and then generate different values depending on whether the logical test results in a TRUE or FALSE value.

Accepted Answer

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

Question 12

Case 4-1
   
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.
-If any one value in column C, D, or E is FALSE, then that customer is going to be put on the Accounts Receivable Watch List. Chloe wants to return a value of TRUE for customers to be put on the watch list. She will write the formula for Aster Construction first, and then copy it to the other rows. The logical construct Chloe would use is ____.

Accepted Answer

A)  OR(NOT(C5),NOT(D5),NOT(E5)) 
B)  OR(C5:E5) 
C)  AND(C5:E5) 
D)  AND(NOT(C5),NOT(D5),NOT(E5)) 
A)  OR(NOT(C5),NOT(D5),NOT(E5)) 
B)  OR(C5:E5) 
C)  AND(C5:E5) 
D)  AND(NOT(C5),NOT(D5),NOT(E5))

Question 13

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 
A)  TRUE 
B)  FALSE 
C)  ERROR 
D)  EQUAL

Question 14

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

Accepted Answer

A)  parent-child 
B)  nested 
C)  connected 
D)  linked 
A)  parent-child 
B)  nested 
C)  connected 
D)  linked

Question 15

Relational operators can be used to evaluate dates.

Accepted Answer

A) True 
 B)False

Question 16

Relational expressions ____.

Accepted Answer

A)  are not case sensitive 
B)  are case sensitive 
C)  only read uppercase letters 
D)  only read lowercase letters 
A)  are not case sensitive 
B)  are case sensitive 
C)  only read uppercase letters 
D)  only read lowercase letters

Question 17

The OR function returns a value of FALSE if ____.

Accepted Answer

A)  all arguments in the function are TRUE 
B)  one or more of the arguments in the function are TRUE 
C)  all arguments in the function are FALSE 
D)  one or more of the arguments in the function are TRUE. 
A)  all arguments in the function are TRUE 
B)  one or more of the arguments in the function are TRUE 
C)  all arguments in the function are FALSE 
D)  one or more of the arguments in the function are TRUE.

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

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 20

In a nested IF function, the second argument (value_if_true) and/or the third argument (value_if_false) cannot contain another IF function.

Accepted Answer

A) True 
 B)False

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

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 Dun & Bradstreet financial ____________________ risk class is a rating from 1 to 5 indicating the risk of a company in financial distress.

In the construct =AND(NOT(K3),NOT(L3),NOT(M3)), you are listing ____.

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

When laying out a complex IF function, a good way to proceed is to take the information and represent this process schematically in a bar chart.

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

In the formula =(1+2)/3<>10, Excel evaluates ____ first.

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

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

Choose a(n) ____ function if the problem requires you to make a decision and then generate different values depending on whether the logical test results in a TRUE or FALSE value.

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

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

Relational operators can be used to evaluate dates.

Relational expressions ____.

The OR function returns a value of FALSE if ____.

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

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

In a nested IF function, the second argument (value_if_true) and/or the third argument (value_if_false) cannot contain another IF function.

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

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

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 Dun & Bradstreet financial ____________________ risk class is a rating from 1 to 5 indicating the risk of a company in financial distress.

In the construct =AND(NOT(K3),NOT(L3),NOT(M3)), you are listing ____.

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

When laying out a complex IF function, a good way to proceed is to take the information and represent this process schematically in a bar chart.

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

In the formula =(1+2)/3<>10, Excel evaluates ____ first.

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

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

Choose a(n) ____ function if the problem requires you to make a decision and then generate different values depending on whether the logical test results in a TRUE or FALSE value.

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

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

Relational operators can be used to evaluate dates.

Relational expressions ____.

The OR function returns a value of FALSE if ____.

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

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

In a nested IF function, the second argument (value_if_true) and/or the third argument (value_if_false) cannot contain another IF function.

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