What allows customization of data in each worksheet of a workbook?

• A. Scenario comparisons
• B. Workbook variables
• C. Multi-user support
• D. Currency specification

Answer: (B)

Workbook variables play a crucial role in customizing data within each worksheet of a workbook. They allow users to define and store specific values that can be referenced or used throughout the workbook, enabling adjustments that can impact calculations and data representation. For instance, a workbook variable can hold a particular constraint, threshold, or parameter that is relevant to the specific context of the data being analyzed in that worksheet. This flexibility enhances the ability to tailor the information displayed in each sheet based on varying needs or scenarios, leading to a more dynamic and responsive model.

In contrast, the other options each serve different purposes. Scenario comparisons focus on evaluating various potential outcomes within the data but do not directly allow for personalized data input in each worksheet. Multi-user support facilitates collaboration among users working on the same workbook but is not inherently related to the customization of data. Currency specification indicates the format in which monetary values are displayed, which is important for clarity but is a separate function from the broader customization capabilities provided by workbook variables.