Site MapHelpFeedbackLesson 14 - Using What-If Analysis
Lesson 14 - Using What-If Analysis
(See related pages)

1
Which of the following statements about scenarios is not true?
A)A scenario is a set of values saved with the workbook.
B)A workbook can have one scenario per sheet.
C)Scenarios provide a way to see different solutions for worksheet formulas.
D)Scenarios help to perform what-if analysis.
2
What is a macro?
A)Solver scenario
B)Visual Basic scenario
C)Visual Basic routine
D)Solver routine
3
What is a scenario summary report?
A)A formatted description of each scenario on a separate worksheet
B)A formatted defined range of Solver and Goal Seek solutions
C)A worksheet with a separate thumbnail for each formula
D)A worksheet with separate macros for each scenario
4
Which symbol, when clicked, expands the data in a scenario summary report?
A)+
B)-
C)*
D)/
5
Which command tab includes a button to run a macro?
A)Home
B)Insert
C)Data
D)View
6
What happens when a workbook with a macro opens if the Trust Center is set to notify you when a workbook does have a macro?
A)The macro is executed.
B)The macro is deleted from the workbook.
C)A security message panel opens.
D)The Trust Center choices are listed.
7
What does Solver uses in its dialog box?
A)Arguments
B)Limitations
C)Constraints
D)Parameters
8
Which dialog box is used to enter different possible values for a selected range?
A)Scenario Manager
B)Edit Scenario
C)Scenario Values
D)Scenario Summary
9
What term describes a feature that gives Excel enhanced capability?
A)Trendlining
B)Enhancement bit
C)Thumbnail
D)Add-in
10
How can a highlight cells rule format the selected range?
A)With fill and font color
B)With symbols and shapes
C)With shadows and images
D)With SmartArt Graphics and fill color





To learn more about the book this website supports, please visit its Information Center.
(c)2010 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Notice.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.


PAS Office 2007 BriefOnline Learning Center

Home > Excel > Lesson 14 Quiz