Excel 2003 Skill Assessment
Using a scale of 1 to 5, with 5 meaning "Definitely, Yes" or "Always", and 1 meaning "No" or "Never", rate yourself for each of the following questions. 1 = No or Never, 2 = Rarely/Once, 3 = Sometimes, 4 = Regularly, 5 = Definitely, Yes or Always.
Welcome to the Excel 2003 Skill Assessment. Over the next few pages we will ask a series of questions to identify the the proper level course for your skillset.
There are 31 questions in this survey.
Basic Information
Please provide the following information:
*
Name
*
Email address:
*
Company Name:
Skill Evaluation Questions
Using a scale of 1 to 5, with 5 meaning "Definitely, Yes" or "Often", rate yourself for each of the following questions. 1 = Never; 2 = Rarely/Once; 3 = Sometimes; 4 = Regularly; 5 = Often
*
Have you ever taken an Excel class before?
Choose only one of the following
1-Never
2
3
4
5-Often
*
Can you write a simple equation?
Choose only one of the following
1-Never
2
3
4
5-Often
*
Can you use the Paste Function command to write a function?
Choose only one of the following
1-Never
2
3
4
5-Often
*
Are you able to create and use named ranges?
Choose only one of the following
1-Never
2
3
4
5-Often
*
Do you use the AutoFill feature?
Choose only one of the following
1-Never
2
3
4
5-Often
*
Are you comfortable with absolute and relative references?
Choose only one of the following
1-Never
2
3
4
5-Often
*
Can you manipulate the printouts you get in Excel?
Choose only one of the following
1-Never
2
3
4
5-Often
*
Can you select adjacent and non-adjacent cells?
Choose only one of the following
1-Never
2
3
4
5-Often
*
Can you Freeze and Unfreeze Rows and Columns?
Choose only one of the following
1-Never
2
3
4
5-Often
*
Can you hide and unhide Worksheets?
Choose only one of the following
1-Never
2
3
4
5-Often
*
Can you create simple charts?
Choose only one of the following
1-Never
2
3
4
5-Often
*
Are you able to customize your chart features?
Choose only one of the following
1-Never
2
3
4
5-Often
*
Have you ever exported Excel data or imported data into Excel from the Web?
Choose only one of the following
1-Never
2
3
4
5-Often
*
Have you ever sorted and filtered data using Excel?
Choose only one of the following
1-Never
2
3
4
5-Often
*
Do you work with subtotals in worksheets?
Choose only one of the following
1-Never
2
3
4
5-Often
*
Do you use Advanced Formulas for calculating (e.g. Date and Time, Financial, Statistical, Logical, Lookup and Reference functions)?
Choose only one of the following
1-Never
2
3
4
5-Often
*
Can you import and export data into and out of Excel?
Choose only one of the following
1-Never
2
3
4
5-Often
*
Have you ever audited worksheets by tracing Cell Precedents and Cell Dependents?
Choose only one of the following
1-Never
2
3
4
5-Often
*
Can you create a Pivot Table?
Choose only one of the following
1-Never
2
3
4
5-Often
*
Can you record a simple macro?
Choose only one of the following
1-Never
2
3
4
5-Often
*
Can you protect a file or share a Workbook to collaborate with others?
Choose only one of the following
1-Never
2
3
4
5-Often
*
Can you track changes in a shared workbook?
Choose only one of the following
1-Never
2
3
4
5-Often
*
Have you performed a Statistical Analysis with the Analysis ToolPak?
Choose only one of the following
1-Never
2
3
4
5-Often
*
Have you ever managed XML workbooks?
Choose only one of the following
1-Never
2
3
4
5-Often
*
Can you create a macro that uses looping?
Choose only one of the following
1-Never
2
3
4
5-Often
*
Do you add decision-making code to your macros?
Choose only one of the following
1-Never
2
3
4
5-Often
*
Are you incorporating your own custom functions in your work?
Choose only one of the following
1-Never
2
3
4
5-Often
*
Can you use the basic debugging tools?
Choose only one of the following
1-Never
2
3
4
5-Often
[Exit and Clear Survey]
