Excel: Macros and VBA for Beginners
You're at line 13 in your code and decide you want to run the whole macro from the beginning. What do you need to do? A) Click Save. That will save the modifications and end any macros that are running. B) Click the Reset button. C) Return your cursor to the top of the code. D) Click the Play button
B)
You've sent an Excel workbook to your colleague, Tom, and he can't find the Macros icon that you told him to click on. What's the most likely reason? A) Tom or someone else disabled the Developer tab because it's enabled by default. B) Tom hasn't enabled the Developer tab. C) Tom hasn't configured his Quick Access Toolbar D) The workbook is saved as .xlsx and Tom needs to save it as .xlsm in order to see the Macros icon.
B)
You receive a new workbook containing a macro created by someone else. What is a good reason to go through the macro step by step? (select 2 or more) A. You need to verify if the macro delivers the expected results. B. You need to learn more about VBA, stepping through the code lets you see what each command does. C. You need to add more tasks to the macro and stepping through the macro will help find the best spot to begin recording. D. The macro is doing something strange, stepping through will help identify where strange behavior is occurring in the code.
B, D
What is the difference between a macro and VBA? A) They are the same thing. B) A macro is a routine that Excel cannot already do. VBA is a routine that Excel does which can be modified by the user. C) A macro is the entire script of code that performs a task. VBA is the coding language. D) A macro is recorded. VBA is written from scratch.
C)
You emailed BreakfastSchedule.xlsm to your supervisor to add some data. He returned it and now the filename is BreakfastUPDATED.xlsx. Why is this a problem? A) The macro code in the new file has been disabled and needs to be manually re-enabled. B) Your supervisor disabled the Developer tab, so the macro will no longer run. C) The macro in the new file is gone D) Changing the name of a workbook breaks any macro within.
C)