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.

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

The exam is given in Excel 2007. 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.)

Information Packet

Upcoming Dates:

 Friday, January 13, 2012
4:00 - 6:00 PM
202 Luther Bonney Hall
Portland Campus

Thursday, April 5, 2012
4:30 - 6:30 PM
203 Luther Bonney Hall
Portland Campus

Friday, April 13, 2012
4:00 - 6:00 PM
202 Luther Bonney Hall
Portland Campus

Friday, August 31, 2012
4:00 - 6:00 PM
202 Luther Bonney Hall
Portland Campus

Practice Test:

Directions

Spreadsheet

This information and the practice exam can also be found on the
USM School of Business BlackBoard site:

Go to: http://www.courses.maine.edu

• Click on the Community tab
• Enter SB Central in the search box
• Click on the ORG_P_SBannouncements result from the search
• Click on the Info for Students button on the left
• The first notice is about the practice exam