In the attached workbooksomeone has assembled a summary of those sales in original currency, and converted to Canadian dollars. We are being asked to audit it.

There are at least 17 different things wrong with this spreadsheet.

You are expected to find a particular weakness and solve it. If the weakness you identify is duplicated in several cells, then you should propose a solution for all the similar cells.

When you post your findings in the discussion board, you can explain what you found and how you'd solve it in text or you can post files of corrections with your findings. Whatever you think will best illustrate your solution.

a) Locate 1 error and take a screenshot of it.

b) Make changes in the file below. Take a screenshot of the correction as well.

c) Express the error in words, explain how to fix it in words.

Task: https://drive.google.com/file/d/1_-PCDH1L4DHBX8gTReyUepHtNVf8bshR/view?usp=sharing