What is the main advantage of formatting a range as an Excel Table with Ctrl+T?
- A It expands automatically so formulas, charts and PivotTable ranges include new rows
- B It makes the file smaller
- C It prevents editing
- D It sorts the data permanently
Answer
It expands automatically so formulas, charts and PivotTable ranges include new rows
Automatic expansion eliminates the common error where a report silently misses the most recently added rows.





