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 most common symptom of numbers stored as text?

  1. A SUM returns zero or ignores those cells
  2. B The cells display in red
  3. C Excel crashes
  4. D The file size increases
Answer

SUM returns zero or ignores those cells

A small green triangle usually flags it. Text to Columns with no delimiter, or the VALUE function, converts them.

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