FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 7: Excel: Using Advanced Functions Conditional Formatting and Filtering

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 71

Multiple Choice

Review LaterAdd Note

Review Later

With the ____ function you can specify only one condition to summarize the data.

A) SUMIFS
B) AVERAGEIF
C) COUNTIFS
D) All of the above

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

Correct Answer

verified

Show Answer

Question 72

Multiple Choice

Review LaterAdd Note

Review Later

After a calculated column contains an inconsistency any other edits you make to that column are no longer automatically applied to the rest of the cells in that column because Excel does not overwrite ____ values.

A) indexed
B) marginal
C) custom
D) filled

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

Correct Answer

verified

Show Answer

Question 73

Multiple Choice

Review LaterAdd Note

You can insert a selected function from the list of valid function names by pressing the ____ key.

To sort records by color click the filter arrow to open the Filter menu and then click _________________________.

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

To evaluate a condition in Excel you use the ____ function.

Given the flowchart in the accompanying figure a Health Plan value of ____ yields a Health Plan Cost of 1650.

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

When you retrieve a particular value from a lookup table the ____ value is the value you are trying to find.

Given the flowchart in the accompanying figure a Health Plan value of ____ yields a Health Plan Cost of 0.

The ____ qualifier references the Total row in the table.

The conditions H2="Y" and H2="y" return different values.

A(n)_________________________ table is a table that organizes data you want to retrieve into different categories.

To retrieve a particular value from a lookup table a(n)_________________________ needs to match the compare values.

According to the dialog box in the accompanying figure the lookup_value is found in row 2 of the table.

Identify the letter of the choice that best matches the phrase or definition.

The _________________________ error value means that the wrong type of argument is used in a function or formula.