In Lab 5-3, Identify Audit Data Requirements, you were a new member of the internal audit team. The chief audit executive was interested in using Data Analytics to make the audit more efficient. Your internal audit manager tasked you with reviewing the audit plan and you were provided with the procedures used to evaluate the procure-to-pay (purchasing) process. The technique involved the following (the order of events matters): Multiple Choice Identify the locations of the data, look for the audit procedures involving data, then review the audit plan to make sure the proper procedures were followed. Review the audit plan, look for procedures involving data, and identify the locations of the data. O Review the audit plan, identify the locations of the data, and look for the audit procedures involving data. In Lab 6-2, Perform Substantive Tests of Account Balances, you were an internal auditor tasked with validating the balance in accounts receivable. Your audit manager gave you a list of receivables for comparison. Additionally, company policy states that accounts receivables should be collected within 60 days of the sale. To test this policy, you were asked to perform an aging of outstanding accounts. What function in Excel was used to compute how many receivables fell within each bucket range? Multiple Choice SUM COUNTE SUMIF In Lab 6-2, Perform Substantive Tests of Account Balances, you were an internal auditor tasked with validating the balance in accounts receivable. Your audit manager gave you a list of receivables for comparison. Additionally, company policy states that accounts receivables should be collected within 60 days of the sale. To test this policy, you were asked to perform an aging of outstanding accounts. What function in Excel was used to look up the date that corresponds with the Sales Order ID that each cash receipt corresponds to. Multiple Choice IFERROR Pivot Table COUNTIF