CGS 2518 EXAM QUESTIONS AND
ANSWERS
A collection of tables and queries in a workbook is called a - Answer-data model
A COM add-in that enables you to use millions of records in data model for a pivot table
is a - Answer-power pivot
To create a slicer click the insert slicer button in the filter group on the - Answer-pivot
table tools analyze tab
The slicer tool creates an on screen window that acts as a - Answer-filter
What is the name of the Seminole Indian leader that one selected FSU portrays at the
various FSU events - Answer-Osceola
How many different FSU students have portrayed this famous Seminole - Answer-17
What is the name of the horse that he rides? - Answer-renegade
What is the breed of the horse - Answer-Appaloosa
How many different horses have had this honor since the tradition started in 1978 -
Answer-6
when you need to highlight information in a worksheet by setting different fill colors or
font styles for selected cells use this excel feature - Answer-conditional formatting
the statistical function that does computations only after data meets multiple criteria is -
Answer-COUNTIFS
a range of cells that you select in which to apply a function is called an - Answer-array
this function displays the content of the cell at the intersection of an identified column
and row - Answer-INDEX
the math and trig function that totals cells only if they meet specified crieteria including
cells from more than one column is - Answer-SUMIFS
database functions all allow the same syntax and have three - Answer-Arguments
in a financial function NPER stands from - Answer-Number of periods
ANSWERS
A collection of tables and queries in a workbook is called a - Answer-data model
A COM add-in that enables you to use millions of records in data model for a pivot table
is a - Answer-power pivot
To create a slicer click the insert slicer button in the filter group on the - Answer-pivot
table tools analyze tab
The slicer tool creates an on screen window that acts as a - Answer-filter
What is the name of the Seminole Indian leader that one selected FSU portrays at the
various FSU events - Answer-Osceola
How many different FSU students have portrayed this famous Seminole - Answer-17
What is the name of the horse that he rides? - Answer-renegade
What is the breed of the horse - Answer-Appaloosa
How many different horses have had this honor since the tradition started in 1978 -
Answer-6
when you need to highlight information in a worksheet by setting different fill colors or
font styles for selected cells use this excel feature - Answer-conditional formatting
the statistical function that does computations only after data meets multiple criteria is -
Answer-COUNTIFS
a range of cells that you select in which to apply a function is called an - Answer-array
this function displays the content of the cell at the intersection of an identified column
and row - Answer-INDEX
the math and trig function that totals cells only if they meet specified crieteria including
cells from more than one column is - Answer-SUMIFS
database functions all allow the same syntax and have three - Answer-Arguments
in a financial function NPER stands from - Answer-Number of periods
