Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up

What is the main advantage of formatting a range as an Excel Table with Ctrl+T?

  1. A It expands automatically so formulas, charts and PivotTable ranges include new rows
  2. B It makes the file smaller
  3. C It prevents editing
  4. 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.

All Microsoft excel MCQs

Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up as