CES Automation & Macro Creation 2

Question 1

You want a recorded macro to be available in every workbook you open on your computer. Where should you store it?

Accepted Answer

Personal Macro Workbook

Answer

Macros saved to the Personal Macro Workbook (PERSONAL.XLSB) load automatically whenever Excel starts.

Question 2

While recording a macro, you want the steps to apply relative to whichever cell is active when the macro runs. What should you turn on before recording?

Accepted Answer

Use Relative References

Answer

Use Relative References makes the recorder save cell moves as offsets from the active cell instead of fixed addresses.

Question 3

Which VBA statement finds the last used row in column A, even if there are blank cells in the middle?

Accepted Answer

Cells(Rows.Count, 1).End(xlUp).Row

Answer

Starting at the bottom of the sheet and moving up with End(xlUp) lands on the last non-empty cell.

Question 4

What happens to Excel's Undo history after a VBA macro changes cell values?

Accepted Answer

The Undo stack is cleared and the changes cannot be undone with Ctrl+Z

Answer

Running a macro that changes the workbook clears the Undo stack, so its actions can't be reversed with Undo.

Question 5

Which keyboard shortcut opens the Macro dialog box so you can run, edit, or delete macros?

Accepted Answer

Alt+F8

Answer

Alt+F8 opens the Macro dialog box, while Alt+F11 opens the Visual Basic Editor.

CES - Certified Excel Specialists Practice Test

CES - Certified Excel Specialists Practice Test

CES Automation & Macro Creation 2