Microsoft Excel is a versatile program capable of many tasks. Data management, charts, and reports are commonly created using the program. But Excel's tool set extends to a wide variety of applications, limited only by creativity. The combination of formulas, graphics control, and integrated Visual Basic programming make the program suited to games.
It is possible to build engaging applications in Excel using nothing more than its built-in conditional formulas. In particular, the "If" statement allows for considerable interactivity when used with trivia-like questions. The program can track a user's answers and offer the percentage of accuracy in her responses. In this way, a game in this design could even be used as a fun productivity tool to measure an employee's knowledge on a certain subject.
The concept is simple. The Excel spreadsheet contains a series of questions. On a separate sheet, or in a separate column, the answers to these questions are listed. To prevent the user from seeing the answers, the cells containing their text can be hidden by using the security features of the program. The Protection area of each Format Cells dialog box for the answer cells can be set in combination with the overall sheet security settings provided in the Tools menu.
Each question contains three cells: the question itself, a cell for the user's answer, and an adjacent formula cell to compare her response to the correct answer. The comparison cell contains a simple "If" formula to determine if the response cell is identical to the answer cell noted elsewhere in the document. The outcome of the "If" statement can either be "Correct!" or "Wrong!" or whatever the creator wishes. A series of trivia questions or other humorous applications can be implemented in this strategy to create a fun text-based game.
More aggressive gaming applications can be built in Excel using the Visual Basic programming language. This extends Excel's functionality in many exciting directions. The contents and colors displayed in cells can change on-the-fly, based on user keystrokes or text input. Games resembling the popular Minesweeper program are possible, as well as mazes (See References 1 and 2). The best way to understand the structure of this style of gaming is to view the Visual Basic code of games already written. GameDev.net and Pearson Software Consulting both offer free Excel downloads with open source code for their games.
- Photo Credit Jupiterimages/Pixland/Getty Images
How to Find the Hidden Game in Excel 2000
So-called "Easter eggs," or mini-programs hidden inside software applications, are a time-honored tradition among software developers. Often, they simply list the names...
How to Make Excel Games
Although Microsoft Excel is primarily used for business applications, it can also be used to make games. All you need to make...
How to Get Games in Excel Including Sonic
Excel is a Microsoft software program that manages, analyzes and alters spreadsheet documents. Although traditionally used for business and financial information, Excel...
Shortcut to Swap Sheets in Excel
If you enjoy working in Microsoft's Excel spreadsheet program, then you can organize your data and switch between different worksheets using a...
Excel Programming Tutorial
Excel is a spreadsheet program developed by Microsoft. Over 100 functions are available to program Excel spreadsheets. The functions cover many financial...