Why is cross-referencing to other source documents necessary in spreadsheets?

• A. To enhance document security
• B. To provide verification of data
• C. To increase file size
• D. To eliminate manual entry

Answer: (B)

Cross-referencing to other source documents is essential in spreadsheets because it provides verification of data. This practice ensures that the information presented in the spreadsheet is accurate and reliable by allowing users to compare and validate the figures or values against established data from other sources. Verification through cross-referencing helps to identify discrepancies, errors, or inconsistencies in the data, which is crucial for maintaining the integrity of the information, especially in complex calculations or reports. When data is supported by additional documents, users can have greater confidence in the conclusions drawn from the spreadsheet, making it a best practice in data management and analysis.

In addition, while other options may touch on aspects of document handling and efficiency, they do not directly address the primary purpose of cross-referencing, which is rooted in data verification and accuracy.