USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
You must save your workbook as a macro-enabled workbook to use macros.
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -Macro-Enabled File Extensions When you record a macro, or you manually write VBA code in Excel, you need to save the file with a macro-enabled file extension (. xlsm).
Detailed explanation-2: -You can save your macro in PERSONAL. xlsb to apply the macro to all workbooks that you open and use on your computer. (Macros stored in personal. xlsb will not be available on other computers.)
Detailed explanation-3: -Step 1: In the File tab, click “options.” Step 2: In the “Excel options” dialog box, click “trust center settings” in the “trust center” option. Step 3: In the “macro settings” option, select “enable all macros.” Click “Ok” to apply the selected macro settings.
There is 1 question to complete.