Have you ever received a spreadsheet file that asked you questions and then magically told you whether your answers were correct? They can be more than e-mail pastimes. Once you understand how those spreadsheet files list questions and check your answers, you can create spreadsheet files that ask your students accounting questions. All it takes is an understanding of a few simple functions within the spreadsheet, and we’re about to reveal those secrets.

They’re a lot easier to create than most people think and it only takes one simple formula to produce a scoring system that makes your quiz interactive. This means that your answers will be included in the spreadsheet, but its easy to hide the answers and password protect the spreadsheet so your students have to work to find the correct answer.

To illustrate how it works, the authors created an interactive quiz based for a principles-level accounting class. Once you understand the function, you can adapt this to your own needs by changing the headings and questions. 

This article is from the Accounting Instructors’ Report, an electronic journal that provides teaching tips and insights to those who teach accounting and other business courses.



J.A. (Jim) Connell, University of Montevallo
Elizabeth Mulig, USF St. Petersburg


Read Creating Interactive Quizzes in Excel.