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



1

What are assumptions known as in a worksheet?
A)input cells
B)variables
C)output cells
D)both A and B are correct
E)A, B, and C are all correct
2

Which of the following belong in the Goal Seek dialog box?
A)By changing cell
B)To value
C)Set cell
D)both A and C are correct
E)A, B, and C are all correct
3

In the Solver Parameters dialog box, which location contains the Outcome cell containing the formula to optimize?
A)Subject to the Constraints
B)Equal To
C)Decimals
D)By Changing Cells
E)Set Target Cell
4

What makes the final summary reports generated by the Scenario Manager easier to read?
A)formatting all cells to two decimals
B)naming the input cells
C)formatting all labels the same width
D)assigning range names
E)assigning scenario names
5

Which of the following is the correct FORECAST function?
A)new-x, y-set, x-set
B)y-set, x-set, new-x, constant
C)y-set, x-set
D)x-set, y-set, new-x, constant
E)new-y, x-set, y-set







Office 2003 Advantage SeriesOnline Learning Center

Home > Excel 2 > Chapter 9 > Multiple Choice Quiz