Exam 2 SIMNET Questions
Imported content in a worksheet that originated in another program or format is called: -
✔✔External Data
The Statistical function that does computations only after data meets multiple criteria
...
Exam 2 SIMNET Questions
Imported content in a worksheet that originated in another program or format is called: -
✔✔External Data
The Statistical function that does computations only after data meets multiple criteria is -
✔✔COUNTIFS
Database functions all follow the same syntax and have three: - ✔✔Arguments
The database function that counts the cells in the field that are not empty and that meet the
criteria is - ✔✔DCOUNTA
The Math & Trig function that totals cells only if they meet specified criteria, including cells
from more than one column, is - ✔✔SUMIFS
This function displays the contents of the cell at the intersection of an identified column and row
- ✔✔INDEX
A range of cells that you select in which to apply a function is called an - ✔✔Array
In a calculation, the difference between actual values and predicted values is called -
✔✔Forecast error
Which type of function would you use to format a value as a label - ✔✔Text
In a financial function, nper stands for: - ✔✔Number of payments
Solver is an enhanced Excel tool that is an example of an Excel - ✔✔add-in
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
A forecast sheet inserts functions into its tables from which function category? - ✔✔Statistical
A saved set of values in a worksheet that functions as a "what-if" analysis tool is a(n) -
✔✔Scenario
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 series of scenes created by 3D map that will visualize your data is an - ✔✔Tour
A problem-solving method that starts with a result and calculates the value to reach that result is:
- ✔✔Backsolving
A range of cells that shows calculated results of one or more formulas is called a(n): - ✔✔Data
table
A column chart that illustrates the frequency of each data point in a data set is called a(n): -
✔✔Histogram
A forecast sheet calculates: - ✔✔Future Values
How many scenarios can be displayed in a worksheet at any one time? - ✔✔One
A COM add-in that enables you to use millions of records in the data model for a PivotTable is
a(n): - ✔✔Power pivot
The Slicer tool creates an on-screen window that acts as a(n): - ✔✔Filter
Available Add-ins for Excel are found in the: - ✔✔Excel options dialogue box
A collection of tables and queries in a workbook is called a: - ✔✔Data model
To create a slicer, click the Insert Slicer button in the Filter group on the: - ✔✔PivotTable Tools
Analyze tab.
ec 1: what is the name of the seminole indian leader that one selected fsu portrays at various fsu
events? - ✔✔osceola
ec 2: how many different fsu students have portrayed this famous seminole? - ✔✔16
ec 3: what is the name of the horse he rides? - ✔✔renegade
ec 4: what is the breed of the horse? - ✔✔Appaloosa
ec 5: how many different horses have had this honor since the tradition started in 1978? - ✔✔6
[Show More]
