Simon Is Having Trouble Using Linked Workbooks, So He Consults

question 54

Multiple Choice

Simon is having trouble using linked workbooks, so he consults his colleague Brooke for help.
-Finally,Simon asks Brooke what steps (if any) need to be taken to keep a destination file up-to-date if he updates a value in one of the source files.Which of the following statements by Brooke would be correct?

• A)If a destination file is open when a source file is changed, the destination file will be updated automatically.
• B)Source files cannot be updated unless the corresponding destination file is open.
• C)It is not possible to choose whether a destination file should reflect changes made to the source files.
• D)If a destination file is open when a source file is changed, you need to update the destination file manually so that it reflects the changes.

---

Definitions:

Long Run

The time period in economics during which all inputs or factors of production can be adjusted or changed, contrary to the short run where some inputs are fixed.

Long-Run Average Total Cost Curve

A graphical representation illustrating the per unit cost of producing a good or service in the long run, when all inputs are variable.

Fixed Cost

Expenses that do not change with the level of output or sales in the short term, such as rent, salaries, and insurance.

Output

The total amount of goods or services produced by a company, industry, or economy over a certain period.