Exam 7: Using Advanced Functions and Conditional Formatting

Explore all topics

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Adds the values in a range that meet criteria you specify

(Multiple Choice)

4.9/5

(81)

Question 141

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

(Multiple Choice)

4.9/5

(83)

Question 142

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

(Multiple Choice)

4.9/5

(84)

Question 143

An error value begins with a number sign followed by an error name,which indicates the type of error._________________________

(True/False)

4.8/5

(79)

Question 144

The ____________________ error value means that a cell reference used in a formula or function is no longer valid.

(Short Answer)

4.8/5

(75)

Question 145

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

(Short Answer)

4.8/5

(74)

Question 146

The complete formula that corresponds to the flowchart in the accompanying figure is ____.

(Multiple Choice)

4.9/5

(74)

Question 147

The ____ error value means that,for example,a function name is misspelled.

(Multiple Choice)

4.7/5

(72)

Question 148

The ____ error value means that a formula or function requires two cell ranges to intersect but they do not.

(Multiple Choice)

4.8/5

(69)

Question 149

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

(Short Answer)

4.7/5

(76)

Question 150

Showing 141 - 150 of 150

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Adds the values in a range that meet criteria you specify

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

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

An error value begins with a number sign followed by an error name,which indicates the type of error._________________________

The ____________________ error value means that a cell reference used in a formula or function is no longer valid.

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

The complete formula that corresponds to the flowchart in the accompanying figure is ____.

The ____ error value means that,for example,a function name is misspelled.

The ____ error value means that a formula or function requires two cell ranges to intersect but they do not.

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

Getting Started With Excel

Formatting a Workbook

Working With Formulas and Functions

Enhancing a Workbook With Charts and Graphs

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Financial Tools and Functions

Performing What-If Analyses

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters