How many worksheets does the disaggregation default rates function require?

• A. One
• B. Two
• C. Three
• D. Four

Answer: (B)

The disaggregation default rates function requires two worksheets to operate effectively. This is because one worksheet typically contains the source data that outlines the aggregated information, while the second worksheet serves as a template or rules sheet where the disaggregation criteria, such as the specific groups or categories for breaking down the data, are defined.

Having two distinct worksheets allows for a clear separation of data inputs and the logic or mapping needed to disaggregate the data accurately. This setup facilitates better organization and enhances the clarity of the process, ensuring that the transformation from aggregated data to more granular details can be executed smoothly and without confusion.