Which of the following is a substantive test in relation to completeness? a. Review for any unmatched receiving reports and suppliers' invoices. b. Review minutes and contracts for evidence of pledging of receivables, factoring or other liens. Oc. Agree dollar value of accounts payable to supporting documents (e.g. suppliers' invoices). O d. Check subsequent sales prices and compare with inventory cost. Which of the following statements is most true regarding using Microsoft Excel to analyse data? O a. The XLookup function can be used to combine data contained in two worksheets, providing that the worksheets have no common fields O b. The Pivot Table function is useful for importing multiple worksheets O c. For a Pivot Table to work most effectively, each data table cell should contain a different field O d. The most effective way to approach data analysis is to separate data tables from analysis tables Which of the following is most true in relation to general and application controls? O a. The difference between test data and an integrated test facility is that test data is run on the auditor's system where as the ITF is run on the client's system O b. If application controls turn out to be unreliable then detection risk will increase O c. General controls are more likely to be tested via inspection or observation whereas application controls are more likely to be tested via CAATS Od. A typical general control is a reasonableness input test and a typical application control is segregation of duties Which of the following statements is NOT true? 0 a. The auditor should be available to communicate their conclusions to shareholders by attending the Annual General Meeting b. The auditor should seek a letter from the client's lawyers outlining any significant legal matters as part of audit completion procedures O c. Analytical review should be used as part of the audit procedures in the completion phase of the audit Od. The management representation letter is when the auditor communicates to management key recommendations arising from the audit