Multiple choice

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

1. create new rules
2. edit or delete existing rules
3. change the order of these rules
4. all of the above

2 PointsCase-Based Critical Thinking Questions Case 4-1
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 an Accounts Receivable Watch List. She 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 ____.

1. OR(NOT(C5),NOT(D5),NOT(E5))
2. OR(C5:E5)
3. AND(C5:E5)
4. AND(NOT(C5),NOT(D5),NOT(E5))

2 PointsThe first argument of the IF function is the logical_test, and can consist of ____.

1. the value TRUE or FALSE
2. a reference to a cell containing a TRUE or FALSE value
3. a relational expression resulting in a single TRUE or FALSE value
4. all of the above

2 PointsWhen you encounter the key words either and or, meaning if either condition is met, then followed by a specified outcome, the situation indicates the need for a(n) ____ function.

1. AND
2. OR
3. NOT
4. IF

2 PointsYou can change the formatting of a cell quite easily using the Formatting buttons on the ____ tab.

1. Home
2. Create
3. Edit
4. Proof

2 PointsDun & Bradstreet’s credit rating includes a classification ranging from ____ indicating the net worth category of the company.

1. 5A to HH
2. 1A to ZZ
3. 2B to 2Z
4. 1 to 100

2 PointsThe NOT function essentially changes the value ____.

1. TRUE to FALSE
2. FALSE to TRUE
3. either a or b
4. neither a nor b

2 PointsChoose 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.

1. IF
2. AND
3. OR
4. NOT

2 PointsThe OR function returns a value of FALSE if ____.

1. all arguments in the function are TRUE
2. one or more of the arguments in the function are TRUE
3. all arguments in the function are FALSE
4. one or more of the arguments in the function are TRUE

2 PointsCase-Based Critical Thinking Questions 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 ____.

1. =B5<$B$11
2. =B5>$B$11
3. =B5<>$B$11
4. =B5=$B$11