Using Data Analytics to Determine the Impact of Internal Control Activities DA7.2 Problem Dati visuslitation can be used toidently solutions and the impact of those solsions. Data that show intemal controis in place and the impact eath control has on teducing the cost to the orgarization of the fraud, in time and in money, are prosented hore There are four parts to this problem. Use Excel or the visualization software of your or your instructor's choice to perform the following: a. The data have been duplicated in the Student Work Area. Use conditional formatting data bars for the data in both columns. Sort this data by largest percentage reduction of time, and then as a secondary sort, by the largest percentage of loss reduction. b. Create a column chart comparing the two data items in part a, with each percentage reduction in a separate column for each control. Change the maximum bound of the percentages on the vertical axis to 60%. Include a descriptive chart title, axes labels, legend, and properly formatted axes. c. Which controls are the most effective? What control would you recommend for an organization for which you are seeking employment? d. Identify the most effective control based on both time and cost. Under which principle of control activities do you think this falls? Explain. a Conditional formattinn and data enrt