What condition must be met for component worksheets to utilize custom sort orders in merging records?

• A. Each worksheet can have a different sort order
• B. All must agree on the same sort order
• C. At least two worksheets must have the same sort order
• D. Sort orders are irrelevant for merging

Answer: (B)

For component worksheets to effectively utilize custom sort orders in merging records, it is essential that all worksheets agree on the same sort order. This uniformity ensures that when records are merged, they align correctly according to the predefined custom sort. If each worksheet had a different sort order, it could lead to inconsistencies and inaccuracies in the merged data, as the records would not correspond properly with one another, negating the benefits of the custom sorting.

Having all worksheets agree on the same sort order also streamlines the merging process and enhances data integrity, allowing for reliable output where records are accurately combined based on the specified custom criteria.