MO-220 ยท free practice

MO-220 Excel for Accounting Practice Test

Clean ledgers, trial balances, reconciliations and financial statements. Try three real practice questions below, then get the full 7-day course.

MO-220, Excel for Accounting Associate (Microsoft 365 Apps). Performance-based tasks in Excel. Skill areas: prepare accounting data, prepare a trial balance, prepare and analyze financial statements, perform routine accounting activities.

Practice questions

Monthly payment on a loan.
  1. PMT
  2. NPER
  3. SLN
  4. SUMIFS

PMT returns the payment.

Format that lines up $ at the left of the cell.
  1. Accounting
  2. Currency
  3. General
  4. Percentage

Accounting format.

A check you wrote hasn't cleared the bank.
  1. Outstanding check: subtract from the bank balance
  2. Add to the book balance
  3. Ignore it
  4. Deposit in transit

Outstanding checks lower the adjusted bank balance.

The 7-day plan

  1. Clean accounting data
  2. Organize the ledger
  3. Trial balance
  4. Reconciliations
  5. Financial statements
  6. Routine accounting tasks
  7. Review & mock

Every day has a visual lesson, an instant-graded check and smart review of anything you miss. It ends with a timed mock exam that draws new questions every time.

Get the full MO-220 course