Excel Skills Survey

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

The questions are "YES" or "NO" responses, "YES" if you know how to perform the task and "NO" if you do not. If you need further clarification regarding a question you may approach your trainer.
Name: 


  1. Insert Columns and Rows?
    Yes
    No


  1. Delete Columns and Rows?
    Yes
    No


  1. Insert a new worksheet in a workbook?
    Yes
    No


  1. Delete a worksheet?
    Yes
    No


  1. Rename a worksheet?
    Yes
    No


  1. Copy and Move worksheets within a workbook?
    Yes
    No


  1. 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. Change column width and row height?
    Yes
    No


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


  1. Format a worksheet with borders and shading?
    Yes
    No


  1. Create customized formats?

    NOTE: Customized formats are created when Excel does not have a format to match your needs.

    Example: 1 - (800) 555-5555. Creating a customized format for this number would keep you from having to key in the "1", the " - ", parens and the "800".
    Yes
    No


  1. Cut, Copy, and Paste?
    Yes
    No


  1. Auto fill a series of cells with dates, formulas, months using the auto fill handle?

    NOTE: The auto fill handle is the small black square located in the lower right corner of an active cell. This black square is known as the auto fill handle and can be used to copy a formula or to increment dates and months.
    Yes
    No


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


  1. Do you know how to create formulas?
    Yes
    No


  1. Create basic function formulas?

    Examples:
    =SUM(A2:A50)
    =AVERAGE(C5:C20)
    Yes
    No


  1. Purpose of using dollar signs in a formula? Example: =A1*$H$1?
    Yes
    No


  1. Purpose of using Paste Special when copying formulas versus Paste?
    Yes
    No


  1. Create a basic IF formula?
    Yes
    No


  1. Create nested IF formulas?
    Yes
    No


  1. Create formulas using nested functions?

    Example: =IF(AVERAGE(A1:A5)>350,SUM(A1:A5),0)
    Yes
    No


  1. Create database function formulas?

    Example: DSUM, DMAX, DMIN, DAVERAGE
    Yes
    No


  1. Create SUMIF formulas?
    Yes
    No


  1. Create COUNTIF formulas?
    Yes
    No


  1. Create VLOOKUP formulas?
    Yes
    No


  1. Create HLOOKUP formulas?
    Yes
    No


  1. Create 3-D formulas?

    Example: =SUM(Sheet1:Sheet4!A1:C50)
    Yes
    No


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


  1. Use the Data Validation feature?

    Example: Data Validation is used to place restrictions on what can be entered into a range of cells such as allow values from a list, allow numbers within limits, allow text of a specified length, etc.
    Yes
    No


  1. Create PivotTables?
    Yes
    No


  1. Use the Subtotals command? (this option is located under the Data menu)
    Yes
    No


  1. Use the filters feature? (located under the Data menu)
    Yes
    No


  1. Use the Advanced Filter feature in Excel?
    NOTE: This feature is used to extract information based upon multiple field criteria whereas the basic filter allows for only one field criteria.
    Yes
    No


  1. Create Charts in Excel?
    Yes
    No


  1. Create range names?

    Range names are used to refer to a cell or range of cells by a name.

    Example: If cells A2:A50 in Sheet1 are sales numbers for Donna and you wanted to create a formula in Sheet2 that refers to a range in Sheet1 you could use the range name to create the formula: =SUM(Donna). This formula is an absolute reference to A2:A50 of Sheet1.
    Yes
    No


  1. Use the Protection feature in Excel to to prevent data entry to a specified range of cells?

    Example: When you share an Excel file with others you can prevent any user from making changes to specific worksheet or workbook elements by protecting (or locking down) certain parts of the file.
    Yes
    No


  1. Create a template in Excel?

    A template is a model that you can use to base other spreadsheets off of. Example: You could create an Expense spreadsheet complete with all formulas and fields needed to create an Expense report. Save it as a template and then distribute to all who need the Expense Report template to create their monthly expense reports.
    Yes
    No


  1. Comments:





Marvicci Mendoza
Metro Manila