Assess Your Skills

Microsoft Excel for Scientists and Engineers Skills Assessment

Read each question below. Being honest with yourself, evaluate your current level of knowledge and experience.

  • Choose “Yes” if you can confidently perform the activity.
  • Check “No” if you can’t perform the activity
  • Check “Unsure” if you don’t understand the questions or only have a vague idea about what’s being asked.
  • After you answer all of the questions, click on the calculate button to receive your score.

Can you confidently:

Yes No Unsure Use the IF function?
Yes No Unsure Use the VLOOKUP function?
Yes No Unsure Create and modify Pivot Tables?
Yes No Unsure Group and summarize data in a Pivot Table ?
Yes No Unsure Link Cells in Different Workbooks?
Yes No Unsure Explain the difference between Workbooks and Workspaces?
Yes No Unsure Share and merge workbooks?
Yes No Unsure Use the Goal Seek and Solver utilities?
Yes No Unsure Use Scenario Manager to view a Worksheet with different input values ?
Yes No Unsure Protect a Workbook?
Yes No Unsure Record and run Macros?
Yes No Unsure Edit VBA code?
Yes No Unsure Define permutation?
Yes No Unsure Work with trigonometry?
Yes No Unsure Work with histograms?

 

  Your score:

If your score is 12 or greater, you are probably ready to attend our Microsoft Excel for Scientists and Engineers class. Eleven or fewer? We suggest you attend our Excel Level 3 class first.

If you are still unsure about which level of training is best for you, please feel free to give us a call and we can have you talk directly to one of our instructors. You can reach us at 408-261-2600. 

 
Return to Class Schedules             Computer Magic Training Home Page
Computer Magic Training • 4030 Moorpark Avenue • Suite 108 • San Jose, California 95117 • 408-261-2600