Question 1

The ____________________ of a company is based on the assets and liabilities listed on its balance sheet.

Accepted Answer

The answer of The ____________________ of a company is based...

Question 2

The Highlight Cells Rules submenu options called Equal To identify either duplicate values with a specific format or unique values. ____________________

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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.
-If any one value in column C, D, or E is FALSE, then that customer is going to be put on the Accounts Receivable Watch List. Chloe wants to return a value of TRUE for customers to be put on the watch list. She will write the formula for Aster Construction first, and then copy it to the other rows. The logical construct Chloe would use is ____.

Accepted Answer

A)  OR(NOT(C5),NOT(D5),NOT(E5)) 
B)  OR(C5:E5) 
C)  AND(C5:E5) 
D)  AND(NOT(C5),NOT(D5),NOT(E5)) 
A)  OR(NOT(C5),NOT(D5),NOT(E5)) 
B)  OR(C5:E5) 
C)  AND(C5:E5) 
D)  AND(NOT(C5),NOT(D5),NOT(E5))

Question 5

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 6

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 7

Dates are stored as ____.

Accepted Answer

A)  text and numbers 
B)  sequential numbers 
C)  text only 
D)  a series of slashes and numbers 
A)  text and numbers 
B)  sequential numbers 
C)  text only 
D)  a series of slashes and numbers

Question 8

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 9

In a nested IF function, the second argument (value_if_true) and/or the third argument (value_if_false) cannot contain another IF function.

Accepted Answer

A) True 
 B)False

Question 10

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

Question 11

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 12

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 13

Use the logical construct of OR(A1) to change a single TRUE to FALSE or a single FALSE to TRUE.

Accepted Answer

A) True 
 B)False

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

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 16

After establishing the conditional formatting in one row, you can use the ____ tool to copy the formatting down the column to the remaining rows.

Accepted Answer

A)  Format Painter 
B)  Paint 
C)  Format 
D)  Copy 
A)  Format Painter 
B)  Paint 
C)  Format 
D)  Copy

Question 17

Nathan is in charge of collections, and is putting together a list of customers to call. Please refer to the figure above as you answer the questions below.
-Instead of "Call," Nathan has decided to list the due date for those customers who have a FALSE value in column C. Customers with a TRUE value in column C should still generate a "Don't Call" value. His formula now looks like ____.

Accepted Answer

A)  =IF(C5,"Don't Call",B5) 
B)  =IF(C5,B5,"Don't Call") 
C)  =AND(C5,B5,"Don't Call") 
D)  =AND(C5,"Don't Call",B5) 
A)  =IF(C5,"Don't Call",B5) 
B)  =IF(C5,B5,"Don't Call") 
C)  =AND(C5,B5,"Don't Call") 
D)  =AND(C5,"Don't Call",B5)

Question 18

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 19

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 20

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

The ____________________ of a company is based on the assets and liabilities listed on its balance sheet.

The Highlight Cells Rules submenu options called Equal To identify either duplicate values with a specific format or unique values. ____________________

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

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

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

Dates are stored as ____.

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

In a nested IF function, the second argument (value_if_true) and/or the third argument (value_if_false) cannot contain another IF function.

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.

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

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

Use the logical construct of OR(A1) to change a single TRUE to FALSE or a single FALSE to TRUE.

An AND function returns a value of TRUE if ____.

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

After establishing the conditional formatting in one row, you can use the ____ tool to copy the formatting down the column to the remaining rows.

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

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.

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

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 ____________________ of a company is based on the assets and liabilities listed on its balance sheet.

The Highlight Cells Rules submenu options called Equal To identify either duplicate values with a specific format or unique values. ____________________

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

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

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

Dates are stored as ____.

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

In a nested IF function, the second argument (value_if_true) and/or the third argument (value_if_false) cannot contain another IF function.

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.

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

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

Use the logical construct of OR(A1) to change a single TRUE to FALSE or a single FALSE to TRUE.

An AND function returns a value of TRUE if ____.

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

After establishing the conditional formatting in one row, you can use the ____ tool to copy the formatting down the column to the remaining rows.

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

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.

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

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