Question

Mr. Prasanna, a General Manager in a multinational company, has been given two spreadsheets: an original billing file Bill.ods and a reviewed version of the same spreadsheet Rev Bill.ods. Both contain customer billing details prepared by different teams. Write the steps he should follow to compare these worksheets and identify the differences between them.

Hint:

For complex comparisons, use specialized spreadsheet tools like Excel's "Inquire" add-in or third-party comparison tools to save time and ensure accuracy.

Answer 1

Step 1: Open Both Spreadsheet Files.
First, Mr. Prasanna should open the spreadsheet software (such as LibreOffice Calc) and load both files — Bill.ods and Rev Bill.ods. Ensure that both worksheets are accessible for comparison.

Step 2: Use the Compare Document Option.
In LibreOffice Calc, go to the Edit menu and select Track Changes, then click on Compare Document. This option allows comparison of the current spreadsheet with another version.

Step 3: Select the File to Compare.
A dialog box will appear asking to choose the file for comparison. Mr. Prasanna should select Rev Bill.ods (or the other file as required) and click Open. The system will automatically compare both documents.

Step 4: Review the Highlighted Differences.
After comparison, the changes between the two spreadsheets will be highlighted. Inserted, deleted, or modified data will be marked for easy identification. He can review each change carefully.

Step 5: Manage or Accept Changes.
To examine the changes in detail, he can go to Edit → Track Changes → Manage. From there, he can accept or reject specific changes after verifying them.

Conclusion.
By using the Compare Document and Track Changes features, Mr. Prasanna can efficiently identify and review all differences between the original and revised billing spreadsheets.