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

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

A) True
B) False

Correct Answer

verified

True

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

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

A) SUMIF
B) VLOOKUP
C) COUNTIF
D) conditional formatting
E) DATEDIF
F) AVERAGE
G) HLOOKUP
H) TRANSPOSE
I) logical condition
J) SUM

K) B) and E)
L) D) and I)

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

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

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 adds the values in a range that meet criteria you specify.

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

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

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

Nesting IF functions will allow for three or more outcomes.

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?

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

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

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

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

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

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

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.

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

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.