Home
Subjects
Expert solutions
Create
Study sets, textbooks, questions
Log in
Sign up
Upgrade to remove ads
Only $35.99/year
Other
Computer Skills
CGS2518 Exam 2 Multiple Choice
Flashcards
Learn
Test
Match
Flashcards
Learn
Test
Match
Terms in this set (34)
Imported content in a worksheet 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 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 form more than one column is:
SUMIFS
The 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 a:
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:
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:
scenario
What settings determine how data is summarized in a pivot table?
value field
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:
analysis toolpak
a series of scenes created by 3D map that visualize your data is a:
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:
data table
a column chart that illustrates the frequency of each data point in a data set is called a:
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 pivot table is a:
power pivot
the slicer tool creates an on-screen window that acts as a:
filter
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:
data model
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?
Osceola
How many different FSU students have portrayed this famous Seminole?
16
What is the name of the horse he rides?
Renegade
What is the breed of the horse?
Appaloosa
How many different horses have had this honor since the tradition started in 1978?
6
Other sets by this creator
MAR 4832 Exam 1
120 terms
MAR 3600 Exam 1
160 terms
MAN 4720
82 terms
MAR 4939 Exam 1
81 terms
Other Quizlet sets
MUST KNOWS: INTRO TO SENTENCE CORRECTION
20 terms
Elements of Poetry
50 terms
Dr. Green Questions
112 terms
3. Exam - Male GU Exam
54 terms