Basic
| # | Problem | Worksheet | Combined | Description |
|---|---|---|---|---|
| B-2.01 | excel | Understanding the basic “tools” of accounting | ||
| B-2.02 | excel | Debit/Credit rules and normal balances | ||
| B-2.03 | excel | Basic journal entries | ||
| B-2.04 | excel | Determining the nature of transactions by examination of entries | ||
| B-2.05 | excel | Posting entries to the ledger | ||
| B-2.06 | excel | Trial balance preparation | ||
| B-2.07 | excel | The value of a chart of accounts | ||
| B-2.08 | excel | T accounts — an analytical tool | ||
| B-2.09 | excel | Understanding subsidiary ledger concepts |
Involved
| # | Problem | Worksheet | Combined | Description |
|---|---|---|---|---|
| I-2.01 | excel | Preparing journal entries, posting, and a trial balance | ||
| I-2.02 | excel | Processing transactions into financial reports | ||
| I-2.03 | excel | Team-based approach to learn about information processing | ||
| I-2.04 | excel | Comprehensive processing exercise (with beginning balances) | ||
| I-2.05 | excel | Determining missing values from a limited information set | ||
| I-2.06 | excel | Evaluation of errors and corrections | ||
| I-2.07 | excel | Computerized processing | ||
| I-2.08 | excel | Using T-accounts to evaluate business activity |
Self-Grading
| Problem | Description | |
|---|---|---|
| 1 | excel | Self-Grading Problem |
MyExceLab
| Description | Problem | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Applying Debit/Credit Rules to Accounts | excel | |||||||||||||||
| Determining Account Balances | excel | |||||||||||||||
| Making Journal Entries | excel | |||||||||||||||
| Preparing and Posting Journal Entries | excel | |||||||||||||||
| Constructing a Trial Balance from the Ledger | excel | |||||||||||||||
| Quick Demonstration of Automatic Processing | excel |
The preceding table includes links to “Basic” and “Involved” problems. Each excel link will download the file containing a spreadsheet for the problem and a template worksheet on which you can prepare the solution electronically. If you see a light bulb icon on a worksheet, just mouse over above the icon and a comment box will appear. The comments include useful suggestions for improving your spreadsheet skills.
You may not post or redistribute, electronically or otherwise, any such solution material. Violation of this policy constitutes a copyright violation.
Alternative problems, with solutions, may be found at our partner website Bookboon. Video solutions to selected problems are available to students enrolling in the online course. The pdf version of the solutions manual also includes links to the video solutions. You can purchase the solutions manual in the bookstore.