Goal Seek

8 Questions | Total Attempts: 446

Settings
Please wait...
Excel Quizzes & Trivia

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