Question

Harrison worked on a spreadsheet to show market trends of various mobile devices. The size of the file has increased because Harrison used a lot of graphs and charts. Which file extension should he use so that the workbook takes less storage space? A. xltx file extension B. xlsm file extension C. xlsb file extension D. xlsx file extension E. xlts file extension

Answer 1

XLSB:

• Store data in a different, memory efficient way.
• XLM file structure is not used.
• Data is stored in binary format.
• Faster file access.
• handle various types.
• All formulas can be applied
• File size = 1048576 rows and 16384 columns

Hence, the file extension that should be used so that the workbook takes less storage space is xlsb file extension.

The answer is (c) xlsb file extension.

Answer 2

An XLSB file extension is a Workbook file used for various purposes.

If a user uses the file with the XLSB file extension, then he/she will be able to store the data in terms of binary format.

The binary format will not be supported in the Excel files or XML file types, so  C.  xlsb file extension is the correct answer.