Study sets, textbooks, questions
Upgrade to remove ads
CGS2518 Exam 2 Multiple Choice
Terms in this set (34)
Imported content in a worksheet in another program or format is called:
The statistical function that does computations only after data meets multiple criteria is:
Database functions all follow the same syntax and have three:
the database function that counts cells in the field that are not empty and that meet the criteria is:
The math&trig function that totals cells only if they meet specified criteria including cells form more than one column is:
The function displays the contents of the cell at the intersection of an identified column and row:
A range of cells that you select in which to apply a function is called a:
in a calculation, the difference between actual values and predicted values is called:
which type of function would you use to format a value as a label?
in a financial function, nper stands for:
number of payments
Solver is an enhanced excel tool that is an example of an excel:
A solver problem has three components, known as:
A cell with a formula that will be solved for specific results is called a:
A forecast sheet inserts functions into its tables from which function category?
A saved set of values in a worksheet that functions as a "what-if" analysis tool is a:
What settings determine how data is summarized in a pivot table?
A generated worksheet that displays values for changing and result cells for each scenario in a workbook is called a:
scenario summary report
an excel add-in with statistical and engineering functions is the:
a series of scenes created by 3D map that visualize your data is a:
a problem solving method that starts with a result and calculates the value to reach that result is:
a range of cells that shows calculated results of one or more formulas is called a:
a column chart that illustrates the frequency of each data point in a data set is called a:
a forecast sheet calculates:
how many scenarios can be displayed in a worksheet at any one time?
A COM add-in that enables you to use millions of records in the data model for a pivot table is a:
the slicer tool creates an on-screen window that acts as a:
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:
to create a slicer, click the insert slicer button in the filter group on the:
power pivot tools analyze tab
What is the name of the Seminole Indian Leader that one selected FSU portrays at the various FSU events?
How many different FSU students have portrayed this famous Seminole?
What is the name of the horse he rides?
What is the breed of the horse?
How many different horses have had this honor since the tradition started in 1978?
Other sets by this creator
MAR 4832 Exam 1
MAR 3600 Exam 1
MAR 4939 Exam 1
Other Quizlet sets
MUST KNOWS: INTRO TO SENTENCE CORRECTION
Elements of Poetry
Dr. Green Questions
3. Exam - Male GU Exam