1. How do you open a workbook named wrkTest, located in the C:\Temp directory?

a. Workbooks.Activate("C:\Temp\wrkTest.xlsx")

b. Workbooks.Open(C:\Temp\wrkTest.xlsx)

c. Workbooks.Activate(C:\Temp\wrkTest.xlsx)

d. Workbooks.Open("C:\Temp\wrkTest.xlsx")

2. How do you prevent the Worksheet_Change() event handler from firing within the subroutine?

a. Application.EnableEvents = False

b. Application.Worksheet_Change = Off

c. Application.Worksheet_NoChange = True

d. Set DisableEvents = True

3. What is the first thing you should do when recording a macro with a pivot table?

a. Open the VBA editor.

b. Delete any existing macros.

c. Clear the pivot table.

d. Highlight the pivot table.

4. What does a VBA watch do?

a.It determines if there are errors in a subroutine.

b. It records how long it takes to run a subroutine.

c. It continuously displays the value of a variable.

d. It monitors user input.

5. Which code will assign a worksheet named Test to the variable varx?

a. ThisWorkbook.Worksheets("Test") = varx

b. dim varx = ThisWorkbook.Worksheets("Test")

c. varx = Worksheet("Test")

d. set varx = ThisWorkbook.Worksheets("Test")

6. A _____ is used to temporarily stop the code from running at a specific place in the subroutine.

a. step over

b. breakpoint

c. step out

d. break

7. How do you stop a loop from running?

a.Ctrl + C

b. Click the Stop button in the VBA toolbar.

c. Ctrl + End

d. F5

8. Case statements are similar to which loop structure?

a. For

b. While

c. Do

d. If-Then