If the function references a(n)range that grows or shrinks,Excel automatically adjusts the first argument if the table grows or shrinks._________________________

Name: If the function references a(n) range that grows or shrinks,Excel automatically adjusts the first argument if the table grows or shrinks._________________________
Brand: Quizplus
Rating: 4.7 (26 reviews)

Question

Quizplus · Accepted Answer

Excel does not automatically adjust the first argument of a function when a range grows or shrinks; users must manually update the range or use dynamic range names or tables.

If the Function References A(n)range That Grows or Shrinks,Excel Automatically