Question 1

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 2

Unlike cell referencing within a worksheet, the default for conditional formatting is a(n) ____ cell reference.

Accepted Answer

A)  relative 
B)  absolute 
C)  complex 
D)  simple 
A)  relative 
B)  absolute 
C)  complex 
D)  simple

Question 3

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 4

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 5

For an OR function to be TRUE, at least one of its arguments must be TRUE.

Accepted Answer

A) True 
 B)False

Question 6

You can use the ____ logical functions AND, OR, and NOT.

Accepted Answer

A)  Boolean 
B)  Bradstreet 
C)  relational 
D)  simple 
A)  Boolean 
B)  Bradstreet 
C)  relational 
D)  simple

Question 7

You can use dates in ____.

Accepted Answer

A)  relational expressions 
B)  arithmetic expressions 
C)  both a and b 
D)  neither a nor b 
A)  relational expressions 
B)  arithmetic expressions 
C)  both a and b 
D)  neither a nor b

Question 8

In the formula =(1+2)/310, the numbers 1 and 2 are added after they are divided by 3.
____________________

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

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

Question 10

The syntax of the NOT function evaluates only a single TRUE or FALSE value, not a range of values.

Accepted Answer

A) True 
 B)False

Question 11

The syntax of the AND function is as follows: ____.

Accepted Answer

A)  AND(logical1,logical2,...) 
B)  AND(value1,value2,...) 
C)  AND(ref1,ref2,ref3,...) 
D)  AND(if then,false then) 
A)  AND(logical1,logical2,...) 
B)  AND(value1,value2,...) 
C)  AND(ref1,ref2,ref3,...) 
D)  AND(if then,false then)

Question 12

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

Question 13

Identify the letter of the choice that best matches the relational operator used in the formula.
-Not 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 14

The CEO of Chloe's company reviews the chart and hands her this formula: AND(C5,NOT(OR(C5:E5))). The formula will be entered for Aster Construction, and then copied to the remaining rows. Which companies, if any, will return a TRUE value as a result of this formula?

Accepted Answer

A)  Aster Construction 
B)  Ember Trading Company 
C)  Belami Homes 
D)  Davis & Sons 
A)  Aster Construction 
B)  Ember Trading Company 
C)  Belami Homes 
D)  Davis & Sons

Question 15

The Conditional Formatting tools allow you to insert colored bars (called info bars) in addition to standard formatting. ____________________

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

The answer of The ____________________ function evaluates only one logical...

Question 17

Dun & Bradstreet's credit rating includes a composite credit appraisal score that ranges from ____.

Accepted Answer

A)  1 to 4 
B)  1 to 10 
C)  1 to 100 
D)  A to Z 
A)  1 to 4 
B)  1 to 10 
C)  1 to 100 
D)  A to Z

Question 18

Note that an only construct always has a positive condition to be evaluated and a(n) ____________________ condition to be evaluated.

Accepted Answer

The answer of Note that an only construct always has...

Question 19

The result of the formula =(1+2)/310 is ____________________.

Accepted Answer

The answer of The result of the formula =(1+2)/310 is...

Question 20

logical_test is the ____________________ argument of the IF function.

Accepted Answer

The answer of logical_test is the ____________________ argument of the...

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

Unlike cell referencing within a worksheet, the default for conditional formatting is a(n) ____ cell reference.

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.

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

For an OR function to be TRUE, at least one of its arguments must be TRUE.

You can use the ____ logical functions AND, OR, and NOT.

You can use dates in ____.

In the formula =(1+2)/3<>10, the numbers 1 and 2 are added after they are divided by 3. ____________________

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

The syntax of the NOT function evaluates only a single TRUE or FALSE value, not a range of values.

The syntax of the AND function is as follows: ____.

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

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

The CEO of Chloe's company reviews the chart and hands her this formula: AND(C5,NOT(OR(C5:E5))). The formula will be entered for Aster Construction, and then copied to the remaining rows. Which companies, if any, will return a TRUE value as a result of this formula?

The Conditional Formatting tools allow you to insert colored bars (called info bars) in addition to standard formatting. ____________________

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

Dun & Bradstreet's credit rating includes a composite credit appraisal score that ranges from ____.

Note that an only construct always has a positive condition to be evaluated and a(n) ____________________ condition to be evaluated.

The result of the formula =(1+2)/3<>10 is ____________________.

logical_test is the ____________________ argument of the 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

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

Unlike cell referencing within a worksheet, the default for conditional formatting is a(n) ____ cell reference.

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.

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

For an OR function to be TRUE, at least one of its arguments must be TRUE.

You can use the ____ logical functions AND, OR, and NOT.

You can use dates in ____.

In the formula =(1+2)/3<>10, the numbers 1 and 2 are added after they are divided by 3. ____________________

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

The syntax of the NOT function evaluates only a single TRUE or FALSE value, not a range of values.

The syntax of the AND function is as follows: ____.

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

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

The CEO of Chloe's company reviews the chart and hands her this formula: AND(C5,NOT(OR(C5:E5))). The formula will be entered for Aster Construction, and then copied to the remaining rows. Which companies, if any, will return a TRUE value as a result of this formula?

The Conditional Formatting tools allow you to insert colored bars (called info bars) in addition to standard formatting. ____________________

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

Dun & Bradstreet's credit rating includes a composite credit appraisal score that ranges from ____.

Note that an only construct always has a positive condition to be evaluated and a(n) ____________________ condition to be evaluated.

The result of the formula =(1+2)/3<>10 is ____________________.

logical_test is the ____________________ argument of the 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