Basic

# Problem Worksheet Combined Description
B-2.01 pdf pdf excel Understanding the basic “tools” of accounting
B-2.02 pdf pdf excel Debit/Credit rules and normal balances
B-2.03 pdf pdf excel Basic journal entries
B-2.04 pdf pdf excel Determining the nature of transactions by examination of entries
B-2.05 pdf pdf excel Posting entries to the ledger
B-2.06 pdf pdf excel Trial balance preparation
B-2.07 pdf pdf excel The value of a chart of accounts
B-2.08 pdf pdf excel T accounts — an analytical tool
B-2.09 pdf pdf excel Understanding subsidiary ledger concepts

 

Involved

# Problem Worksheet Combined Description
I-2.01 pdf pdf excel Preparing journal entries, posting, and a trial balance
I-2.02 pdf pdf excel Processing transactions into financial reports
I-2.03 pdf pdf excel Team-based approach to learn about information processing
I-2.04 pdf pdf excel Comprehensive processing exercise (with beginning balances)
I-2.05 pdf pdf excel Determining missing values from a limited information set
I-2.06 pdf pdf excel Evaluation of errors and corrections
I-2.07 pdf pdf excel Computerized processing
I-2.08 pdf pdf 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.