Question: Problem 3 With the Travel Report file open and visible. on the Analysis tab in the Categorize group use the Summarization tool to create a

Problem 3 With the Travel Report file open andProblem 3 With the Travel Report file open andProblem 3 With the Travel Report file open and
Problem 3 With the Travel Report file open and visible. on the Analysis tab in the Categorize group use the Summarization tool to create a summarized table of Amount by PIN. Check the Use Quick Summarization and Create database boxes. Enter PIN Summary for the File Name. In the Summarization Results window. how many records are associated with PIN 12205605? To clear the result, close the Pin Summary worksheet. Problem 4 An audit procedure that is useful for identifying potential risks is to scan transactions for large and/or unusual items. IDEA can help with such a procedure by expediting the scanning process. especially when the database of transactions 1s large. With the Travel Report file open and visible. on the Analysis tab go to the Categorize group and select Stratification to open the Stratification window (click NO when asked 1if you wish to create statistics for fields without statistics). Select AMIOUNT under Fields to stratify and Fields to total on. Set the >= Lower Limit to O (if 1t isn't already). and set the Increment at 2.000. Click in the first cell in the

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!