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.

Answer 1

To compare the two spreadsheets, Mr. Prasanna should follow these steps in LibreOffice Calc:

1. Open the original billing file, Bill.ods.
2. Navigate to the Edit menu, select Track Changes, and then click on Compare Document.
3. Select the reviewed file, Rev_Bill.ods, from the file dialogue and click Open.
4. A dialogue box will appear, highlighting all differences between the two versions for easy identification, allowing him to accept or reject changes.