Page 7 of 8PREVNEXT

Save time by creating and running macros in Excel 2010

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.


The main reason to save a macro to your personal macro workbook is so that you:

Can hide your macro from prying eyes

Can easily edit it

Can reuse the macro anywhere, anytime

Can reuse the macro in any workbook on your computer

The Macro Recorder saves your steps as:

Binary code that's unreadable by most people

Lines of text that you can read and change

XML tags

HTML tags that you can read and change

True or False: Once you've recorded a macro, you can't change it.

True

False

The option you set before recording a macro to ensure absolute cell references are not recorded in your macro is called:

Use Offset References

Use Absolute References

Use Relative References

Use Direct References

Page 7 of 8PREVNEXT