Information Communication Technology ICT – 11 File management | e-Consult
11 File management (1 questions)
Saving in .xlsx and .xls formats:
To save a spreadsheet in .xlsx format, the user would go to File > Save As, select the .xlsx file type from the dropdown menu, and then specify a location to save the file.
To save in .xls format, the user would follow the same steps, but select the .xls file type from the Save As dropdown menu.
Key Differences:
- .xlsx: The newer format, introduced with Microsoft Excel 2007. It uses XML-based files, which are more robust and can handle larger datasets than .xls. It supports more features, such as charts with more options and enhanced data validation.
- .xls: The older format, used in earlier versions of Excel. It uses a binary file format, which is less efficient and has limitations on the size of the spreadsheet.
Why choose one over the other:
A business would typically choose .xlsx for new spreadsheets because it offers better performance, more features, and greater data capacity. However, if the business needs to share the spreadsheet with someone using an older version of Excel (prior to 2007), they might need to save it as .xls to ensure compatibility. Conversely, if a legacy system or process requires the .xls format, it would be necessary to save the spreadsheet in that format.