Goal Seek
8 Questions
| Total Attempts: 446
Settings
Questions and Answers
- 1.What Excel feature will tell you how to achieve your desired output?
- A.
Data Table
- B.
Data Validation
- C.
Scenarios
- D.
Goal Seek
- 2.Excel is a good application for What IF analysis. Which of the following tool help you for this?
- A.
Formula Auditing
- B.
Research
- C.
Track Change
- D.
Goal Seek
- 3.Which of the following tool you will use in Excel to see what must be the value of a cell to get required result?
- A.
Formula Auditing
- B.
Research
- C.
Track Change
- D.
Goal Seek
- 4.To apply Goal Seek command your cell pointer must be in
- A.
The Changing cell whose value you need to find
- B.
The Result Cell where formula is entered
- C.
The cell where your targeted value is entered
- D.
None of above
- 5.What feature enables you to adjust or back solve the value in a cell to reach a desired outcome in a formula?
- A.
Forcasting
- B.
Goal Seek
- C.
TrendLine
- D.
Scenario Summary
- 6.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
- 7.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
- 8.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
Back to top