1. Which tab in the Excel Ribbon is used to access the Macro options?
A) A) Home B) C) View C) B) Insert D) D) Developer
2. Which of the following is a best practice when creating and editing macros in Excel?
A) c) Include personal information in the code B) d) Use shortcuts in the code to save time C) b) Use the same macro for all workbooks D) a) Include comments in the code to explain its purpose
3. What is the shortcut key to run a macro in Excel?
A) A) Ctrl + R B) C) Alt + F8 C) B) Ctrl + M D) D) Alt + M
4. Which of the following is NOT a valid macro security level in Excel?
A) B) High B) A) Very High C) D) Low D) C) Medium
5. What is the file format used for Excel macro-enabled workbooks?
A) A) .xls B) C) .xlsm C) B) .xlsx D) D) .xlm
1. Right Answer: D Explanation: The correct answer is D. The Developer tab is used to access the Macro options in Excel.
2. Right Answer: D Explanation: Including comments in the code to explain its purpose is a best practice when creating and editing macros in Excel, as it helps you and others understand the code.
3. Right Answer: B Explanation: The correct answer is C. Alt + F8 is the shortcut key to run a macro in Excel.
4. Right Answer: B Explanation: The correct answer is A. Very High is not a valid macro security level in Excel.
5. Right Answer: B Explanation: The correct answer is C. .xlsm is the file format used for Excel macro-enabled workbooks.
Leave a comment