DATABASE FUNDAMENTALS
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: -If you are working with standard Excel file type (. xlsx), save it as a macro-enabled workbook (. xlsm) to be able to use macros. Note that this isn’t necessary with the old Excel type (.
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.