Explain the use of data analytics in auditing

Assignment Help 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

Reviews

Write a Review

Auditing Questions & Answers

  Internal audit

Describe and evaluate this type of internal audit. What types of organisation would it be most useful for?

  Accounting professional and ethical standards

Code of Ethics for Professional Accountants

  Prepare swag''s consolidated balance sheet

Prepare Swag's consolidated balance sheet

  Auditing and assurance

Notable operational challenges for 4X Heavy Ltd faced in 2012/2013 were but not limited to

  State of the company’s industry and associated risk factors

Audit partner is concerned about his lack of knowledge of the industry the company is operating in, state of the company's industry and associated risk factors

  Prepare a memo to the audit partner

Prepare a memo to the audit partner on the ‘state of the company's industry' and associated risk factors.

  Adjusting or non- adjusting events

State whether Event is adjusting or non-adjusting event.

  Audit financial data

As a consequence an accounts payable clerk and financial accountant were made redundant from the business during the year.

  Identify principal audit risk

To identify principal audit risk and corresponding audit procedures

  Auditing and assurance

Show the audit inherent risk and rate the risk as low, medium or high.

  National health reform

Explain the role of the following three 'bodies' in National Health Reform

  Prepare a memo on the state of the company''s industry

Prepare a memo on the 'state of the company's industry' and associated risk factors.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd