Please assess each statement and select 'YES' if it lists a process you understand, if in doubt select 'NO'.
| Statement |
Yes No |
|
|
Copy and paste values |
|
|
|
Create sequences using AutoFill i.e. dragging |
|
|
|
Create simple formulas, such as the SUM function, to calculate totals |
|
|
|
Fix cell references in formulas using Absolute Referencing i.e. using dollar signs ($) |
|
|
|
Sort, filter and sub-total data to retrieve information |
|
|
|
Create IF, Nested IF and VLOOKUP formulas |
|
|
|
Change the colour of a cell depending on the cell's value |
|
|
|
Prevent invalid data from being entered into a cell |
|
|
|
Create basic array formulas e.g. SUMIF, COUNTIF and AVERAGEIF |
|
|
|
Create PivotTables and PivotCharts |
|
|
|
Create text manipulation formulas to analyse an external data source |
|
|
|
Create INDEX and MATCH formulas |
|
|
|
Create INDIRECT formulas |
|
|
|
Use tools such as Goal Seek, Scenarios and Data Tables to project figures |
|
|
|
Record macros and assign them to a button |
|
|
|
Continue
Reset
|