Question 1

In conditional formatting, the last rule created will appear ____ the list, unless you change the order of the rules.

Accepted Answer

A)  last in 
B)  first in 
C)  in the middle of 
D)  below 
A)  last in 
B)  first in 
C)  in the middle of 
D)  below

Question 2

The syntax of the IF function is =IF(logical_test,value_if_true,value_if_false).

Accepted Answer

A) True 
 B)False

Question 3

The NOT function takes only one argument and essentially changes a single TRUE value to FALSE, or a single FALSE value to TRUE.

Accepted Answer

A) True 
 B)False

Question 4

You can flip the value of a rule from TRUE to FALSE by using the ____ function.

Accepted Answer

A)  NO 
B)  NOT 
C)  FLIP 
D)  OR 
A)  NO 
B)  NOT 
C)  FLIP 
D)  OR

Question 5

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

Accepted Answer

A) True 
 B)False

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

If you are using a none of construct and if one customer meets the criteria, the statement "none of the customers meet the criteria" is ____.

Accepted Answer

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

Question 8

The Excel Conditional Formatting tools allow you to insert multicolor gradients called ____________________.

Accepted Answer

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

Question 9

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

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 10

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 
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 11

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 12

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

Accepted Answer

A) True 
 B)False

Question 13

To help view certain areas of a worksheet, you can ____ panes in the worksheet so that you can focus more easily.

Accepted Answer

A)  freeze 
B)  stick 
C)  immobilize 
D)  delete 
A)  freeze 
B)  stick 
C)  immobilize 
D)  delete

Question 14

An AND function returns a value of TRUE 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 15

Relational expressions begin with a(n) ____.

Accepted Answer

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

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

In a decision tree, if there is one action to take if the test is TRUE and another action to take if it is FALSE, these actions are presented in ____.

Accepted Answer

A)  rectangles 
B)  circles 
C)  ovals 
D)  squares 
A)  rectangles 
B)  circles 
C)  ovals 
D)  squares

Question 18

Another way that Chloe could write the formula that would show if total purchases ever fell below $150,000 would be ____. The current value is $162,000.

Accepted Answer

A)  =B10150 
A)  =B10150

Question 19

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 
A)  5A to HH 
B)  1A to ZZ 
C)  2B to 2Z 
D)  1 to 100

Question 20

An IF function can be used to evaluate a logical test, such as determining if the 90-days past due balance is greater than 0, with only two resulting values: a value_if_true and a value_if_false.

Accepted Answer

A) True 
 B)False

In conditional formatting, the last rule created will appear ____ the list, unless you change the order of the rules.

The syntax of the IF function is =IF(logical_test,value_if_true,value_if_false).

The NOT function takes only one argument and essentially changes a single TRUE value to FALSE, or a single FALSE value to TRUE.

You can flip the value of a rule from TRUE to FALSE by using the ____ function.

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

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

If you are using a none of construct and if one customer meets the criteria, the statement "none of the customers meet the criteria" is ____.

The Excel Conditional Formatting tools allow you to insert multicolor gradients called ____________________.

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

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

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

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

To help view certain areas of a worksheet, you can ____ panes in the worksheet so that you can focus more easily.

An AND function returns a value of TRUE if ____.

Relational expressions begin with a(n) ____.

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

In a decision tree, if there is one action to take if the test is TRUE and another action to take if it is FALSE, these actions are presented in ____.

Another way that Chloe could write the formula that would show if total purchases ever fell below $150,000 would be ____. The current value is $162,000.

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

An IF function can be used to evaluate a logical test, such as determining if the 90-days past due balance is greater than 0, with only two resulting values: a value_if_true and a value_if_false.

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 conditional formatting, the last rule created will appear ____ the list, unless you change the order of the rules.

The syntax of the IF function is =IF(logical_test,value_if_true,value_if_false).

The NOT function takes only one argument and essentially changes a single TRUE value to FALSE, or a single FALSE value to TRUE.

You can flip the value of a rule from TRUE to FALSE by using the ____ function.

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

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

If you are using a none of construct and if one customer meets the criteria, the statement "none of the customers meet the criteria" is ____.

The Excel Conditional Formatting tools allow you to insert multicolor gradients called ____________________.

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

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

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

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

To help view certain areas of a worksheet, you can ____ panes in the worksheet so that you can focus more easily.

An AND function returns a value of TRUE if ____.

Relational expressions begin with a(n) ____.

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

In a decision tree, if there is one action to take if the test is TRUE and another action to take if it is FALSE, these actions are presented in ____.

Another way that Chloe could write the formula that would show if total purchases ever fell below $150,000 would be ____. The current value is $162,000.

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

An IF function can be used to evaluate a logical test, such as determining if the 90-days past due balance is greater than 0, with only two resulting values: a value_if_true and a value_if_false.

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