Excel Competency Test

• Download a PDF of this assignment description

Exercise Description

The Excel Competency exercise is designed to help instructors determine each student’s current level of experience in Microsoft Excel. Students pay $9.95 for the exercise and use Microsoft Excel to respond to 50 questions covering:

 

12 Keyboard shortcuts 30 Worksheet Functions
Absolute Reference AND MID
Bold AVERAGE MIN
Comma Style CORREL NOT
Copy COUNTBLANK NOW
Edit Formula COUNTIF NPV
Existing Values list COUNTIFS OR
New Workbook FIND PMT
New Worksheet FV PROPER
Repeat Action HLOOKUP RIGHT
Select Entire List shortcut IF ROUND
Underline IFERROR SUM
Undo Action INDEX/MATCHs SUMIF
LEFT SUMPRODUCT
LOWER VLOOKUP
MAX
5 Techniques 4 Excel Features
Absolute references in formulas Advanced Filter feature
Concatenation Display Formulas feature
Copying Visible Cells Pivot Tables feature
Nested IF function Trace Dependents feature
Paste Special Values

 

Each student is assigned a unique 4-digit number known as their Spreadsheet ID for use during the exercise. This ID number is incorporated several times into the exercise and helps ensure that each student turns in their own work:

  • Completion: This score indicates if the student attempted a given step or marked it “Don’t know”.
  • Accuracy: This score indicates carried out the step accurately, marking “Don’t know” results in a zero on accuracy.

Within one week of an assignment’s due date we provide instructors with a spreadsheet showing all student results. Partial credit in our scoring is given if a student at least attempts a step. Instructors determine final credit for each student, and whether late submissions are allowed. Students receive written feedback confirming which steps were completed successfully, as well as providing guidance on steps that they did not attempt or did not complete correctly.

 

Please direct questions to David Ringstrom (david@studentsxl.com) or 404-784-0275. Learn more about us at www.studentsxl.com.