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

Explanation:

• .xlsx: This is the default file format for Excel workbooks starting from Excel 2007. It uses a compressed XML - based format. When there are a lot of graphs and charts (which are objects in the workbook), the compression in the.xlsx format helps in reducing the storage space compared to older binary formats like.xls (not in the options here).
• .xltx: This is a template file format. It is used to create new workbooks based on a template and is not suitable for reducing the size of an existing data - rich workbook with graphs and charts.
• .xlsm: This is an Excel macro - enabled workbook. The presence of macros adds additional elements to the file structure and does not help in reducing the size due to graphs and charts.
• .xlsb: While it is a binary format (which can be faster to read/write in some cases), it is not as space - efficient as the compressed.xlsx format when dealing with a large number of objects like graphs and charts.
• .xlts: This is a macro - enabled template format and is not relevant for reducing the size of a data - filled workbook.

Answer:

D. xlsx file extension