Bookmark Us
EQV - Business Training Services
Tuesday 7th February 2012,

 

Home > Getting the most from your training - Levelling Questionnaires > Excel

Microsoft Excel Levelling Quiz

This quiz is designed to make sure that you're attending the right course for your level of competency in Excel in order to get the maximum benefit - there's no pressure and no time limit

You can print off your results at the end for your information. Feel free to bring them to your training course to show the trainer the areas you're particularly interested in learning more about.

 

Section 1 Basic Excel Features

 Yes No
Do you understand the basic Excel layout?
Use Functions such as Sum, Average, Count?
Can you differentiate between Absolute and Relative Formulae?
Can you use Named Ranges (renaming a cell or groups of cells)?
Can you Link worksheets / files together via a Formula?
 

Section 2 Intermediate Excel Features

    
Can you use the IF Function and Nested IF?
Can you use the Vlookup & Hlookup Function?
Can you calculate with date Functions?
Can you use Statistical Functions like DSum?
Can you use a pivot Table?
 

Section 3 Advanced Excel Features

    
Can you record a Macro?
Can you write macros via programming?
   
Home | About Us | Information Request | Contact Us| Login
EQV - Management & Business Skills Training & Development