Intermediate Accounting II

Computerized Auditing Using ACL Chapter 2: 1. 42 2. 1420 3. 179, WorkDept, character, 3 4. Salary is currency and needs dollars and cents employee number are whole numbers 5. Opens different parts of projects and allows you to view the log. 6. n/a 7. n/a 9. 92,698 Chapter 3: 1. No 2. Right click on a column choose add columns make sure they are all there. 3. The filter key that has an x on it. 4. 000170 and 200170 5. 000290 6. 13 Computed Fields 1. Invoices that don’t match product orders, paychecks that don’t match amount worked 2. 27 3. Good estimate of collectability of debt. Verify Commands 1. Investigate Count Command 1. 7 2. 9.99 3. The little left arrow on the upper left corner Total Command 1. Purchase order 2. 1.469.13 3. Total of the purchase orders 4. 3 Statistics command 1. Quick count or verify of records 2. 2095.61 3. Compare average to amount to make sure there are not outliers. 4. 2187.50 Sequence Command 1. 5 errors 2. 12893, 12930, 12993, 13093, 13193 3. Missing records could be fraudulent. Duplicates command 1. 22 2. Yes Gaps Command 1. 12 gaps Extract Command 1. 2625.47 2. 3748.60 3. Inventory List Sort Command 1. 2. 00010 3. Gross=73,152.96 Net=58,522.42 4. Length=11 Decimals=2 Type=Numeric Chapter 4: Classify Command 1. 4 2. 3 Summarize Command 1. 37 2. Location 01 Product class 02 Cross-tabulate Practice 1. 7 2. 7 3. 2 4. True 5. Much easier to read in summarize, better organized as well 6. Summarize, easier to read 7. The 1st cross-tabulate, better organized 8. Less information to take in. Stratify Command 1. Only chooses them in a certain range. 2. 10 3. 11 4. 4088 5. Sort by descending 6. 3234.91 7. Statistics 8. 3500-4500 has 0 records 9. Greater than 4500 has 27,511.99 10. Look for outliers Age Command 1. 59,411.84 2. Large amount of probable uncollectible debt. 3. 172 4. 5970.40 5. 2 6. 15,444.80 7. 08 8. 3 9. See what type of product is being purchased by those likely to not pay. Chapter 5: Sample Command 1. Because they were monetary units. 2. 140,417.97 Sample Size=4 3. 10 4. Largest=95,891.01 Smallest=1013.49 5. Give out the customer number list. Record Sampling 1. The items selected would change but the number of them would remain the same. 2. 126 3. 73,714.97 Join Command 1. ID_NUM 2. A. unmatched primary records B. matched primary records C. matched primary records D. matched primary records E. matched primary records 3. 1. Yes 2. empmast and payroll 3. EmpNo 4. 6 5. No 6. Yes then No 4. matched primary 5. Employee number and gross pay

Courses in ACCT

Popular Documents from University of North Carolina Wilmington

University of North Carolina Wilmington