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

1
Solver is a tool used to perform what-if analysis to determine the effect of changing values in two or more cells, called the target cells, on another cell, called the adjustable cell.
A)True
B)False
2
Excel includes two levels of protection: worksheet protection and workbook protection.
A)True
B)False
3
Tiled windows are displayed one above the other.
A)True
B)False
4
A link, also called an external reference, creates a connection between files that automatically updates the linked data in one file whenever the data in the other file changes.
A)True
B)False
5
Scenarios are designed to help forecast the outcome of various possible actions.
A)True
B)False
6
Which of the following is not one of the reports produced by the Solver tool?
A)Answer
B)Sensitivity
C)Relevance
D)Limits
7
_____ templates are specialized template files containing settings that are used as a pattern for creating similar worksheets in new workbooks.
A)Custom
B)Default
C)Loaded
D)Form
8
Strong passwords combine uppercase and lowercase letters, numbers, and symbols and are at least _____ characters in length.
A)4
B)8
C)16
D)32
9
Which of the following is a valid external reference formula?
A)=<2008 Forecast>Fourth Quarter!$D$8
B)=[2008 Forecast]Fourth Quarter!$D$8
C)=[2008 Forecast]Fourth Quarter!$D$8
D)=[2008 Forecast]!Fourth Quarter!$D$8
10
Which of the following SmartArt types shows areas of overlap between and among elements?
A)List
B)Process
C)Matrix
D)Cycle





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


Microsoft Office 2007 SeriesOnline Learning Center

Home > Excel > Lab 4: Using Solver, Creating > Multiple Choice Quiz