Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

MATCHING
   
Identify the letter of the choice that best matches the common logical construct.
-OR(NOT(A1),NOT(A2),NOT(A3),NOT(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 3

The AND function evaluates a list of logical arguments to determine if at least one of the arguments is TRUE.

Accepted Answer

A) True 
 B)False

Question 4

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 5

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 6

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 7

The Conditional Formatting Rules Manager dialog box can be used to ____.

Accepted Answer

A)  create new rules 
B)  edit or delete existing rules 
C)  change the order of these rules 
D)  all of the above 
A)  create new rules 
B)  edit or delete existing rules 
C)  change the order of these rules 
D)  all of the above

Question 8

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 9

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 10

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

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

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

Question 12

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 13

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

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 15

Excel ____ empty cells in a range of cells in an AND or OR function.

Accepted Answer

A)  ignores 
B)  deletes 
C)  fills 
D)  highlights 
A)  ignores 
B)  deletes 
C)  fills 
D)  highlights

Question 16

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

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 18

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 19

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 20

The result of the formula =B3>=C3 where cell B3 contains the date 1/1/2010 and cell C3 contains the date 12/31/2009 is ____.

Accepted Answer

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

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

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

The AND function evaluates a list of logical arguments to determine if at least one of the arguments is TRUE.

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.

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 OR function returns a value of FALSE if ____.

The Conditional Formatting Rules Manager dialog box can be used to ____.

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

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

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

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

You can apply conditional formatting to cells based on ____.

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

Excel ____ empty cells in a range of cells in an AND or OR function.

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

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

Relational expressions ____.

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 =B3>=C3 where cell B3 contains the date 1/1/2010 and cell C3 contains the date 12/31/2009 is ____.

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 =100>MAX(5,10,20) is FALSE. ____________________

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

The AND function evaluates a list of logical arguments to determine if at least one of the arguments is TRUE.

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.

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 OR function returns a value of FALSE if ____.

The Conditional Formatting Rules Manager dialog box can be used to ____.

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

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

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

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

You can apply conditional formatting to cells based on ____.

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

Excel ____ empty cells in a range of cells in an AND or OR function.

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

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

Relational expressions ____.

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 =B3>=C3 where cell B3 contains the date 1/1/2010 and cell C3 contains the date 12/31/2009 is ____.

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