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:

Flexible Work Hour Plans

Are plans in which employees usually must still work 40 hours per week and typically 5 days a week but in which they have control over the starting and ending times for work on each day.

Piece-rate Incentive Plan

A compensation system where employees are paid based on the amount of output they produce.

Merit-pay Plan

A compensation strategy that determines an employee's pay based on their performance, rewarding higher achievers with greater pay increases.

Behavior-modification Plan

A strategy used to alter an individual's behaviors through reinforcements and punishments.