CSCI Excel 2003 Multiple Choice

1. Which of the following enables you to calculate the input value required to yield a desired outcome result?
a. Tools, Goal seek
b. Insert, Goal seek
c. Format, Goal seek
d. Tools, Options, Goal seek
e. Data, Goal seek
   Save Answer

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
   Save Answer

3.   Which program evaluates the most efficient solutions for problems with multiple input values?
a. trial and error program
b. the Solver add-in program
c. random access selection program
d. linear regression program
e. VBA program
   Save Answer

4.   Which of the following is not a good application of the Solver add-in?
a. maximize profits
b. shift schedules for manufacturing
c. economic order quantities
d. minimize operating costs
e. all of these are good applications
   Save Answer

5.   Which of the following are valid constraints for the Solver add-in program?
a. C3>=42
b. $D$5<=$B$1
c. C6=F23
d. both A and C are correct
e. A, B, and C are all correct
   Save Answer

6.   Once you find an acceptable solution, Solver lets you create all of the following summary reports except:
a. Answer
b. Sensitivity
c. Demo
d. Limits
e. all of these reports can be created
   Save Answer

7.   Which of the following is an advantage of using Scenario Manager?
a. you can save multiple scenarios within a single workbook and then view and summarize their results at any time
b. when you select a scenario for display in the Scenario Manager dialog box, Excel 2003 instantaneously updates the current worksheet with the stored input values and outcomes
c. you can also generate a summary report that compares various scenarios
d. A and C are definite advantages of using Scenario Manager
e. A, B and C are all advantages of using Scenario Manager
   Save Answer

8.   Which of the following commands will add a new scenario?
a. View, Scenario
b. Data, Scenario
c. Tools, Scenario
d. File, Scenario
e. Insert, Scenario
   Save Answer

9.   Which of the following functions uses a linear (straight-line) trend equation to predict future values based on existing or historical results?
a. FORECAST
b. GROWTH
c. RSQ
d. TREND
e. LINEAR
   Save Answer

10.   What is the name of the special add-in program provided by Excel 2003, which enables advanced data analysis tools for performing complex statistical and engineering calculations?
a. Analysis ToolPak
b. Analysis ToolPack
c. Analysis Tools
d. Analysis kit
e. Complex Analysis Tool kit