Start free

Interview quiz track

First 2 free Intermediate Excel

Excel – What-If Analysis

Practice Excel What-If Analysis interview questions covering Goal Seek, Data Tables, and Scenario Manager. Answer questions and receive feedback on approach and correctness. Ideal for finance and analyst interview prep. First 2 questions are free with full feedback.

  • Level Intermediate
  • Questions 12
  • what-if

Try any track free — first 2 questions include full AI feedback. Subscribe to finish the track and unlock everything. Type or speak your answer — the first 2 questions include scoring and detailed AI feedback.

Try first 2 questions free All tracks

Sample excel – what-if analysis interview questions

Preview 6 questions from this track in quiz order. In the full quiz you answer one at a time — type or speak — then get a score and feedback.

  1. What is Goal Seek?

    What a strong answer includes

    Finds the input needed to reach a target output.

  2. How do you use Goal Seek?

    What a strong answer includes

    Sets cell, target value, and changing cell.

  3. What is a Data Table?

    What a strong answer includes

    Shows how outputs change with different inputs.

  4. What is the difference between one-way and two-way Data Tables?

    What a strong answer includes

    One variable vs two.

  5. What is Scenario Manager?

    What a strong answer includes

    Saves and compares different sets of inputs.

  6. When would you use Goal Seek vs Solver?

    What a strong answer includes

    Goal Seek for one variable; Solver for more complex.