FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 7: Using Advanced Functions and Conditional Formatting

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

Multiple Choice

Review LaterAdd Note

Review Later

An alternative to using several nested IF functions is to use a ____ table.

A) lookup
B) value
C) comparison
D) rating

Correct Answer

verified

Show Answer

Question 52

Short Answer

Review LaterAdd Note

Review Later

The ____________________ function can determine if a cell contains an error value and displays the message you choose rather than the default error value.

Correct Answer

verified

Show Answer

Question 53

Multiple Choice

Review LaterAdd Note

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

Lookup ____ allow you to use tables of data to "look up" values and insert them in another worksheet location.

-According to the dialog box in the accompanying figure,the column in the HealthPlanRates lookup table that stores the value to be returned is the first column.

You could test two or more conditions and determine whether all conditions are true using the ____ function.

____ references make it easier to create formulas that use portions or all of an Excel table because the names or headers are usually simpler to identify than cell addresses.

The ____ function calculates the difference between two dates and shows the result in months,days,or years.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Tallies the number of data values in a range

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

-According to the dialog box in the accompanying figure,the HealthPlanRates table contains the data you want to look up.

____________________ formatting changes a cell's formatting when its contents match a specified condition.

Case-Based Critical Thinking Questions Case 7-2 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 a separate service recognition program,you need to calculate the length of service in complete years.What is the correct formula?

The ____ error value means that Excel does not recognize text in the formula or function.

The IF function results in two values._________________________

The ____________________ function is a logical function that returns a TRUE value if all the logical conditions are true and a FALSE value if any or all of the logical conditions are false.

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

In many situations,the value you store in a cell depends on certain ____.

In the DATEDIF function,the first date argument is the latest date._________________________

With the DATEDIF function,the ____ interval code means months.