Explain the use of data analytics in auditing

Reference no: EM133062901

Question 1: Explain and design substantive tests using computer assisted audit techniques (CAATs)

Question 2: Discuss the e-commerce environment and systems and their audit implications

Question 3: Explain the use of data analytics in auditing

Question 4: Understand using Power Query to import multiple excel files and XLookup to combine data sets

Question 5. Explain what generalised audit software (GAS) is, and illustrate how it can be used in substantive testing of sales/trade receivables.

Question 6. Combine the January, February and March sales reports for Thirty Fourty Co. Who was the biggest customer for the quarter?

Question 7. Use Xlookup (or V-lookup if you are using an older version of Excel) to combine the sales data with the Sales Rep data. Who were the three most successful sales reps?

Question 8. Use Xlookup (or V-lookup if you are using an older version of Excel) to combine the sales data with the orders data. Does this information make any difference to your view as to who the three most successful sales reps were for the quarter?

Reference no: EM133062901

Questions Cloud

Shortcomings of using type of technique : A study found that own-price elasticity of demand for cigarette coefficient for Florida is 0.58. The current price per pack of cigarette in Florida is $5.00.

Estimates on the number of nursing shortage : A. Use both economic and need-based approaches to calculate the nursing shortage under the current regulated wage rate. Do these two approaches yield the same e

Are abortions legal in argentina : Are their laws protecting women's rights to choose an abortion in Argentina?

Prepare a scrap or rework analysis of income effects : The phones had cost $61,000 to produce. A salvage company will buy the defective phones as scrap for $40,800. Prepare scrap or rework analysis of income effects

Explain the use of data analytics in auditing : Explain and design substantive tests using computer assisted audit techniques - Explain the use of data analytics in auditing

Define the shortages of health professionals : How the Licensure and Quality Played role in Health care Sector in UAE?

Changing meaning of possession and ownership : From the Text chapter on private property and the changing meaning of possession and ownership, respond to the following.

What is the cost of the ending work in process inventory : Cost of the units transferred out of the Milling Department $645,000. What is the cost of the ending work in process inventory of the Milling Department

Relationship between economic globalization : What are the major positions and arguments on the relationship between economic globalization on the one hand and economic growth and income inequality on the o

User Account

All Pages