Site MapHelpFeedbackMultiple Choice Quiz
Multiple Choice Quiz
(See related pages)

1
Solver is an enhanced Excel tool that is an example of:
A)An add-in.
B)A cross link.
C)A macro.
D)An XML command.
2
A Solver problem has three components, known as:
A)Fields.
B)Sectors.
C)Conditions.
D)Parameters.
3
A cell with a formula that will be solved for specific results is called:
A)An objective cell.
B)An analyzer.
C)A prime cell.
D)A model.
4
To run Solver, click the Solver button on the Data tab in this group:
A)AutoRun
B)Analysis
C)Projection
D)Solution
5
A saved set of values in a worksheet that function as "what-if" analysis tools are called:
A)Hypotheticals.
B)Conditions.
C)Scenarios.
D)Limited data.
6
These settings determine how data is summarized in a PivotTable:
A)Value field
B)Form box
C)Text box
D)Numeric range
7
A field that appears in the PivotTable but is not a field in the source data is called:
A)A ghost field.
B)A cell reference.
C)A calculated field.
D)A dynamic field.
8
To update a PivotTable, choose:
A)Recalculate.
B)Refresh.
C)Save As.
D)Delimit.
9
The Slicer tool creates an on-screen window that acts as a(n):
A)editor.
B)filter.
C)scenario.
D)sorter.
10
Go to this tab to change the font size and style in a PivotTable:
A)Layout
B)Design
C)View
D)Home
11
A range of cells that shows calculated results of one or more formulas is called:
A)A data table.
B)A numerator.
C)A range return.
D)A net return.
12
A file format that is designed for exchanging data on the web is called:
A)XML.
B)SFX.
C)XDE.
D)CSS.
13
An identifier that appears in chevron braces (<>) which surround the actual data is called:
A)A sig.
B)A tag.
C)A link.
D)A label.
14
How many scenarios can be displayed in a worksheet at any one time?
A)One
B)Two
C)Three
D)Four
15
The default calculation for a value field is:
A)MIN.
B)MAX.
C)SUM.
D)MEAN.





To learn more about the book this website supports, please visit its Information Center.
Copyright (c)2014 McGraw-Hill Education .
Any use is subject to the Terms of Use and Privacy Notice | Report Piracy


Nordell, 1eOnline Learning Center

Home > Excel > Chapter 8 > Ch 8: Multiple Choice Quiz