Know IT - Microsoft Excel Pre Course Questionnaire

To assist us in evaluating your current skill level in Microsoft Excel, please complete this short survey (you must complete each question). It should take you approximately 5 minutes. This will ensure that individual training sessions can be tailored to suit your requirements and that you are placed on the most appropriate training program. To navigate through the questionnaire please note the scroll bar is contained to the right-hand side of the questionnaire window. When finished click on submit button.
    This is a required question
    This is a required question
    This is a required question
    This is a required question
    This is a required question
    This is a required question
    This is a required question
    This is a required question
    This is a required question
    a. Create a new Workbook/ File
    b. Enter Data - Text, Values
    c. Create Formula to Add, Subtract, Multiply, Divide
    d. Highlight Ranges and non-contiguous Ranges
    e. Navigate the Spreadsheet with the cursor movement keys
    f. Understand the different mouse shapes on the worksheet (cross, arrow)
    g. Cut, Copy and Paste Cells and Ranges
    h. Save a Workbook
    i. Insert Rows/ Columns
    j. Use the view menu - Toolbars, Zoom
    k. Use the Freeze Panes command to freeze rows/ columns on the sheet
    l. Create and edit Hyperlinks
    Please enter one response per row
    a. Bold, Underline, Italics, Font Changes
    b. Apply Borders/ Lines to Ranges
    c. Align text with the Format, Cells, Alignment command
    d. Wrap Text, Merge and Centre
    e. Format Value Cells (£, %, no. of decimals etc.)
    f. Apply Shading to Cells
    g. Adding and editing cell comments
    h. Applying and creating conditional formatting for cells
    Please enter one response per row
    a. Preview and Print the current Sheet
    b. Print a Range from the Sheet
    c. Group Sheets for Printing
    d. Change the Page Setup- Landscape/ Portrait, Gridlines - on/off, Margins
    e. Insert Page Breaks, Compress Print, Use Headers/ Footers
    Please enter one response per row
    a. Use the Sum, Average, Max, Min, Count statistical functions
    b. Use the Sumif, Countif functions
    c. Use the IF statement
    d. Use Absolute (F4) cell references in a formula
    e. Use Date/ Time functions for calculations on dates
    f. Use other functions eg. vlookup, iferror, concatenate
    Please enter one response per row
    a. Create a chart from worksheet data (on the current sheet)
    b. Create a chart from worksheet data on a new sheet
    c. Edit the chart - patterns, fonts, gridlines, axis, scaling
    d. Add data to an existing chart
    e. Print the chart
    Please enter one response per row
    a. Rename Sheets
    b. Copy/ Move sheets around the workbook
    c.Copy/ Move sheets to another workbook
    d. Group Sheets
    e. Link sheets with formulae
    f. Link sheets with the Copy/ Paste Special command
    Please enter one response per row
    a. Use the Windows command to switch between open files/ workbooks
    b. Create a link between files
    c. Edit the links
    Please enter one response per row
    a. Lock/ Unlock Cells
    b. Protect the Worksheet
    c. Protect the Workbook
    Please enter one response per row
    a. Set up a database on the spreadsheet
    b. Sort the Database
    c. Use the filter command to extract records matching a set criteria
    d. Enter records to the Database using the Form screen
    e. Create a Pivot Table to summarise the data from the database 
    f. Adding Data Validation to cells e.g. drop down menu etc.
    g. Grouping and Ungrouping rows and columns of data
    Please enter one response per row
    a. Use the Find File facility to look for a workbook
    b. Search for workbooks which match a criteria set by you
    c. Delete, Copy, Move workbooks
    Please enter one response per row
    a. Create a Template
    b. Change the settings for the default template
    Please enter one response per row
    a. Use the Goalseek command to achieve a figure based on changing another
    b. Use the Scenario Manager 
    c. Use the Audit command to trace dependent and precedent cells
    d. Fix circular reference errors
    e. Insert a picture on the worksheet (e.g. Company Logo)
    f. Insert data from other systems into a spreadsheet
    g. Save data to other formats 
    h. Exchange data from Excel with other applications (PowerPoint, Word)
    i. Add in the Autosave feature to prompt the user to save the current file
    Please enter one response per row
    a. Customise the Toolbar
    b. Create a keystroke substitute Macro
    c. Run a Macro
    d. Assign a Macro to a Button
    Please enter one response per row
    This is a required question