Excel Skills Survey

This survey is being used to determine your level of knowledge in Microsoft Excel. The results will be used to customize the training to meet participants learning needs.
Name: 


  1. How often do you use excel?
    Daily
    Weekly
    Occasionally
    Never


  1. What do you use excel for?
    Creating reports
    Viewing data
    Currently do not use excel


  1. Do you know how to insert columns and rows?
    Yes
    No


  1. How to delete columns and rows?
    Yes
    No


  1. How to insert a new worksheet in a workbook?
    Yes
    No


  1. How to insert a new worksheet in a workbook?
    Yes
    No


  1. How to delete a worksheet?
    Yes
    No


  1. How to rename a worksheet?
    Yes
    No


  1. How to copy and move worksheets within a workbook?
    Yes
    No


  1. How to format a worksheet using all the tools on the formatting toolbar?
    Yes
    No


  1. List any formatting tools you do not know how to use.


  1. How to change column width and row height?
    Yes
    No


  1. How to format cells for various formats such as for numbers, dates and times?
    Yes
    No


  1. How to format a worksheet with borders and shading?
    Yes
    No


  1. How to auto fill a series of cells with dates, formulas, months using the auto fill handle?
    Yes
    No


  1. How to use the AutoSum button to add up a series of numbers?
    Yes
    No


  1. How to create formulas?
    Yes
    No


  1. How to create basic function formulas i.e. =SUM(A2:A50), =AVERAGE(C5:C20)?
    Yes
    No


  1. Do you know the purpose of using dollar signs in a formula? Example:=A1*$H$1?
    Yes
    No


  1. Do you know the purpose of using Paste Special when copying formulas versus Paste?
    Yes
    No


  1. How to create a basic IF formula?
    Yes
    No


  1. How to create database function formulas? i.e. DSUM, DMAX,DMIN,DAVERAGE
    Yes
    No


  1. How to create SUMIF formulas?
    Yes
    No


  1. How to create COUNTIF formulas?
    Yes
    No


  1. How to create VLOOKUP formulas?
    Yes
    No


  1. How to create HLOOKUP formulas?
    Yes
    No


  1. How to create 3-D formulas i.e.=SUM(Sheet1:Sheet4!A!:C50)
    Yes
    No


  1. How to Data Consolidate feature to consolidate ranges from multiple sheets into another sheet?
    Yes
    No


  1. How to create PivotTables?
    Yes
    No


  1. How to use Subtotals command?
    Yes
    No


  1. How to use the filters feature?
    Yes
    No


  1. How to use the Advanced Filter feature in Excel?
    Yes
    No


  1. How to create Charts in Excel?
    Yes
    No


  1. How to range names?
    Yes
    No




Templates provided by QUIA.COM.