Assess Your Skills

Microsoft Excel Mastering Pivot Tables 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 Format text and numbers in worksheet cells?
Yes No Unsure Use the SUM() function to add adjacent ranges?
Yes No Unsure Use the SUM() function to add nonadjacent ranges?
Yes No Unsure Display and customize Excel toolbars and menus?
Yes No Unsure Insert and format dates?
Yes No Unsure Create and use outline levels?
Yes No Unsure Insert and remove rows and columns?
Yes No Unsure Create range names and use them in formulas?
Yes No Unsure Use the IF() logical function?
Yes No Unsure Create nested IF() statements?
Yes No Unsure Use the VLOOKUP() function?
Yes No Unsure Link cells between worksheets and workbooks?
Yes No Unsure Create, sort, and filter a list?
Yes No Unsure Use database functions with a list?
Yes No Unsure Protect cells in a workbook?

 

  Your score:

If your score is 12 or greater, you are probably ready to attend our Microsoft Excel Tips and Tricks class. Eleven or fewer? We suggest you attend our Excel Level 1 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