FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of the following is the file extension used for Excel Template files?
A
.xlsm
B
.xltx
C
.xlsx
D
.xlam
Explanation: 

Detailed explanation-1: -A file with the XLTX file extension is an Excel Open XML spreadsheet template file. This Microsoft Excel format is used to build multiple XLSX files that contain the same layouts, formatting, and settings.

Detailed explanation-2: -An XLTX is the same as an XLSX in all respects-it’s just that Excel creates a new instance of an XLSX if the file opened is an XLTX. That’s all. If you use an XLTX for your data filling and save out an XLSX, every new instance (XLSX) will have that data when the resulting XLSX is opened.

Detailed explanation-3: -A file with the XLTM file extension is an Excel macro-enabled template file created by Microsoft Excel. They’re used to build similarly formatted XLSM files.

There is 1 question to complete.