FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 8: Working With Advanced Functions

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

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

A) theme
B) object
C) condition
D) rule

E) All of the above
F) A) and B)

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

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?

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

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

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

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

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.

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

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

Nesting IF functions will allow for three or more outcomes.

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

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

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

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.

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.

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

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

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.