CGS exam 2

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

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

textjoin

Database functions all follow the same syntax and have three:

arguments

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

sumifs

In a financial function, nper stands for:

number of periods

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

index

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

countifs

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

array

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 column chart that illustrates the frequency of each data point in a data set is called a(n):

histogram

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

scenario

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

one

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

data table

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

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

add-in

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

pivottable tools analyze tab

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

data model

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

Name of the seminole leader

Osceola

How many different FSU students have portrayed him

17

Name of the horse

Renegade

Breed of the horse

Appaloosa

How many different horses since 1978

6