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 1

Multiple Choice

Review LaterAdd Note

Review Later

If you edit a cell in a calculated column so it is no longer consistent with the other formulas in the column, a _____ appears in the upper-left corner of the cell.

A) red circle
B) blue square
C) red square
D) green triangle

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

Correct Answer

verified

Show Answer

Question 2

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 3

Short Answer

Review LaterAdd Note

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

An error value begins with a(n) _____ followed by an error name that indicates the type of error.

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

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.

_____ just above the header row of an Excel table to select the column data but not the header.

The ORERROR function can determine if a cell contains an error value and then display the message you choose.

To change the background fill color of duplicate values, in the _____ group on the Home tab, click the Conditional Formatting button, and then click Manage Rules.

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

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

The COUNTIF function is sometimes referred to as a(n) _____ count.

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

The _____ function adds the values in a range that match criteria you specify.

The major difference between HLOOKUP and VLOOKUP functions is the way the lookup tables are _____.

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

The _____ function searches vertically down the first column of the lookup table.

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

Two common categories of formula errors in Excel are syntax errors and logic errors.

You can calculate the number of cells in a range that match criteria you specify using the SUMIF function. _________________________