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:

Array

A systematic arrangement of similar objects, typically in rows and columns, or a data structure in computer science that consists of a collection of elements identified by at least one index or key.

David Marr's Model

A theory in cognitive science that describes vision as proceeding from a 2D view of the world to a 3D one through a series of processing stages.

Bottom-Up Knowledge

Knowledge processing that starts with the senses and the actual perception of stimuli, moving towards higher-level cognitive functions.

Primal Sketch

A concept in visual perception that refers to the initial representation of visual information in the brain, outlining shapes and locations of objects.