This content is part of the Essential Guide: A guide to using Excel as financial accounting software
Get started Bring yourself up to speed with our introductory content.

Do you know the basics of using Excel for accounting?

Performing accounting in Excel can be a breeze if you know key commands and shortcuts. Take our quiz to see if you know the basics.

From the days of the abacus to the introduction of the calculator, technology has turned numbers into information more quickly. In this effort, Microsoft Excel has long been a favorite.

With the advent of financial accounting software, however, using Excel for accounting and finance may be falling out of vogue. Yet that doesn't mean the tried and true electronic spreadsheet is obsolete. From graph features to ease of use, there are still a lot of features that make using Excel for accounting the best option for some organizations.

Do you know some of the basic features to use Excel for accounting purposes? Take our brief quiz to find out!

Next Steps

Why you may want to use Alt + Enter instead of Wrap Text

How the IF statement in Excel could save you money

Discover how to find the largest number in a spreadsheet using the LARGE function

Dig Deeper on ERP accounting software

Join the conversation


Send me notifications when other members comment.

Please create a username to comment.

What pros and cons have you found to using Excel for accounting purposes?


This doesn't make sense....

Which of the following commands allows users to close the selected Excel workbook window?

  • Ctrl + C
  • Ctrl + F2
  • Ctrl + K
  • Ctrl + Shift + %

YOUR ANSWER - undefined
CORRECT ANSWER - Ctrl + Shift + % 

Answer: D. Ctrl + C copies selected cells. Ctrl + F2 opens print options. Ctrl + K allows users to insert a hyperlink. Ctrl + Shift + % applies the Percentage format with no decimal places.

Thank you jason00zero for calling this to our attention!