DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Click the File tab, select Save As, click Browse, and change the file type to .xltx.
|
|
|
Click the File tab, select Save As, click Browse, and change the file type to .xlsm.
|
|
|
Click the File tab, select Save As, click Browse, and change the file type to .xlam
|
|
|
Click the File tab, select Options, click Save, select the Save as Template check box, and save the file as usual.
|
Detailed explanation-1: -Click File, and then click Save As. In the File name box, type the name that you want to use for the template. In the Save as type box, click Excel Template, or click Excel Macro-Enabled Template if the workbook contains macros that you want to make available in the template. Click Save.
Detailed explanation-2: -Which of the following statements best describes how to copy macros from one workbook to another? Drag the module from one project to another in the Project Explorer window of the Visual Basic Editor.
Detailed explanation-3: -Before you create a Scenario Summary, name the Scenario input cells on the Excel worksheet. This will make it easeir to read the data that’s in the Scenario Summary. The report will show the variable cell names, instead of the input cell worksheet addresses.