MIS111-L, Case Analysis 4 Guidelines Case Analysis Overview This Case Analysis includes material from the weeks beginning Oct 28, Nov 4, 11. Please...

Explain the TRIM() and the SUBSTITUTE() functions in Excel, and the difference between them. Your explanation should include an example (e.g., from your planned major area; to demonstrate your understanding you should use an example different from the one seen in the lecture).