How to calculate the input value required to yield

Assignment Help Computer Engineering

Reference no: EM1331269

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

Reference no: EM1331269

Questions Cloud

Explain e-business- the sarbanes oxley act : The Sarbanes Oxley Act (Sox) came about as a result of corporate scandals such as Enron and Worldcom. Critics say that it is burdensome for most medium sized business.

Find the best dashboard : Now that you know a bit more about all three types of dashboards, what type of dashboard do you feel is the best? Why?

Explaining affirmative action plan : Affirmative action plan that would consider gender as one component of the decision when promoting librarians. Is this affirmative action plan valid? Explain your answer.

Explain e-business and the changes in marketing strategies : Address current marketing operations and the integration of e-business Explain e-business and the changes in marketing strategies

How to calculate the input value required to yield : Which program evaluates the most important solutions for problems with multiple input values.

Explaining multilateral environmental agreements : Describe how multilateral environmental agreement (MEA) regimes develop over time.

It is mandetary that a rational customer will not purchase : It is mandetary that a rational customer will not purchase any units of the product represented by these data.

Causes of cross-cultural conflicts within organizations : Examine the roots of cross-cultural conflict in global organizations. Determine the most common causes of cross-cultural conflicts within organizations, as cited by the experts.

Illustrate what does the fundamental assumption of marginal : Illustrate what does the fundamental assumption of marginal utility theory suggest about the connection between money and happiness.

User Account

All Pages