DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
.xlsm
|
|
|
.xltx
|
|
|
.xlsx
|
|
|
.xlam
|
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 XLS file is a spreadsheet file that can be created by Excel or other spreadsheet programs. The file type represents an Excel Binary File format. An XLS file stores data as binary streams–a compound file. Streams and substreams in the file contain information about the content and structure of an Excel workbook.
Detailed explanation-3: -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.