Which must be true when appending records from one component worksheet to another?

• A. The worksheets can have different data types
• B. The worksheets must have the same number of columns
• C. The worksheets must display completely different data
• D. The worksheets can be sorted in any order

Answer: (B)

When appending records from one component worksheet to another, it is essential that the worksheets must have the same number of columns. This requirement is crucial because, in order to combine data effectively, each column in the source worksheet must have a corresponding column in the target worksheet that can correctly align the data. If the two worksheets have a different number of columns, the data would not be able to match up accurately, which could lead to data integrity issues or loss of information.

Having the same number of columns ensures that every piece of data from the appended records fits into the designated structure of the target worksheet. This alignment facilitates smoother operations when consolidating or analyzing the data, allowing for consistency and reducing the risk of errors. Thus, maintaining the same column count is a fundamental requirement when merging records from different sources.