Close Menu
Login
(Sponsored by Sir Tauqeer)
Join Sir Tauqeer Whatsaap group
(Sponsored by Sir Tauqeer)
Join Sir Tauqeer Whatsaap group
(Sponsored by Sir Tauqeer)
Join Sir Tauqeer Whatsaap group
By Computer Mcqs Microsoft Excel Mcqs PAST PAPERS PPSC Canal Patwari Past Papers 2023 MCQs PPSC PAST PAPERS No Comments

In Excel, which is used to perform what if analysis?

A. Goal seek
B. Solver
C. Scenario Manager
D. All of above

Submitted by: Areesha Khan

Advertisement

All three tools in Excel are used for What-If Analysis:

Goal Seek – Helps find the required input value to achieve a specific result.
Solver – A more advanced tool that optimizes multiple variables based on constraints.
Scenario Manager – Allows users to create and compare different data scenarios.

Related Mcqs:

  1. In Excel which key is used to open the excel formula window?
    A. Shift+F6 B. Shift+F3 C. Alt+Shift+F3 D. Alt+Shift+F6 Submitted by: Muhammad Danish...
  2. In Ms Excel Ready made templates are available under _______ tab ?
    A. File B. Insert C. Design D. None of Above Submitted by: Ali Mallah...
  3. ________________________ is not a valid data type in excel?
    A. Number B. Label C. Character D. none...
  4. How do you display current date and time in MS Excel ?
    A. Date() B. Year() C. Now() D. Time() Submitted by: Areesha Khan...
  5. Which shortcut key is used to create chart in MS Excel?
    A. F10 B. F12 C. F11 D. None Submitted by: Areesha Khan...
  6. What is the use of a horizontal Scroll Bar in MS Excel?
    A. to view the data from left to the right B. to view the data in Excel from up and down C. to view the data from right to the left D. None of these Submitted by: Areesha Khan...
  7. Letters in Excel denote: ______________?
    A. Columns B. rows C. numbers D. reference Submitted by: Areesha Khan...
  8. MS Excel is based on: _____________?
    A. UNIX B. DOS C. WINDOWS D. OS/2 Submitted by: Areesha Khan...
  9. Another name for a pre programmed formula in excel is ___________?
    A. Cell B. Graph C. Function D. Range Submitted by: Areesha Khan...
  10. What does the term “filter” refer to in Excel?
    A. To permanently delete rows or columns B. To format the appearance of cells C. To temporarily hide certain data based on specific criteria D. To create a chart...
Advertisement

The correct answer to the question: "In Excel, which is used to perform what if analysis?" is "All of above".

Share.
Leave A Reply

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

The reCAPTCHA verification period has expired. Please reload the page.