Quiz: Excel Practice Test

10 Questions | Attempts: 2781
Share

SettingsSettingsSettings
Quiz: Excel Practice Test - Quiz

Excel sheets run the business, and expertise in excel would go a long way in upscaling your career. This Excel practice test quiz gauges your practical knowledge on the subject and also provides you with valuable information that helps you gain expertise in the excel sheet. The quiz contains questions that cover easy, medium, and advanced levels. If you like the quiz, do share it with your friends and family. All the best!


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. 
    What is the group of excel sheets called?
    • A. 

      Chart

    • B. 

      Cell range

    • C. 

      Multi cell

    • D. 

      Box

  • 7. 
    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

  • 8. 
    The fill handle is located?
    • A. 

      At the beginning of formula bar?

    • B. 

      In the bottom right corner of the any selected cell

    • C. 

      On the right side of ribbon

    • D. 

      None of the above

  • 9. 
    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

  • 10. 
    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 Back to top
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.