Scenario Manager In Excel Quiz: Test!

10 Questions | Total Attempts: 2565

SettingsSettingsSettings
Scenario Manager In Excel Quiz: Test! - Quiz

.


Questions and Answers
  • 1. 
    What term refers to a specific set of values saved with the workbook?
    • A. 

      Range

    • B. 

      Scenario

    • C. 

      Trend line

    • D. 

      What-if analysis

  • 2. 
    What is the Name of This dialog Box which is shown in this Picture?  
    • A. 

      Manager

    • B. 

      Scenario Manager

    • C. 

      Goal Seek

    • D. 

      Data Table

  • 3. 
    What tool helps you to optimize the results of a model?
    • A. 

      None of the above

    • B. 

      Target value

    • C. 

      Solver

    • D. 

      Scenario manager

  • 4. 
    You can Open the Scenario Manager Dialog Box by Choosing Scenarios from the ________ Tab of Ribbon?
    • A. 

      Insert

    • B. 

      Formulas

    • C. 

      Data

    • D. 

      View

  • 5. 
    What is the name of this button?  
    • A. 

      Office Button

    • B. 

      Play Button

    • C. 

      Scenario Button

  • 6. 
    Which option of Data Tool Group Will Give the option of Scenario Manager ?
    • A. 

      Data Validation

    • B. 

      Consolidate

    • C. 

      What-if Analysis

  • 7. 
    Scenario manager option can be found in View tab.
    • A. 

      True

    • B. 

      False

  • 8. 
    Which of the following statements about scenarios in an Excel workbook is not true?
    • A. 

      A scenario is a set of values saved with the workbook.

    • B. 

      A workbook can have one scenario per sheet.

    • C. 

      Scenarios provide a way to see different solutions for worksheet formulas.

    • D. 

      Scenarios help you in what-if analysis.

  • 9. 
    Which of the following terms describes an Excel scenario summary report?
    • A. 

      It is formatted as an outline.

    • B. 

      It creates a new workbook.

    • C. 

      It includes a color scale.

    • D. 

      It is in compatibility mode.

  • 10. 
    How many models can be made in the Scenario manager?
    • A. 

      70

    • B. 

      64

    • C. 

      50

    • D. 

      Unlimited

Back to Top Back to top