Assess Your Skills

Microsoft Excel “Getting Started with Macros” 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 Create and name your own toolbar?
Yes No Unsure Add toolbar buttons to an existing toolbar and reset the toolbar to its original state?
Yes No Unsure Remove toolbar buttons from an existing toolbar?
Yes No Unsure Create a customized date format?
Yes No Unsure Use a date in a calculation?
Yes No Unsure Create a “Pivot Table” to summarize data?
Yes No Unsure Use the Function Wizard?
Yes No Unsure Use a complex function in a calculation?
Yes No Unsure Nest several functions in a calculation?
Yes No Unsure Create a complex link to another worksheet or workbook?
Yes No Unsure Use the “Past Link” command for a simple link?
Yes No Unsure Modify a function with a constant expression?
Yes No Unsure Put a “current date” stamp into a cell on a worksheet?
Yes No Unsure Arrange and work in multiple workbook windows on the screen?
Yes No Unsure Use the IF() function to create literal text as a calculation result?

 

  Your score:

If your score is 12 or greater, you are probably ready to attend our Microsoft Excel Getting Started with Macros class. Eleven or fewer? We suggest you attend our Level 2 Excel 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