DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
You want to enter information using your own layout.
|
|
|
You want to use a design and layout previously created, either to enter data or to use as a base for your own reports
|
|
|
You want to create a workbook that is automatically password-protected.
|
|
|
You want to start out with one blank worksheet.
|
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: -Open the “File” menu, and then click the “Save As” option. In the file type dropdown (just underneath the file name text box), select the “Excel template (. xltx)” option. By default, Excel likes to save templates in DocumentsOffice Templates, but you can save them wherever it makes sense to you.