Page 23 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.

By default, VBA is case sensitive when using the Like operator to compare text.



Why is it easier to start writing a macro with a code example?

An example gives you a framework to start with, so you don't have to write your macro from scratch.

If you start with a working macro, you know that the basic logic of the macro is OK.

An example can jump start your macro.

All the above.

How do you undo actions performed by a macro?

With the Undo button.

By putting "Option Undo" in the macro.

You can't, so back up your data.

Page 23 of 24PREVNEXT