Test Yourself - Microsoft Excel
Test Yourself - Microsoft Excel

Training Needs Analysis for Microsoft Excel

Please take your time to answer all of the questions below as accurately as possible. You must fill in all required contact details, which are marked with * character. Once your results have been submitted, an Account Manager from Advanced Training will contact you to discuss your results.
Your Name:
Email Address:


  Question Answer
  1.  Have you used or are you currently using a spreadsheet package?  
  2.  Can you Enter and Edit existing data into your spreadsheet?  
  3.  Can you Align your data within a column?  
  4.  Can you Add the values of two or more cells together so that the answer will automatically update?  
  5.  Can you calculate the average value from a range of cells using a cell reference formula?  
  6.  Have you used the Excel Function Wizard for creating formulae?  
  7.  Can you Format a worksheet such as changing Fonts and Text Size, or apply Bold, Italics and Underline to cells?  
  8.  Can you format a cells contents to display values as either Currency, Percentage or Rounded Numbers?  
  9.  Have you used AutoFill to copy calculations to more than one cell?  
  10.  Do you know how to Insert new Columns and Rows?  
  11.  Can you calculate the percentage value of a cell based upon the total?  
  12.  Do you know what the $ is used for in formulae?  
  13.  Can you Save a new worksheet using an appropriate file name?  
  14.  Can you insert and rename worksheets within a Document?  
  15.  Can you set your own Page Breaks and Print Ranges to print a worksheet as you would like?  
  16.  Do you know how to create a Chart from your worksheet data?  
  17.  Can you Edit and Format a Chart?  
  18.  Can you adapt or change the default chart?  
  19.  Can you adjust Scaling and Trendlines in Charts?  
  20.  Can you fix the Row and Column headings in a worksheet for scrolling through long documents?  
  21.  Can you Protect worksheet cells from editing?  
  22.  Do you know how to create IF and Lookup functions?  
  23.  Can you name a series of cells for use in Formulas?  
  24.  Can you create an Outlined worksheet to minimise and restore large sections of data?  
  25.  Can you Link multiple worksheets and / or Workbooks together?  
  26.  Have you set-up and used your worksheet as a Database within Excel?  
  27.  Can you Customise your Toolbars?  
  28.  Can you create a Pivot Table to convert data into Columns and Rows?  
  29.  Have you set-up Data Tables, Goal Seeking or Solver?  
  30.  Have you set-up Regression Analysis to forecast values?  
  31.  Have you installed and used any of the additional Add-Ins for Microsoft Excel?  
  32.  Do you know what a Recorded Macro is and how to create one?  
  33.  Can you edit a Record Macro using Microsoft Visual Basic Code?  
  34.  Have you created Templates?