FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which is a special workbook a user can create and then use as a pattern to create new, similar workbooks or worksheets?Standard(s)
A
Form
B
Boilerplate
C
Smart Sheet
D
Template
Explanation: 

Detailed explanation-1: -An Excel template is a predesigned sheet that can be used to create new worksheets with the same layout, formatting and formulas. With templates, you don’t need to recreate the basic elements every time as they are already integrated into the spreadsheet.

Detailed explanation-2: -Click the File tab. Click New. Under Available Templates, double-click Blank Workbook. Keyboard shortcut To quickly create a new, blank workbook, you can also press CTRL+N.

Detailed explanation-3: -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.

There is 1 question to complete.