If you are coWhen conducting a data audit using a PivotTable, which of the following should be identified in the underlying dataset? a. merged cell locations b. columns that contain dates c. the total number of rows in the dataset not including the title d. columns that contain repeating values e. cell locations that contain numbers and letters combinednducting a data analyIf you are conducting a data analytics project to determine if merchandise is being stolen by employees, which of the following would help establish the Analysis component of the DATA Analytics Framework? a. Establish a decision tree diagram to determine the decision outcomes of the project. b. Evaluate the timing of the company's process. c. Conduct a data audit before addressing how the data should be analyzed. d. Determine the data that should be acquired to inform the decision outcomes for the project. e. After reviewing the company's process, develop scenarios as to how employees might steal merchandise.tics project to determine if merchandise is being stolen by employees, which of the following would help establish the Analysis component of the DATA Analytics Framework