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.

Maxine Giza, Content strategist

Published: 09 Aug 2016

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

Test your knowledge of Windows Server 2016 licensing Think you know everything you need to know about Windows Server 2016 licensing? Put your knowledge to the test with this quiz.

Panning for gold - the data we know and use and the data we don't This is a guest blogpost by Matt Davies, technical evangelist, SplunkThey say you don't know what you don't know. It's the same with your data. Most organisations have data they know about, collect ...

What to include in an Exchange lab to test patches A test lab isn't any good unless you know what to include. This checklist gives you the basics any admin should know to set up a test environment.

Choosing among VDI vendors: Know your needs There are many VDI vendors and products to pick from, so it's important to know what you need before you settle on which provider you want to use.

Building a bona fide business intelligence platform How do you launch a BI platform that increases BI experts six-fold? Admit you know less about your data than you think.

Evapordation I don't know how many other people experience it but there's plenty of times I've gone to find data and it's vanished, disappeared, gone. You know where you saved it, know where you put it but it ...

Maxine Giza asks:

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

Join the Discussion

SearchOracle

Join the conversation

3 comments

Send me notifications when other members comment.

Oldest

[-]

Maxine Giza - 9 Aug 2016 6:25 AM

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

jason00zero - 22 Feb 2017 4:06 PM

QUESTION 4

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.

Maxine Giza - 22 Feb 2017 4:53 PM

Thank you jason00zero for calling this to our attention!

Essential Guide

Do you know the basics of using Excel for accounting?