Question 1

____ is a kind of shorthand formula showing the structure of the formula without the syntactical details.

Accepted Answer

A)  Pseudocode 
B)  Trial code 
C)  Shorthand code 
D)  Label code 
A)  Pseudocode 
B)  Trial code 
C)  Shorthand code 
D)  Label code

Question 2

To perform the task of displaying "credit approved" or "credit denied" based on the corresponding Boolean value in column H, you can write a formula in cell I3 containing an IF function, as follows: ____.

Accepted Answer

A)  =IF(H3,"credit approved","credit denied") 
B)  =IF(H3,"credit denied","credit denied") 
C)  =IF("credit denied","credit denied",H3) 
D)  =IF H3 ("credit denied","credit denied") 
A)  =IF(H3,"credit approved","credit denied") 
B)  =IF(H3,"credit denied","credit denied") 
C)  =IF("credit denied","credit denied",H3) 
D)  =IF H3 ("credit denied","credit denied")

Question 3

Assuming that cell D4 contains the date 12/31/2013 and cell D1 contains the date 1/1/2014, you could write the formula =D4>=D1, and the result would be ____.

Accepted Answer

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

Question 4

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 5

MATCHING
   
Identify the letter of the choice that best matches the common logical construct.
-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 6

If logical_test results in a(n) ____________________ value, Excel evaluates the value_if_true argument.

Accepted Answer

The answer of If logical_test results in a(n) ____________________ value,...

Question 7

The financial stress risk class is a rating from ____, indicating the risk of a company in financial distress, where 1 represents businesses with the lowest probability of risk.

Accepted Answer

A)  1 to 5 
B)  1 to 4 
C)  1 to 9 
D)  1 to 99 
A)  1 to 5 
B)  1 to 4 
C)  1 to 9 
D)  1 to 99

Question 8

If you want to compare the value 3 to the value 5 to see if 3 is greater than 5, you would enter the following formula: =3>5.

Accepted Answer

A) True 
 B)False

Question 9

When using an IF function, if customers with overdue payments fall into only one category (90 days, 60 days, or 30 days), ____.

Accepted Answer

A)  you should test the 90-day condition first 
B)  you should test the 60-day condition first 
C)  you should test the 30-day condition first 
D)  it doesn't matter which condition is tested first 
A)  you should test the 90-day condition first 
B)  you should test the 60-day condition first 
C)  you should test the 30-day condition first 
D)  it doesn't matter which condition is tested first

Question 10

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

Accepted Answer

The answer of The ____________________ function evaluates a list of...

Question 11

The >, >=, <, and <= operators also work with text, where a greater value is one that appears later in the ____.

Accepted Answer

A)  alphabet 
B)  formula 
C)  worksheet 
D)  logic 
A)  alphabet 
B)  formula 
C)  worksheet 
D)  logic

Question 12

When all of the operands copy relatively, no ____ references are required.

Accepted Answer

A)  absolute 
B)  relative 
C)  both a and b 
D)  neither a nor b 
A)  absolute 
B)  relative 
C)  both a and b 
D)  neither a nor b

Question 13

Excel provides unconditional formatting 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) True 
 B)False

Question 14

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-can save a considerable amount of work.

Accepted Answer

A) True 
 B)False

Question 15

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 16

With the AND function, arguments can consist of ____.

Accepted Answer

A)  cell references 
B)  a range of cells containing Boolean logical values 
C)  relational expressions 
D)  all of the above 
A)  cell references 
B)  a range of cells containing Boolean logical values 
C)  relational expressions 
D)  all of the above

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

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

Accepted Answer

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

Question 20

A(n) ____ function is a Boolean logical function that returns one value if a specified condition evaluates to TRUE, and another value if the specified condition evaluates to FALSE.

Accepted Answer

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

____ is a kind of shorthand formula showing the structure of the formula without the syntactical details.

To perform the task of displaying "credit approved" or "credit denied" based on the corresponding Boolean value in column H, you can write a formula in cell I3 containing an IF function, as follows: ____.

Assuming that cell D4 contains the date 12/31/2013 and cell D1 contains the date 1/1/2014, you could write the formula =D4>=D1, and the result would be ____.

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

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

If logical_test results in a(n) ____________________ value, Excel evaluates the value_if_true argument.

The financial stress risk class is a rating from ____, indicating the risk of a company in financial distress, where 1 represents businesses with the lowest probability of risk.

If you want to compare the value 3 to the value 5 to see if 3 is greater than 5, you would enter the following formula: =3>5.

When using an IF function, if customers with overdue payments fall into only one category (90 days, 60 days, or 30 days), ____.

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

The >, >=, <, and <= operators also work with text, where a greater value is one that appears later in the ____.

When all of the operands copy relatively, no ____ references are required.

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

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-can save a considerable amount of work.

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

With the AND function, arguments can consist of ____.

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

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

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

A(n) ____ function is a Boolean logical function that returns one value if a specified condition evaluates to TRUE, and another value if the specified condition evaluates to 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

____ is a kind of shorthand formula showing the structure of the formula without the syntactical details.

To perform the task of displaying "credit approved" or "credit denied" based on the corresponding Boolean value in column H, you can write a formula in cell I3 containing an IF function, as follows: ____.

Assuming that cell D4 contains the date 12/31/2013 and cell D1 contains the date 1/1/2014, you could write the formula =D4>=D1, and the result would be ____.

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

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

If logical_test results in a(n) ____________________ value, Excel evaluates the value_if_true argument.

The financial stress risk class is a rating from ____, indicating the risk of a company in financial distress, where 1 represents businesses with the lowest probability of risk.

If you want to compare the value 3 to the value 5 to see if 3 is greater than 5, you would enter the following formula: =3>5.

When using an IF function, if customers with overdue payments fall into only one category (90 days, 60 days, or 30 days), ____.

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

The >, >=, <, and <= operators also work with text, where a greater value is one that appears later in the ____.

When all of the operands copy relatively, no ____ references are required.

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

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-can save a considerable amount of work.

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

With the AND function, arguments can consist of ____.

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

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

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

A(n) ____ function is a Boolean logical function that returns one value if a specified condition evaluates to TRUE, and another value if the specified condition evaluates to 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