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 recommended way to structure a model that others will use?

  1. A Separate inputs, calculations and outputs, with hard-coded inputs clearly marked
  2. B Put everything on one sheet
  3. C Hide all formulas
  4. D Use merged cells for headings
Answer

Separate inputs, calculations and outputs, with hard-coded inputs clearly marked

A consistent convention, such as blue for inputs and black for formulas, lets any reviewer see immediately where a number comes from.

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