Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Microsoft I ExceI Open the Audit Automation Summary.xlsx you created in Part 1 . Evaluate the potential to automate the specific rules: a . Add
Microsoft I ExceI
Open the Audit Automation Summary.xlsx you created in Part
Evaluate the potential to automate the specific rules:
a Add two new columns:
b For each element and rule you identified in Part determine whether it requires manual review or can be performed
automatically and alert auditors when exceptions occur. Add either Auto or Manual to that column.
c Finally, determine how frequently the data should be evaluated. Indicate Daily, Weekly, Monthly, Annually, or During Audit.
Think about when the data are being generated. For example, transactions occur every day, but new employees are added every
few months.
d Take a screenshot label it of the All tables sheet.
When you are finished answering the lab questions, you may save and close your file.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started