Page 9 of 24PREVNEXT

Get in the loop with Excel macros

Test yourself

Complete the following test so you can be sure you understand the material. Your answers are private, and test results are not scored.

Where do you actually write macros?

In a worksheet

In the Visual Basic Editor

In the Record Macro dialog box

Where does the name of the macro appear in the code?

Between the Sub line and the End Sub lines

In the first cell of your data in the spreadsheet.

After the word "Sub" on the same line.

The word "Sub" is the _____ of the macro.




Page 9 of 24PREVNEXT