| | |
| Complete a practical exercise(s) using a spreadsheet package which involves: |
|
| > | Entering labels and values |
|
| > | Formatting cells (eg alignment, numbers, dates) |
|
| > | Changing cell width |
|
| > | Creating simple arithmetic formulae (eg: add, subtract, multiply, divide and sum) |
|
| > | Creating other simple formulae including date and time, statistical (eg average, min, max, count), financial (eg pmt)) and logical functions (eg if( ), and( ) or( ) ) . |
|
| > | Copying formulae using absolutes and relative cell addresses |
|
| > | Checking results, including check-totals and data compared with original sources |
|
| > | Sorting columns in terms of alphabetically and numerically. |
|
| > | Undertaking ‘what-if’ analysis, by manipulating simple cells of data |
|
| > | Graphing data (including eg. non-contiguous ranges, appropriate titles and labels) |
|
| > | Printing, including header and footer, formulae, selections
|
