Chapter 2

Question 1

How to display the Developer tab

Answer 1

Right-click Ribbon

Choose customize Ribbon

Put check mark by Developer in second column

Question 2

Shortcut for creating a new empty workbook

Answer 2

Ctrl+N

Question 3

two paths to Visual Basic Editor

Answer 3

Developer->Code->Visual Basic

Alt+F11

Question 4

Shortcut to display Project window in VBE

Answer 4

Ctrl+R

Question 5

how to comment a VBA line of code

Answer 5

precede the statement with an apostrophe ( ‘ )

Question 6

Shortcut to switch back to Excel from VBE

Answer 6

Alt+F11

Question 7

file extension for macro-enabled file type

Answer 7

.xlsm

Question 8

three malicious things an Excel macro could do

Answer 8

Delete files

Send information to other computers

Destroy Windows so you can’t start your computer

Question 9

Shortcut to Help screen

Answer 9

F1

Question 10

Does a workbook containing a macro have to be active to run the macro?

Answer 10

No, it just needs to be open

Question 11

If you store a macro in your Personal Macro Workbook, it is available when?

Answer 11

automatically whenever you start Excel