CGS Exam 2 Question Pool

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

Data model.

When you need to highlight information in a worksheet by setting different fill colors or font styles for selected cells, use this Excel feature:

Conditional formatting

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

INDEX

Database functions all follow the same syntax and have three:

Arguments.

In a financial function, nper stands for:

Number of periods.

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

SUMIFS.

What text function that includes a delimiter argument allows you to join or combine strings of text?

TEXTJOIN

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

Array.

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

COUNTIFS.

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

One

What settings determine how data is summarized in a PivotTable?

Value field

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 generated worksheet that displays values for changing and result cells for each scenario in a workbook is called a(n):

Scenario summary report.

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

Histogram.

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

Add-in.

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

Analysis ToolPak.

A saved set of values in a worksheet that functions as a “what-if” analysis tool is a:

Scenario.

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

Data table.

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

Filter.

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

Power Pivot.

Available Add-ins for Excel are found in the:

Excel Options dialog box.

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

PivotTable Tools Analyze tab.

What is the name of the Seminole Indian leader that one selected FSU portrays at the various FSU events?

Chief Osceola

How many different FSU students have portrayed this famous Seminole?

17

What is the name of the horse that he rides?

Renegade

What is the breed of horse?

Appaloosa

How many different horses have had this honor since the tradition started in 1978?

6