Exam 8: Working With Advanced Functions

The _____ function is a logical function that evaluates a condition and then returns one value if the condition is true and another value if the condition is false.

If all of the logical conditions are true,the AND function returns the logical value _____.

All the logical conditions listed in an AND function must be true for the AND function to return a TRUE value.

You can edit existing conditional formatting _____ from the Conditional Formatting Rules Manager dialog box.

-Given the flowchart in the accompanying figure,the Perf Rating of _____ yields a Bonus value of 2500.

-Given the flowchart in the accompanying figure,the Perf Rating of _____ yields a Bonus value of 0.

A formula that includes a structured reference can be fully qualified or unqualified.

Your boss in the human resources department asks you to write a function that calculates the length of time that employees have been with the firm, using the DATEDIF function. Assume that C2 contains the hire date for a given employee and that cell $AE$2 contains the cut-off date against which to compare the hire date to determine length of service. -For one service recognition program,you need to calculate the length of service in complete months.What is the correct formula?

Nesting IF functions will allow for three or more outcomes.

The ____________________ function adds the values in a range that meet criteria you specify.

The ____________________ error value means that the formula or function contains a number divided by 0.

The ____________________ function searches horizontally across a lookup table and is used when the compare values are stored in the first row of the lookup table.

When you create a calculated column,you can use _____ references to create the formula.

Sometimes the built-in conditional formatting rules do not apply the formatting you need.In these instances,you may be able to create a conditional formatting rule based on a formula that uses a logical expression to describe the condition you want.Give an example of when you would use this type of formula,and list two guidelines you must follow when creating this type of formula.

A(n)____________________ IF function is when one IF function is placed inside another IF function to test an additional condition.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Expression that returns either a TRUE value or a FALSE value

You can include up to _____ logical conditions in the AND function.

If you are not sure of a table's name,click in the table,click the _____ tab on the Ribbon,and then click the Table Name box in the Properties group.

You $\underline {\text { cannot }}$ nest more than one IF function to test for multiple outcomes._________________________

Each time you create a conditional format,you are defining a conditional formatting _____.