Microsoft I ExceI

Open the Audit Automation Summary.xlsx you created in Part $1.$

Evaluate the potential to automate the specific rules:

a$.$ Add two new columns:

b$.$ For each element and rule you identified in Part $1,$ 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$.\frac{?}{\text{b}\text{a}\text{r}}(10)$ Take a screenshot $($label it $5-4MC)$ of the All tables sheet.

When you are finished answering the lab questions, you may save and close your file.