EXCEL ONLINE ASSESSMENT: Beginner, Power User, or Pro - Which One Are You?

Which course is the best fit for you as a starting point?

Page1 / 1

100% of survey complete.

Question Title

* 1. Do You Know How To Quickly add icons to the Quick Access Toolbar?

A. No I don't

B. I know how to do this but not how to add headers and footers to printing

C. I know this and I know how to do 'B' as well, but not how to USE CONDITIONAL FORMATTING AND DATA BARS

D. I know this and B and C but have not yet learned HOW TO CREATE A BASIC MACRO

E. I know how to do this plus B, C, and D.

Question Title

* 2. Do you know how to Apply and Remove lines to cells?

A. No I do not.

B. Yes but I don't know how to Change print settings e.g. margins, orientation

C. Yes and I know how to do 'B' as well, but not how to USE the AUTO FORMAT FEATURE

D. Yes and I know how to do both B & C but not how to create dynamic drop down selection lists

E. Yes, I know how to do this and how to do B, C and D.

Question Title

* 3. Have you had an Introduction to UNDERSTANDING FORMULA SYNTAX

A. No I have not.

B. Yes but I've not learned CORRECTING ERRORS IN FORMULAE

C. Yes and I know B as well, but I do not know how to View & Tile multiple files

D. Yes and I know how to do B and C but don't know how to Create/Edit/Customise pivot charts & tables

E. Yes, I know how to do this and how to do B, C and D.

Question Title

* 4. Can you Print basic Data?

A. No I cannot.

B. Yes but I can't Create a basic Bar chart

C. Yes and I can do 'B' But don't know how to USE NESTING FUNCTIONS and ADVANCED 'STYLES' FORMATTING

D. Yes and I can do B and C as well, but don't know LINKING WORKBOOKS & Printing grouped worksheets

E. Yes, I know how to do this and how to do B, C and D.

Question Title

* 5. Do you know how to Select multiple rows and/or columns?

A. No I do not.

B. Yes but I can't Differentiate between absolute and relative formulae

C. Yes and I can do 'B' as well but I don't know how to Use partial absolutes in formulae

D. Yes and I know B and C but need to learn to Use Advanced filters with logical parameters (>, <, <=, >= etc.) and criteria ranges

E. Yes, I know how to do this and how to do B, C and D.

Question Title

* 6. Do you Understand What The Various Cursor Shapes Mean?

A. No...only a couple of them.

B. Yes, but not sure how to Hide and Unhide Columns and Rows

C. Yes and I know 'B' as well, but don't know how to Format nor understand the use of Dates

D. Yes, and I know B and C as well, but don't know exactly how to Create, Manage, and Name Cell Ranges

E. Yes, I know how to do this and how to do B, C and D.

Question Title

* 7. Do you Fully understand the Excel Ribbon & Screen layout?

A. No I do not.

B. Yes I do, but I don't know fully how to Insert and Delete columns and rows

C. Yes and I know 'B' but can't Sort lists of data quickly on a single column nor Freeze titles or split the screen.

D. Yes and I know B and C but don't know how to Create linked formulae nor Link files with formulae and Manage links.

E. Yes, I know how to do this and how to do B, C and D.

Question Title

* 8. Can you: Highlight blocks of data quickly using the keyboard?

A. No I cannot.

B. Yes but I can't really Insert and/or Copy Worksheets as I'd like.

C. Yes, and I can do 'B' but know little of WORKING WITH DATA LISTS AND TABLES: SORTING, FILTERING, SUB-TOTALS etc.

D. Yes, and I can do B and C but really need A QUICK REVIEW OF FORMULAS, FUNCTIONS, AND FORMULA SYNTAX

E. Yes, I know how to do this and how to do B, C and don't need D.

Question Title

* 9. Can you easily Change column widths?

A. No I cannot.

B. Yes, but I Know little to nothing about AUTO-SUM feature

C. Yes, and I know 'B' as well, but don't know how to Use Range names in formulae

D. Yes, and I know B and C as well, But don't know how to Format/Edit/add areas to pivot tables.

E. Yes, I know how to do this and how to do B, C and D.

Question Title

* 10. Do you know how to: Create simple mathematical formulas?

A. No I do not.

B. Yes, but I know little to nothing about using 'arguments' in formula functions

C. Yes, and I know 'B' as well but don't know how to Insert or Edit COMMENTS

D. Yes, and I know B & C but can't INTERPRET AND ANALYSE DATA by CREATING and/or REMOVING OUTLINES.

E. Yes, I know how to do this and how to do B, C, and D.

Question Title

* 11. Do you know how to: Use the SUM Function?

A. No I do not.

B. Yes but I have little to no knowledge of USING 'BRACKETS' IN FORMULAE

C. Yes, and I know B as well, but I don't know exactly how to 'Group' Worksheets

D. Yes, and I know B and C as well, but I know little about USING EXCEL DATABASE FUNCTIONS.

E. Yes, I know how to do this and how to do B, C, and D.

Question Title

* 12. Are you able to quickly use the undo and 'redo' functions?

A. No I am not

B. Yes I am but I need MORE training ON FORMULA SYNTAX

C. Yes I am and know 'B' as well, but I can't really add new data to charts yet

D. Yes I am and know both B & C, But can't INTERPRET AND ANALYSE DATA USING 'GOAL SEEKER.

E. Yes, I know how to do this and how to do B, C, and D.

Question Title

* 13. Can you easily enter data and/or edit data on a spreadsheet?

A. No I cant do this 'easily'.

B. Yes, but I just require A BASIC REVIEW OF THE FUNDAMENTALS

C. Yes, and 'B' as well but I can't yet easily add or edit colours, borders, and scales on CHARTS.

D. Yes, and I know B and C as well, but don't know how to password protect a file nor remove protection

E. Yes, I know how to do this and how to do B, C, and D.

Question Title

* 14. Have you ever had an introduction to 'autofill' and it’s options?

A. No I have not.

B. Yes I know autofill but don't know Preview sheets or how to use other views like Page Break Preview.

C. Yes I know autofill and 'B' but don't know how to use concatenation formulae to join words, numbers and cells.

D. Yes I know autofill and B & C, but can't create my own bespoke formats for numbers and dates.

E. Yes, I know how to do this and how to do B, C, and D.

Question Title

* 15. Do you know how to format Text and Numbers?

A. No I do not.

B. Yes I do but don't know exactly how to set print areas

C. Yes and I know 'B' as well but don't know much about USING MULTIPLE WORKBOOKS

D. Yes, and I know B and C but can't write and use LOOKUP/VLOOKUP/HLOOKUP formula to find matching data.

E. Yes, I know how to do this and how to do B, C, and D.

Question Title

* 16. Are you able to apply and remove shading, colour, and merging to cells?

A. No I am not.

B. Yes I am but don't know exactly how to set print titles.

C. Yes I am and I know 'B' but don't know how to USE LOGICAL AND DATE FUNCTIONS

D. Yes I am and I know B and C as well but can't add buttons to QAT/Ribbon/Worksheet to run Macro

E. Yes, I know how to do this and how to do B, C, and D.

Question Title

* 17. Do you know how to easily Cut, Copy and Paste cells?

A. No I don't

B. Yes but I don't really understand absolute references (i.e. $A$4)

C. Yes and I know 'B' but don't know how to print Charts and Data together.

D. Yes, and I know B and C as well but don't know how to add protection to cells and sheets

E. Yes, I know how to do this and how to do B, C, and D.

Question Title

* 18. Do you know or use many keyboard shortcut keys?

A. No I don't

B. Yes, but I don't understand mathematical precedence in mathematics and formulae

C. Yes, and I know 'B' as well, but I don't know how to use the Format painter tool

D. Yes, and I know B and C as well, I know little about how to use 'Data Validation' to control user input.

E. Yes, I know how to do this and how to do B, C, and D.

Question Title

* 19. Can you: Create, Save, Find and Open workbooks pretty easily?

A. No I can't

B. Yes I can but I can't USE AVERAGE, COUNT, COUNTA FUNCTIONS

C. Yes I can and I know 'B' as well, but I don't know how to use MONTH, YEAR, TEXT Functions

D. Yes I can and I know B and C as well but I don't know how to add alert messages to Validated cells

E. Yes, I know how to do this and how to do B, C, and D.

Question Title

* 20. Do you know how to Select/Highlight cells and/or groups of cells?

A. No I don't

B. Yes I do but I don't know how to USE SUM, TODAY FUNCTIONS

C. Yes I do and I know 'B' as well, but I really need MORE on USING CHARTS IN EXCEL; Such as Adding/Editing text on charts.

D. Yes I do and I know B and C as well but don't know how to create drop down lists with Validation

E. Yes, I know how to do this and how to do B, C, and D.

Question Title

* 21. Do you know how to easily add or delete cells?

A. No I don't.

B. Yes I do but I'm not sure how to move and/or rename worksheets

C. Yes I do and I know 'B' too, but know litle about using the Sub‐Total/Sub-Sort feature/options

D. Yes I do and I know B and C too, but know little about USING EXCEL INFORMATIONAL FUNCTIONS

E. Yes, I know how to do this and how to do B, C, and D.

Question Title

* 22. Do you know how to easily apply and/or remove colour to/from cells?

A. No I don't

B. Yes I do but I really need an INTRODUCTION TO AUTO-CALCULATE

C. Yes I do, and I know 'B' as well but I can't really write a basic “IF” statement nor a 'nested' "IF" Statement.

D. Yes I do, and I know B and C as well, but I don't know much about AUDITING WORKBOOKS.

E. Yes, I know how to do this and how to do B, C, and D.

Question Title

* 23. Can you easily change row heights?

A. No I can't

B. Yes I can but I don't know how to USE MIN MAX FUNCTIONS

C. Yes I can and I know 'B' also, but don't know how to use string functions, INT, ROUND, SUMIF, LEFT, MID, RIGHT, LEN, FIND, TRIM Functions

D. Yes I can, and I know B and C also, but can't INTERPRET AND ANALYSE DATA 'SCENARIOS'.

E. Yes, I know how to do this and how to do B, C, and D.

Question Title

* 24. Do you know how to merge and/or center cells on a spreadsheet?

A. No I don't

B. Yes I do but I can't really create a basic pie chart

C. Yes I do and I know 'B' also, but know little of using logical functions (AND, OR, ISBLANK, ISTEXT)

D. Yes I do and I know B and C as well, but I really need an Introduction to VBA and Basic Editing

E. Yes, I know how to do this and how to do B, C, and D.

Question Title

* 25. Address

Name *

Company *

Email Address