Start free

Interview quiz track

First 2 free Intermediate Excel

Excel – Dynamic Arrays

Practice Excel dynamic array interview questions covering FILTER, SORT, UNIQUE, and spill ranges. Answer questions and receive feedback on correctness and approach. Ideal for data analyst interview prep. First 2 questions are free with full feedback.

  • Level Intermediate
  • Questions 12
  • dynamic arrays

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 – dynamic arrays 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 a dynamic array?

    What a strong answer includes

    Formula that returns multiple values that spill.

  2. What does the FILTER function do?

    What a strong answer includes

    Returns rows that meet criteria.

  3. What does UNIQUE do?

    What a strong answer includes

    Returns distinct values.

  4. What does SORT do?

    What a strong answer includes

    Sorts a range or array.

  5. What is a spill range?

    What a strong answer includes

    The cells a dynamic array fills.

  6. How do you combine FILTER and SORT?

    What a strong answer includes

    Nests them.