To save a workbook as an Excel template, which file type must you choose?

To save a workbook as an Excel template, the appropriate file type to choose is the Excel Template format, which uses the extension .xltx. This format is specifically designed to store templates, allowing users to create new workbooks based on the predefined formatting, styles, and data of the original template file.

When you save a workbook as a template, you are essentially creating a master file that can be reused multiple times without overwriting the original data. This functionality is beneficial for maintaining consistency across similar workbooks, such as reports, invoices, or forms, where the structure remains the same but the content may change.

The other file types mentioned serve different purposes. An Excel Workbook (.xlsx) is used for standard workbooks that contain data and formulas but are not templates. The Excel Macro-Enabled Workbook (.xlsm) is specifically for workbooks that contain macros, allowing for automation but not designed for templating. The Excel Binary Workbook (.xlsb) is an alternative format for efficient file storage, particularly for large datasets, but it does not serve as a template format either. Thus, the .xltx format is the only choice that aligns with the requirement to save a workbook as a template.