Question 1

Excel provides ____ tools, which are tools you can use to identify a set of conditions and specify the formatting if those conditions are met.

Accepted Answer

A)  Conditional Formatting 
B)  Unconditional Formatting 
C)  Conditional Editing 
D)  Unconditional Editing 
A)  Conditional Formatting 
B)  Unconditional Formatting 
C)  Conditional Editing 
D)  Unconditional Editing

Question 2

=OR(FALSE,TRUE,TRUE) results in the final value of ____.

Accepted Answer

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

Question 3

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 4

To remove all of the conditional formatting on a worksheet, select the Conditional Formatting button, select ____ in the drop-down menu, and then click Clear Rules from Entire Sheet.

Accepted Answer

A)  Clear Rules 
B)  Clear Formatting 
C)  Clear Editing 
D)  Clear 
A)  Clear Rules 
B)  Clear Formatting 
C)  Clear Editing 
D)  Clear

Question 5

You can apply conditional formatting to cells based on ____.

Accepted Answer

A)  the value in a cell 
B)  results of a specified formula that returns a Boolean value 
C)  the name of the function used in the cell 
D)  both a and b 
A)  the value in a cell 
B)  results of a specified formula that returns a Boolean value 
C)  the name of the function used in the cell 
D)  both a and b

Question 6

An IF function is a Boolean logical function that returns one value if a specified condition evaluates to TRUE, and the same value if the specified condition evaluates to FALSE.

Accepted Answer

A) True 
 B)False

Question 7

When you are only comparing two values with only a TRUE or FALSE result, an IF function ____.

Accepted Answer

A)  is not necessary 
B)  will make your formula simpler 
C)  will result in an incorrect answer 
D)  must be used 
A)  is not necessary 
B)  will make your formula simpler 
C)  will result in an incorrect answer 
D)  must be used

Question 8

One of the daily reports that is delivered to management every day lists any customer who has a balance due of $100,000 or more. If the customer has a high balance, the formula should return due date. Otherwise, the cell is left blank. Assuming that the balance due is in column D in the spreadsheet above, what would the formula look like?

Accepted Answer

A)  =IF(D5=100000,B5, " ") 
B)  =IF(D5=100000,B5," ") 
D)  =IF(D5," ",B5) 
A)  =IF(D5=100000,B5, " ") 
B)  =IF(D5=100000,B5," ") 
D)  =IF(D5," ",B5)

Question 9

The formula =OR(25<24,MIN(1,10)<2,3<=2+1) returns a ____ value.

Accepted Answer

A)  TRUE 
B)  FALSE 
C)  numeric 
D)  error 
A)  TRUE 
B)  FALSE 
C)  numeric 
D)  error

Question 10

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

Question 11

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) 
A) (#1) 
B) (#2) 
C) (#3) 
D) (#4) 
E) (#5)
F)(#6)
G)(#7)
H)(#8)

Question 12

TRUE and FALSE are referred to as Boolean logical values.

Accepted Answer

A) True 
 B)False

Question 13

The formula =OR(K3:K21) returns a TRUE value if any of the values in K3 through K21 contain the value TRUE.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

NOT(FALSE) returns the value ____.

Accepted Answer

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

Question 16

MATCHING
   
Identify the letter of the choice that best matches the common logical construct.
-AND(A1,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 17

The syntax of the NOT function evaluates ____.

Accepted Answer

A)  a single TRUE or FALSE value 
B)  a range of values 
C)  two TRUE or FALSE values 
D)  logical operators 
A)  a single TRUE or FALSE value 
B)  a range of values 
C)  two TRUE or FALSE values 
D)  logical operators

Question 18

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 19

If the conditions are not mutually exclusive, resulting in more than one specified condition being TRUE, the formatting ____.

Accepted Answer

A)  of the last specified rule overrides those of earlier rules 
B)  of the first specified rule overrides those of later rules 
C)  defaults back to match the rest of the spreadsheet 
D)  is applied by merging the formatting of all of the conditions 
A)  of the last specified rule overrides those of earlier rules 
B)  of the first specified rule overrides those of later rules 
C)  defaults back to match the rest of the spreadsheet 
D)  is applied by merging the formatting of all of the conditions

Question 20

Note that a(n) ____ construct always has a positive condition to be evaluated AND a negative condition to be evaluated.

Accepted Answer

A)  only 
B)  not 
C)  or 
D)  and 
A)  only 
B)  not 
C)  or 
D)  and

Excel provides ____ tools, which are tools you can use to identify a set of conditions and specify the formatting if those conditions are met.

=OR(FALSE,TRUE,TRUE) results in the final value of ____.

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

To remove all of the conditional formatting on a worksheet, select the Conditional Formatting button, select ____ in the drop-down menu, and then click Clear Rules from Entire Sheet.

You can apply conditional formatting to cells based on ____.

An IF function is a Boolean logical function that returns one value if a specified condition evaluates to TRUE, and the same value if the specified condition evaluates to FALSE.

When you are only comparing two values with only a TRUE or FALSE result, an IF function ____.

The formula =OR(25<24,MIN(1,10)<2,3<=2+1) returns a ____ value.

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

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

TRUE and FALSE are referred to as Boolean logical values.

The formula =OR(K3:K21) returns a TRUE value if any of the values in K3 through K21 contain the value TRUE.

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

NOT(FALSE) returns the value ____.

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

The syntax of the NOT function evaluates ____.

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

If the conditions are not mutually exclusive, resulting in more than one specified condition being TRUE, the formatting ____.

Note that a(n) ____ construct always has a positive condition to be evaluated AND a negative condition to be evaluated.

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

Excel provides ____ tools, which are tools you can use to identify a set of conditions and specify the formatting if those conditions are met.

=OR(FALSE,TRUE,TRUE) results in the final value of ____.

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

To remove all of the conditional formatting on a worksheet, select the Conditional Formatting button, select ____ in the drop-down menu, and then click Clear Rules from Entire Sheet.

You can apply conditional formatting to cells based on ____.

An IF function is a Boolean logical function that returns one value if a specified condition evaluates to TRUE, and the same value if the specified condition evaluates to FALSE.

When you are only comparing two values with only a TRUE or FALSE result, an IF function ____.

The formula =OR(25<24,MIN(1,10)<2,3<=2+1) returns a ____ value.

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

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

TRUE and FALSE are referred to as Boolean logical values.

The formula =OR(K3:K21) returns a TRUE value if any of the values in K3 through K21 contain the value TRUE.

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

NOT(FALSE) returns the value ____.

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

The syntax of the NOT function evaluates ____.

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

If the conditions are not mutually exclusive, resulting in more than one specified condition being TRUE, the formatting ____.

Note that a(n) ____ construct always has a positive condition to be evaluated AND a negative condition to be evaluated.

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