CGS 2518 FINAL MULTIPLE CHOICE
EXAM QUESTIONS AND ANSWERS
Available add-ins for Excel are found in the: - Answer-Options category
A collection of tables and queries in a workbook is called a(n): - Answer-
To create a slicer, click the insert slicer button in the filter group on the: - Answer-
analyze tab
The slicer tool creates an on screen window that acts as a(n): - Answer-filter
A COM add-in that enables you to use millions of records in the data model for a
PivotTable is a(n): - Answer-Power Pivot
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
what text function includes a delimiter argument how to join or combine strings of text -
Answer-TEXTJOIN
Database Functions all follow the same syntax and have three... - Answer-arguments
The Math and Trig function that totals cells only if they meet specific criteria, includes
cells from more than one column, is: - Answer-SUMIFS
This function displays the contents of all cell at the intersection of an identified column
and row - Answer-INDEX
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 to a function is called - Answer-an
array
In a financial function, nper stands for - Answer-number of periods
A column chart that illustrates the frequency of each data point in a data set is called a -
Answer-Histogram
A solver has three components, known as: - Answer-parameters
An Excel add-in with statistical and engineering functions is the: - Answer-Analysis
ToolPak
EXAM QUESTIONS AND ANSWERS
Available add-ins for Excel are found in the: - Answer-Options category
A collection of tables and queries in a workbook is called a(n): - Answer-
To create a slicer, click the insert slicer button in the filter group on the: - Answer-
analyze tab
The slicer tool creates an on screen window that acts as a(n): - Answer-filter
A COM add-in that enables you to use millions of records in the data model for a
PivotTable is a(n): - Answer-Power Pivot
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
what text function includes a delimiter argument how to join or combine strings of text -
Answer-TEXTJOIN
Database Functions all follow the same syntax and have three... - Answer-arguments
The Math and Trig function that totals cells only if they meet specific criteria, includes
cells from more than one column, is: - Answer-SUMIFS
This function displays the contents of all cell at the intersection of an identified column
and row - Answer-INDEX
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 to a function is called - Answer-an
array
In a financial function, nper stands for - Answer-number of periods
A column chart that illustrates the frequency of each data point in a data set is called a -
Answer-Histogram
A solver has three components, known as: - Answer-parameters
An Excel add-in with statistical and engineering functions is the: - Answer-Analysis
ToolPak
