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

Why should a rate or assumption never be typed directly inside multiple formulas?

  1. A It cannot be updated reliably and creates inconsistency
  2. B It causes a circular reference
  3. C Excel does not allow constants in formulas
  4. D It slows recalculation
Answer

It cannot be updated reliably and creates inconsistency

Put the value in one labelled cell and reference it. Named ranges make the reference self-documenting as well.

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