1
AssignmentMultiple Choice

Forecasting Data

Question 1 • TX-Business Information Management (BIM) I

What happens to a data table when the formulas or variables used to create it are changed?

Answer
A
It will update only after the file has been closed and reopened.
B
It will automatically update immediately because the formulas are linked.
C
It will be unaffected because it is separate from the formulas used to create it.
D
It will display an error because the formula cannot function until it is corrected.

Explanation

A data table is linked to the formulas and input variables used to generate its results. When those formulas or variables change, the table recalculates and updates to show the new results. So the correct choice is “It will automatically update immediately because the formulas are linked.”

AI-written and checked against the verified answer.

Next