Question

Jason is working on a project that requires him to manage a huge amount of data. The spreadsheet he is working on has data related to the
official budget from cell A1 through C9, and data related to actual expenditures from cell L1 through N19. How will Jason track and compare the
data as he works on the spreadsheet?

Answer 1

Answer:

By using various tools.

Explanation:

You can compare excel files and data using different tools which are available online and even in your local files. Listed below are the ways and procedure for you to compare data in excel:

1. By using Microsoft Word  

Procedure :  

1.1 Select cells with the data that you want to compare. Copy them or simply press Ctrl key and C key and paste in on a blank word document. Remember to select only the data that you need to compare not the whole worksheet at it may cause the document to load slower.

1.2 You should have two files. Old.doc which contains the old documents and New.doc which contains the changes that you have made on the previous document.

1.3 Using Microsoft Word, Go to Tools, then Track Changes then select Compare documents.

1.4 You can now view the changes from the old to new document

2. Using Microsoft Excel itself

Procedure:

2.1 Paste the old texts and contents in Cell A1.

2.2 Paste the new texts and contents in Cell B1.

2.3 In Cell C1, use the formula =IF(A1=B1,"","!")

2.4 Double click on the ,,+" when t shows in cell C1

2.5 You can now see the two different versions of the texts.

3. You can use online tools which are available via search engines.