Question

determining difference of displayed result and formula
what is the difference between a displayed result and a formula?
the displayed result is always the same number, but the formula changes.
the formula is always the same as the displayed result; it will always be a simple value.
the displayed result changes as the formula dictates it; it may not be a simple value.
the displayed result and the formula are unrelated.

Explanation:

To solve this, we analyze each option:

• First option: Displayed results can change (e.g., in dynamic calculations), so this is wrong.
• Second option: A formula is a set of instructions/operations, not the same as a simple result value, so incorrect.
• Third option: A formula dictates how to calculate, so the displayed result changes based on the formula's logic and can be complex (not just a simple value), which is correct.
• Fourth option: Formulas generate displayed results, so they are related, making this wrong.

Answer:

C. The displayed result changes as the formula dictates it; it may not be a simple value.