Exam 4: Applying Logic in Decision Making

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.

You can change the formatting of a cell quite easily using the formatting buttons on the ____ tab.

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. -If Nathan entered the dates shown in column B directly into a formula, Excel would interpret the entry as a(n) ____.

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

The Excel Conditional Formatting tools allow you to insert multicolor gradients called ____________________.

When you are only comparing two values with only a TRUE or FALSE result, an IF function ____.

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

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

The formula NOT(7<10) returns the value ____________________.

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.

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.

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

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

With the AND function, arguments can consist of ____.

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. -One of the daily reports that is delivered to management every day lists any customer who has a balance due of $100,000 or more. If the customer has a high balance, the formula should return due date. Otherwise, the cell is left blank. Assuming that the balance due is in column D in the spreadsheet above, what would the formula look like?

The syntax of the IF function is =IF(logical_test,value_if_true,value_if_false).

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

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

To help view certain areas of a worksheet, you can ____ panes in the worksheet so that you can focus more easily.

You can flip the value of a rule from TRUE to FALSE by using the ____ function.