Business K201 Waiver Exam

Test out of K201

Business majors with extensive knowledge of computer concepts, databases, and spreadsheets may choose to take the Computer in Business (K201) waiver exam.

Passing the waiver exam means you will be waived the requirement of taking K201. You will not receive credit for the course, but will be able to choose another business course to meet your overall required credits for the Kelley School of Business major. 

You may take the K201 waiver exam only one time. If you do not pass, you'll be required to take K201 for the business major.

If you have questions about the exam or your results, please contact the K201 Course Coordinator, Melissa Nemeth, at 317-274-9836 or

Topics on this exam

The goal of K201 is to use computer skills to solve a variety of business problems. The two-hour waiver exam consists of hands-on exercises in Microsoft Excel and Access, as well as multiple choice and true/false questions.

You must pass all three sections of the exam:

  • Internet
  • Applications software
  • Systems software
  • Looking at computer parts
  • Input, output, and storage
  • Networks and security
  • Database management
  • Mobile computing
  • Cloud computing
  • Designing and maintaining tables
  • Queries, including pattern match, list of values, and/or, parameter, calculated fields, and aggregate functions
  • Forms and reports, including custom and design view settings
  • Formulas and functions, such as SUM, AVG, MAX, MIN, IF, PMT, SUMIF, COUNTIF, and VLOOKUP
  • Charting, sparklines, and pivot tables with slicer
  • Sorting and filtering lists, conditional formatting, and subtotals
  • Multiple worksheets, linking and drilling formulas
  • Recording simple macros and creating a button
  • Naming ranges
  • One-variable and two-variable data tables
  • Scenarios
  • Goal seek and solver

Step 1: Schedule your waiver exam

You can schedule your waiver exam during any of these days and times:

  • Monday 8:30 a.m. to 4:30 p.m.
  • Tuesday 8:30 a.m. to 4:30 p.m.
  • Wednesday 8:30 a.m. to 4:30 p.m.
  • Thursday 8:30 a.m. to 4:30 p.m.
  • Friday 8:30 a.m. to 4:30 p.m.

Waiver exams are offered in the Business Building (BS3000).

Schedule your waiver exam

Step 2: Pay your testing fees

The cost to take the K201 waiver exam is $25. 

Pay the testing fee