FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -The Microsoft Excel Binary File format, with the . xls extension and referred to as XLS or MS-XLS, was the default format used for spreadsheets in Excel through Microsoft Office 2003. The format is also referred to as Binary Interchange File Format (BIFF) in Microsoft’s technical documentation.

Detailed explanation-2: -XLS files are Microsoft Excel’s workbook files in use between 97-2003. Later Excel versions use the XLSX extension. XLS and XLSX file formats contain all the information from the worksheets in a workbook, including formatting, charts, images, formulas, etc.

Detailed explanation-3: -XLS vs XLSX: File Format XLS is the default file format from Excel 97 to Excel 2003 while XLSX is the default file format for Excel 2007 and later. Tip: . xls is also the file extension for Microsoft Excel 5.0/95 Wordbook. .xlsx is also the file extension for Script Open XML Spreadsheet.

Detailed explanation-4: -In Microsoft Excel, workbooks are saved as Excel Workbooks (. xlsx) by default. You can change the default file format to any other file format that is supported in Excel. For example, if you frequently create macros in a workbook, you may want to automatically save a new workbook as an Excel Macro-Enabled Workbook (.