Debits and Credits—Balance Sheet Accounts

This assignment will give you practice with debits and credits. Specifically, you will practice your skills with using debits and credits to increase or decrease account balances. This assignment focuses on accounts that you learn early in the semester, prior to learning more complex accounts relating to the income statement, bonds, depreciation, and so forth.

Relevant Excel Functions

This assignment will require you to be able to use some or all of the following Excel functions. Click on the hyperlinked section number next to the relevant Excel skill to be directed to a page showing how to perform the assigned task in Excel:

• Drop-Down Lists (1.10)

• Conditional Formatting (1.6)