about uscontact usfind usbrochurenewsthe teamcareersresourcessite map
Please take your time to answer all of the questions below as accurately as possible.
Once you have supplied all your answers, press "Submit Results" to display the results of your test
.
questions answers
1 . Have you used or are you currently using a spreadsheet package?
2. Can you Enter and Edit existing data into your spreadsheet?
3. Can you Align your data within a column?
4. Can you Add the values of two or more cells together so that the answer will automatically update?
5. Can you calculate the average value from a range of cells using a cell reference formula?
6. Have you used the Excel Function Wizard for creating formulae?
7. Can you Format a worksheet such as changing Fonts and Text Size, or apply Bold, Italics and Underline to cells?
8. Can you format a cells contents to display values as either Currency, Percentage or Rounded Numbers?
9. Have you used AutoFill to copy calculations to more than one cell?
10. Do you know how to Insert new Columns and Rows?
11. Can you calculate the percentage value of a cell based upon the total?
12. Do you know what the $ is used for in formulae?
13. Can you Save a new worksheet using an appropriate file name?
14. Can you insert and rename worksheets within a Document?
15. Can you set your own Page Breaks and Print Ranges to print a worksheet as you would like?
16. Do you know how to create a Chart from your worksheet data?
17. Can you Edit and Format a Chart?
18. Can you adapt or change the default chart?
19. Can you adjust Scaling and Trendlines in Charts
20. Can you fix the Row and Column headings in a worksheet for scrolling through long documents?
21. Can you Protect worksheet cells from editing?
22. Do you know how to create IF and Lookup functions?
23. Can you name a series of cells for use in Formulas?
24. Can you create an Outlined worksheet to minimise and restore large sections of data?
25. Can you Link multiple worksheets and / or Workbooks together?
26. Have you set-up and used your worksheet as a Database within Excel?
27. Can you Customise your Toolbars?
28. Can you create a Pivot Table to convert data into Columns and Rows?
29. Have you set-up Data Tables, Goal Seeking or Solver?
30. Have you set-up Regression Analysis to forecast values?
31. Have you installed and used any of the additional Add-Ins for Microsoft Excel?
32. Do you know what a Recorded Macro is and how to create one?
33. Can you edit a Record Macro using Microsoft Visual Basic Code?
34. Have you created Templates?
  .........................................................................................................................................................................................