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 71

Multiple Choice

Review LaterAdd Note

Review Later

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 one service recognition program,you need to calculate the length of service in complete months.What is the correct formula?

A) =DATEDIF(C2,$AE$2,"m")
B) =DATEDIF($AE$2,C2,"month")
C) =DATEDIF($AE$2,C2,"mth")
D) =DATEDIF(C2,$AE$2,"mon")

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

Correct Answer

verified

Show Answer

Question 72

True/False

Review LaterAdd Note

Review Later

If a formula is in a calculated table column,you need to make a change in only one cell and the change will automatically be copied to all the cells in the column.

A) True
B) False

Correct Answer

verified

Show Answer

Question 73

True/False

Review LaterAdd Note

If you need to track information such as the specific age,a best practice is to use calculations to determine this value based on values in the Birth Date field.

When the lookup value matches a compare value,the corresponding value from the lookup table is returned to the cell with the lookup formula.

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.

The compare values,the categories for a lookup table,are located in the table's last column or row.

The ____ function calculates the number of cells in a range that match criteria you specify,such as counting the number of company employees located in Austin.

____________________ values indicate that some element in a formula or a cell referenced in a formula is preventing Excel from returning a calculated value.

The #VALUE! error value can occur when a cell used by the function was deleted from the worksheet._________________________

Error values indicate that some element in a ____ is preventing Excel from returning a calculated value.

If any logical condition listed in the function is true,the AND function returns a TRUE value._________________________

Duplicate value highlighting helps to verify that columns of data have unique entries._________________________

Using the VLOOKUP function,an exact match lookup occurs when the value entered must match one of the values in ____ of the lookup table.

The Conditional Formatting button provides access to the ____.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Calculates the average of the values in a range

In a fully qualified structured reference,the table name follows the column qualifier._________________________

Using the VLOOKUP function,when the lookup value matches a(n) ____ value,the corresponding value from the lookup table is returned to the cell with the lookup formula.

In the Styles group on the Home tab,click the Conditional Formatting button,and then click ____ to open the Conditional Formatting Rules Manager dialog box.

The #REF! error value can occur when you supply a range of values to a function that requires a single value._________________________

The ____ function adds the values in a range that match criteria you specify,such as adding the total salary paid to Austin employees.