All questions must be answered before the questionnaire can be submitted
First Name
Last Name
Company Name
email
1. Start Excel
2. Understand the screen & toolbars
3. Navigate around a workbook/worksheet
4. Open & save files
5. Enter & edit data
6. Construct formulae
7. Insert/delete rows & columns
8. Move & copy data
9. Use the Fill Handle to copy cells
10. Format cells
11. Use number formats
12. Resize cells
13. Check spelling
14. Use print preview
15. Print worksheets/workbooks
16. View & print formulae
17. Link data across worksheets and workbooks
18. Freeze row & column headings
19. Name cells and add comments
20. Add, delete & move worksheets
21. Create various types of charts
22. Modify chart types
23. Add & delete chart items
24. Move & size chart items
25. Format chart text
26. Format chart labels
27. Print a chart
28. Add graphics
29. Use max/min/count functions
30. Use simple IF statements
31. Use lookup functions
32. Use absolute referencing
33. Use single-level sorting
34. Use multi-level sorting
35. Filter a list
36. Use custom criteria
37. Use multi-condition criteria
38. Create summary reports
39. Show sub-totals
40. Create outline reports
41. Use statistical formulae
42. Create simple pivot tables
43. Create simple macros
44. Work with pivot tables
45. Create pivot charts
46. Consolidate data
47. Use scenarios
48. Protect cells/worksheets/workbooks
49. Use custom views
50. Use the formula palette
51. Use lookup functions
52. Use text & date functions
53. Record macros
54. Run macros
55. View VBA code
56. Create interactive forms
57. Audit a spreadsheet
58. Create custom charts
59. Work with Excel in other applications
60. Use customised toolbars
61. Create & apply styles
62. Use templates
Please answer the questions as honestly as possible - there are no ‘right’ or ‘wrong’ answers.
Are you able to?
When you have answered all questions click here to submit the form and return to the TNA page
