CGS2518 FSU MC EXAM QUESTIONS
WITH COMPLETE ANSWERS
A generated worksheet that displays values for changing and result cells for each
scenario in a workbook is called a(n): - Answer-scenario summary report
An Excel add-in with statistical and engineering functions is the: - Answer-Analysis
ToolPak
A series of scenes created by 3D Map that visualize your data is a(n): - Answer-tour
A problem-solving method that starts with a result and calculates the value to reach that
result is: - Answer-Backsolving
A range of cells that shows calculated results of one or more formulas is called a(n): -
Answer-data table
A column chart that illustrates the frequency of each data point in a data set is called
a(n): - Answer-histogram
A forecast sheet calculates: - Answer-future values
How many scenarios can be displayed in a worksheet at any one time? - Answer-one
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
The Slicer tool creates an on-screen window that acts as a(n): - Answer-Filter
Available Add-ins for Excel are found in the: - Answer-Excel Options dialog box
A collection of tables and queries in a workbook is called a: - Answer-data model
To create a slicer, click the Insert Slicer button in the Filter group on the: - Answer-
PivotTable Tools Analyze tab
Imported content in a worksheet that originated in another program or format is called: -
Answer-External Data
The Statistical function that does computations only after data meets multiple criteria is:
- Answer-COUNTIFS
Database functions all follow the same syntax and have three: - Answer-arguments
WITH COMPLETE ANSWERS
A generated worksheet that displays values for changing and result cells for each
scenario in a workbook is called a(n): - Answer-scenario summary report
An Excel add-in with statistical and engineering functions is the: - Answer-Analysis
ToolPak
A series of scenes created by 3D Map that visualize your data is a(n): - Answer-tour
A problem-solving method that starts with a result and calculates the value to reach that
result is: - Answer-Backsolving
A range of cells that shows calculated results of one or more formulas is called a(n): -
Answer-data table
A column chart that illustrates the frequency of each data point in a data set is called
a(n): - Answer-histogram
A forecast sheet calculates: - Answer-future values
How many scenarios can be displayed in a worksheet at any one time? - Answer-one
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
The Slicer tool creates an on-screen window that acts as a(n): - Answer-Filter
Available Add-ins for Excel are found in the: - Answer-Excel Options dialog box
A collection of tables and queries in a workbook is called a: - Answer-data model
To create a slicer, click the Insert Slicer button in the Filter group on the: - Answer-
PivotTable Tools Analyze tab
Imported content in a worksheet that originated in another program or format is called: -
Answer-External Data
The Statistical function that does computations only after data meets multiple criteria is:
- Answer-COUNTIFS
Database functions all follow the same syntax and have three: - Answer-arguments
