ACG5637 Final Exam Answer Key
Integrating Spreadsheet Engineering in a Management Science Course: A Hierarchical Approach
Integrating Spreadsheet Engineering in a
Management Science Course: A Hierarchical
Thomas A. Grossman
School of Business And Management
This workbook reviews the concepts of Relative Addressing, Absolute
Addressing, and Mixed Addressing. It is provided for your consideration
and convenience, and will not be used in class.
Reference for further consideration: NP Excel 2013 Tutorial 3, pp.
Schedule (Extended Syllabus Page 4)
Examples of Charts
Graphic taken from an
online course in Excel
Point out various characteristics of the three types of charts illustrated above.
Data Markers (icons representing data value
Sampling for Tests of Controls
Note: Link to music preferences
Audit testing a bit of reality
How many transaction a day?
in a week?
in a Month?
in a Year?
What is Audit Sampling?
Completing the Audit
End of Field
3. Audit Adjustments
4. Audit Documentation
Release of Financial
Sampling for Substantive Tests of
Concepts in TOC & TOB
What concepts are common to both?
Desired confidence level (chosen)
Tolerable error (materiality-based)
Sample size selection
Sampling risk, type I & type II errors
What is the Revenue Cycle?
Accounting Cycle: set of accounts that go
together in an accounting system
Revenue and Collection Cycle
Acquisition and Expenditure Cycle
Finance and Investment Cycle
ACG5637 Auditing I
DO NOT TURN THE PAGE UNTIL YOU ARE INSTRUCTED TO DO SO. The Final Exam is
worth 200 points. There are 40 questions, and each question is worth 5 points. Please read each
question carefully and select the opt