The key to spreadsheet model flexibility is to keep all the ___________ of the model separate from the ______________ of the model.
A) inputs; formulas
B) inputs; outputs
C) outputs; formulas
D) constraints; formulas
E) parameters; decision variables

Question

Quizplus · Accepted Answer

Keeping the inputs (or variables) separate from the formulas (or functions) is essential for making a flexible spreadsheet model. Inputs refer to the values that the user can change or manipulate, while formulas refer to the calculations or operations that are applied to these inputs to produce the desired results or outputs. By separating inputs from formulas, it becomes easy to modify or update the model without affecting the underlying logic or structure. Whenever a change is made to an input, the model automatically updates the associated formulas and outputs. This helps in making quick and accurate decisions based on different scenarios or assumptions. Option B is not correct since outputs are the results or outcomes generated by the model, and they cannot be separated from the formulas. Options C, D, and E are also incorrect since constraints, parameters, and decision variables are all terms used in optimization and modeling disciplines, and do not relate directly to spreadsheet modeling.

The Key to Spreadsheet Model Flexibility Is to Keep All