 |
|
Question |
Answer |
 |
| |
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? |
|
|
 |
