AO6 Create macros to automate procedures in a spreadsheet

Pass

Merit

Distinction

Candidates will record a simple macro to automate a sequence of at least two tasks.

They will enable this macro to be run by either keyboard shortcut or a button on the sheet or on the toolbar.

They will access the macro code and print it out.

Candidates will record a macro to automate a sequence of at least two tasks.

They will enable this macro to be run by both a keyboard shortcut and a button on the sheet or on the toolbar.

They will access the macro code and print it out.

They will describe what the macro does and how it can be run.

Candidates will record a macro to automate a sequence of more than two tasks.

They will enable this macro to be run by both a keyboard shortcut and a button on the sheet or on the toolbar.

They will access the macro code and print it out.

They will describe what the macro does and how it can be run. They will annotate the macro code to show the function of at least three different lines of code.

Diweddarwyd diwethaf: Tuesday, 8 May 2012, 4:16 PM