FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 8: Excel 4: Working With Advanced Functions

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Multiple Choice

Review LaterAdd Note

Review Later

When you want to reference an entire column of data in a table, you create a column _____.

A) label
B) name
C) variable
D) qualifier

E) C) and D)
F) B) and C)

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

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

A) nested IF
B) CALIF
C) DATEDIF
D) DATE

E) None of the above
F) All of the above

Correct Answer

verified

Show Answer

Question 33

True/False

Review LaterAdd Note

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

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

Case-Based Critical Thinking Questions Case 8-1 Evaluate the formula =AND(G2="FT",M2>=1) based upon the information provided. What value is returned assuming that G2 contains the value FT and M2 contains the value 2?

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

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

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

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

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.

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

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

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

In most cases, when manually creating a conditional formatting formula, the formula should use absolute references and point to the first row of data in a table. _________________________

Case-Based Critical Thinking Questions Case 8-3 You have been using a variety of nested IF functions to calculate costs in your spreadsheet when a colleague stops by and comments on what you have been working on, suggesting that there is an easier approach to use. ​ You implement the VLOOKUP formula at your colleague's suggestion, but you get the #VALUE! error as the result of the formula. Which of the following is likely true?

You can use a _____ function to return a value from a table that is based on an approximate match lookup.

The _____ error value means that a value is not available to a function or formula.

When Excel automatically fills the rest of a table column with a formula entered into an empty table column, this is referred to as a(n) _____ column.

The VLOOKUP function searches vertically down the first column of the lookup table for the value you entered, and then retrieves the corresponding value from another column of the table. _________________________

When using VLOOKUP, the _____argument is optional.