CGS exam 3

Imported content in a worksheet that originated in another program or format is called:

External Data

The Statistical function that does computations only after data meets multiple criteria is:

COUNTIFS

Database functions all follow the same syntax and have three:

arguments

The database function that counts the cells in the field that are not empty and that meet the criteria is:

DCOUNTA

The Math & Trig function that totals cells only if they meet specified criteria, including cells from more than one column, is:

SUMIFS

This function displays the contents of the cell at the intersection of an identified column and row:

index

A range of cells that you select in which to apply a function is called a(n):

Array

In a calculation, the difference between actual values and predicted values is called:

forecast error

Which type of function would you use to format a value as a label?

Text

In a financial function, nper stands for:

Number of payments

Solver is an enhanced Excel tool that is an example of an Excel:

Add In

A Solver problem has three components, known as:

Parameters

A cell with a formula that will be solved for specific results is called a(n):

Objective cell

A forecast sheet inserts functions into its tables from which function category?

statistical

A saved set of values in a worksheet that functions as a "what-if" analysis tool is a(n):

Scenario

What settings determine how data is summarized in a PivotTable?

Value Field

A generated worksheet that displays values for changing and result cells for each scenario in a workbook is called a(n):

Scenario summary report

An Excel add-in with statistical and engineering functions is the:

Analysis ToolPak

A series of scenes created by 3D Map that visualize your data is a(n):

Tour

A problem-solving method that starts with a result and calculates the value to reach that result is:

Backsolving

A range of cells that shows calculated results of one or more formulas is called a(n):

Data table

A column chart that illustrates the frequency of each data point in a data set is called a(n):

histogram

A forecast sheet calculates:

Future values

How many scenarios can be displayed in a worksheet at any one time?

one

A COM add-in that enables you to use millions of records in the data model for a PivotTable is a(n):

Power Pivot

The Slicer tool creates an on-screen window that acts as a(n):

Filter

Available Add-ins for Excel are found in the:

Excel Options dialog box

A collection of tables and queries in a workbook is called a:

Data model

To create a slicer, click the Insert Slicer button in the Filter group on the:

PivotTable Tools Analyze Tab