Office of Academic Assessment

Computer Proficiency Exam

Computer Proficiency Exam Registration Information

If you wish to take the exam, you must register (form below) in advance and pay the $15 fee. If you cancel your exam this is a non-refundable fee. Please drop off your registration form in the mailbox outside of Room 240 Luther Bonney Hall.

There is no credit given for this exam; it is simply a way of avoiding taking ABU190 (BUS 195) if you already have a mastery of spreadsheets.

The exam is given in Microsoft Office (Excel) 2016. There is a sample exam available from the School of Business.

The exam just covers spreadsheets.

The exam is much like the practice exam, but presents a different problem.

There are a number of make or break issues on this exam (they all must be done correctly to receive a passing grade):

  1. You must possess basic charting skills. The chart you create must have all the key elements.

  2. You must know the basic set of functions and how to use them, including: SUM, AVERAGE, MIN, MAX, COUNT and IF

  3. You must not use numbers in your formulas. Rather, in your formulas you must reference the cells which contain the necessary values.

  4. All formulas must be written so that they can be copied to the other related cells. To do this effectively and consistently, you must understand whether to use absolute or relative addressing. (Absolute addressing uses a $ before the column and/or row in the cell references within the formula.)

  5. Use functions where appropriate.

In general you should also be capable of all basic spreadsheet skills such as formatting. Minor mistakes in areas other than the above first 4 items will not result in a failing grade.


Registration Form
(Fill in and print out. Submit with payment for exam.)

 Upcoming Exam Dates:

Friday, Apr 7, 2017 4:30-6:30 PM  Room 202 Luther Bonney Hall, Portland Campus

Wednesday, Aug 23, 2017 4:30-6:30 PM  Room 202 Luther Bonney Hall, Portland Campus



Practice Test:


Practice Handouts


This information and the practice exam can also be found on the
USM School of Business BlackBoard site, which you can only access if you are already a USM student:

Go to:

and log in

  • Click on the Community tab
  • Enter SB Central in the search box
  • Hover on the ORG_P_SBannouncements result from the search
  • Click the dropdown arrow and click on Enroll
  • Click on the Submit button
  • Click on the OK button
  • You now have access to SB Central
  • Click on the Info for Students button on the left
  • The first notice is about the practice exam