(CGS 2518 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

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 an

array

this function displays the content of the cell at the intersection of an identified column and row

INDEX

the math and trig function that totals cells only if they meet specified crieteria including cells from more than one column is

SUMIFS

database functions all allow the same syntax and have three

Arguments

in a financial function NPER stands from

Number of periods

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

TEXTJOIN

solver is an enhanced excel tool that is an example of an excel

Add-In

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

One

a saved set of values in a worksheet that functions as what if analysis tool is a

scenario

a cell with a formula that can be solved for specific results is called an

objective cell

a column chart that illustrates the frequency of each data point in a data set is called a

histogram

a generated worksheet that displays values for changing and result cells for each scenario in a workbook is called a

scenario summary report

A Solver problem has three components, known as:

parameters

an excel add-in with statistical and engineering functions is the

analysis toolpak

what settings determine how data is summarized in a pivot table

value field

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

data table

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

a COM add-in that enables you to use millions of records in data model for a pivot table is a

power pivot

to create a slicer click the insert slicer button in the filter group on the

pivot table tools analyze tab

the slicer tool creates an on screen window that acts as a

filter

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

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 the horse

Appaloosa

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

6