Site MapHelpFeedbackLesson 09 Quiz
Lesson 09 Quiz
(See related pages)

1
Which of the following command buttons would you click to insert an accented character such as ç in a label in an Excel worksheet?
A)Character
B)Insert
C)Symbol
D)Translate
2
Which of the following statements is true if Trust Center Settings have been set to notify you when an Excel workbook has a macro?
A)The macro is executed as the workbook opens.
B)The macro is deleted from the workbook as it is opened.
C)A security message panel opens with the workbook.
D)The Trust Center choices are listed while the workbook is opened.
3
Which of the following terms describes a setting, attribute, or data that is saved with an Excel workbook?
A)Assistant
B)Handle
C)Property
D)Resource
4
Which of the following statements about scenarios in an Excel workbook 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 you in what-if analysis.
5
Which of the following about the Research tool in Excel is true?
A)It can locate labels that sound similar to selected labels.
B)It includes links to Wikipedia pages.
C)It can list labels that are spelled with the same characters in any language.
D)It includes a thesaurus and translation dictionaries.
6
Which of the following terms describes a limitation or requirement placed on a cell value used in an Excel Solver problem?
A)Criteria
B)Constraint
C)Parameter
D)Target
7
Which of the following Excel analysis tools is best when you want to solve for one variable in a problem?
A)Goak Seek
B)Scenario
C)Trendline
D)Solver
8
If an Excel problem is to determine how many units of each of three products should be sold to reach a certain profit, which of the following tools would likely be the best choice?
A)Goal Seek
B)Scenario
C)Trendline
D)Solver
9
How can you determine if an open Excel 2010 workbook has been saved in an earlier version of Excel?
A)The title bar displays [Compatibility Mode].
B)The title bar displays [Incompatibility Mode].
C)The status bar displays Previous Version.
D)The status bar displays Update to Current Version.
10
Which of the following terms describes an Excel scenario summary report?
A)It is formatted as an outline.
B)It creates a new workbook.
C)It includes a color scale.
D)It is in compatibility mode.





To learn more about the book this website supports, please visit its Information Center.
(c)2011 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.


Hinkle, Microsoft2010 CompleteOnline Learning Center

Home > Excel > Lesson 09 Quiz