3
AssignmentMultiple Choice

Cell and Range Names

Question 3 • GA-Business and Technology B Ammons 2025-2026

How do you access the setting that prevents Excel from automatically adding new cells to a table?

Answer
A
Click the AutoCorrect Options button.
B
Click the AutoFilter drop-down list.
C
Click and drag the new cell away from the table.
D
Click the Header & Footer tab.

Explanation

Excel’s AutoCorrect Options button provides settings related to automatic table expansion, including whether newly entered data is automatically added to a table. Click that button to access the setting and turn the behavior off. The AutoFilter drop-down filters table data, while dragging a cell or opening Header & Footer does not change this setting.

AI-written and checked against the verified answer.

Previous
Next