## USM Social Dashboard »

Check out our new Social Dashboard to see other ways to stay connected across the USM community.

## Emergency Info

For campus emergencies, dial 911.

# 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.  Please bring this registration form to room 240 Luther Bonney Hall, Portland Campus.

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 2010. There is a sample exam available from the School of Business.

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, April 12, 2013
4:30 - 6:30 PM
202 Luther Bonney Hall
Portland Campus

Friday, August 30, 2013
4:30 - 6:30 PM
202 Luther Bonney Hall
Portland Campus

Practice Test:

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

• 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