Question 1

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

Question 2

Chloe also wants to know if total purchases ever fall below $150,000. The current value is $162,000. She writes the formula ____.

Accepted Answer

A)  =SUM(B5:B9)150 
D)  =AND(B5:B9)<=150 
A)  =SUM(B5:B9)150 
D)  =AND(B5:B9)<=150

Question 3

The formula ="Goodbye">"Hello" returns the value ____________________ because Goodbye comes alphabetically before Hello.

Accepted Answer

The answer of The formula ="Goodbye">"Hello" returns the value ____________________...

Question 4

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

Accepted Answer

The answer of The term ____________________ means that a function...

Question 5

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 6

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

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 8

Briefly describe five of the eight Highlight Cells Rules submenu options that are found on the Conditional Formatting drop-down menu. The options are Greater Than, Less Than, Between, Equal To, Text that Contains, A Date Occurring, Duplicate Values, and More Rules.

Accepted Answer

•Greater Than: Identify values greater t

Question 9

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 10

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 11

One approach to determining if none of the credit rules is TRUE for a specific customer is to figure out if each rule results in a FALSE value.

Accepted Answer

A) True 
 B)False

Question 12

The result of the formula =C1<=D1 where cell C1 contains the label "AA" and cell D1 contains the label "BB" is ____.

Accepted Answer

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

Question 13

If you want the argument to display a text label, you must enclose the text within quotation marks; otherwise, Excel interprets the text as a(n) ____.

Accepted Answer

A)  relational operator 
B)  named range 
C)  value 
D)  error 
A)  relational operator 
B)  named range 
C)  value 
D)  error

Question 14

A range can be used in a Boolean logical AND or OR function if the range refers to cells containing ____.

Accepted Answer

A)  text values 
B)  TRUE or FALSE values 
C)  numeric values 
D)  absolute values 
A)  text values 
B)  TRUE or FALSE values 
C)  numeric values 
D)  absolute values

Question 15

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

Accepted Answer

A)  NOT(logical1) 
B)  NOT(logical1,logical2,...) 
C)  NOT(reference1) 
D)  NOT(value1,value2,...) 
A)  NOT(logical1) 
B)  NOT(logical1,logical2,...) 
C)  NOT(reference1) 
D)  NOT(value1,value2,...)

Question 16

If you entered the date 1/1/2014 directly into a formula, Excel interprets the entry as a ____.

Accepted Answer

A)  numeric expression 
B)  date 
C)  both a and b 
D)  neither a nor b 
A)  numeric expression 
B)  date 
C)  both a and b 
D)  neither a nor b

Question 17

You can "flip" the value of a rule with a(n) ____________________ function to obtain a TRUE value if the rule had a FALSE value.

Accepted Answer

The answer of You can "flip" the value of a...

Question 18

Dun & Street (D&S) is one of the most widely used financial reporting services that provides, among other products, financial information about corporations and institutions.

Accepted Answer

A) True 
 B)False

Question 19

NOT(H2=2) returns the value FALSE assuming that cell H2 contains any value other
than 2. ____________________

Accepted Answer

A) True 
 B)False

Question 20

Case 4-2
   
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.
-Nathan wants to develop a list of customers with past due balances. He will write the formula for one customer and copy it to the remaining rows. A correct formula would be ____.

Accepted Answer

A)  =B5$B$11 
C)  =B5$B$11 
D)  =B5=$B$11 
A)  =B5$B$11 
C)  =B5$B$11 
D)  =B5=$B$11

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

Chloe also wants to know if total purchases ever fall below $150,000. The current value is $162,000. She writes the formula ____.

The formula ="Goodbye">"Hello" returns the value ____________________ because Goodbye comes alphabetically before Hello.

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

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

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

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

Briefly describe five of the eight Highlight Cells Rules submenu options that are found on the Conditional Formatting drop-down menu. The options are Greater Than, Less Than, Between, Equal To, Text that Contains, A Date Occurring, Duplicate Values, and More Rules.

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

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

One approach to determining if none of the credit rules is TRUE for a specific customer is to figure out if each rule results in a FALSE value.

The result of the formula =C1<=D1 where cell C1 contains the label "AA" and cell D1 contains the label "BB" is ____.

If you want the argument to display a text label, you must enclose the text within quotation marks; otherwise, Excel interprets the text as a(n) ____.

A range can be used in a Boolean logical AND or OR function if the range refers to cells containing ____.

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

If you entered the date 1/1/2014 directly into a formula, Excel interprets the entry as a ____.

You can "flip" the value of a rule with a(n) ____________________ function to obtain a TRUE value if the rule had a FALSE value.

Dun & Street (D&S) is one of the most widely used financial reporting services that provides, among other products, financial information about corporations and institutions.

NOT(H2=2) returns the value FALSE assuming that cell H2 contains any value other than 2. ____________________

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

Chloe also wants to know if total purchases ever fall below $150,000. The current value is $162,000. She writes the formula ____.

The formula ="Goodbye">"Hello" returns the value ____________________ because Goodbye comes alphabetically before Hello.

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

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

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

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

Briefly describe five of the eight Highlight Cells Rules submenu options that are found on the Conditional Formatting drop-down menu. The options are Greater Than, Less Than, Between, Equal To, Text that Contains, A Date Occurring, Duplicate Values, and More Rules.

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

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

One approach to determining if none of the credit rules is TRUE for a specific customer is to figure out if each rule results in a FALSE value.

The result of the formula =C1<=D1 where cell C1 contains the label "AA" and cell D1 contains the label "BB" is ____.

If you want the argument to display a text label, you must enclose the text within quotation marks; otherwise, Excel interprets the text as a(n) ____.

A range can be used in a Boolean logical AND or OR function if the range refers to cells containing ____.

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

If you entered the date 1/1/2014 directly into a formula, Excel interprets the entry as a ____.

You can "flip" the value of a rule with a(n) ____________________ function to obtain a TRUE value if the rule had a FALSE value.

Dun & Street (D&S) is one of the most widely used financial reporting services that provides, among other products, financial information about corporations and institutions.

NOT(H2=2) returns the value FALSE assuming that cell H2 contains any value other than 2. ____________________

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