You have a dynamic array formula, for example, =FILTER(A1:C10, B1:B10>10), in cell E1. If you delete a row (e.g., row 5) within the source range (A1:C10), then what is the most likely outcome?

Question

Computer Science · MS Excel

Verified Solution4 OptionsUpdated: October 2026👁️1 View

Share:

Correct answer

The formula will automatically shrink its source range to A1:C9.

Save this question and verified answer as a clean study sheet with live clickable link.

👥

Challenge your peer aspirants on WhatsApp or Telegram to solve this question!

Online Test Series

Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.

Chapter Practice

Want more practice questions on MS Excel?

Solve complete topic-wise tests with detailed solutions on GkGet.

Recommended practice questions in Computer Science · MS Excel

Mahatma Gandhi's last fast unto death in 1948 was primarily against which of the following?

What was the primary meaning of 'Swaraj' as popularized by Mahatma Gandhi during India's independence movement?

What was one major impact of India’s independence on its economy?

Answer 1

The formula will automatically shrink its source range to A1:C9.

Answer 2

The formula will not adjust, but the output will be missing the data from the deleted row.

Answer 3

The formula will return a #REF! error.

Answer 4

The formula will be deleted along with the row.

Related Practice Questions