Question

Your Excel 2007 file is stored with the extension "_______".
1. .zltx
2. .docx
3. .xlsx
4. .xltx

Answer 1

Correct Answer - Option 3 : .xlsx

The correct answer is .xlsx.

 

• .xlsm
  • The XML-based and macro-enabled file format for Excel 2016, Excel 2013, Excel 2010, and Excel 2007.
  • Stores VBA macro code or Excel 4.0 macro sheets (.xlm).
• .xlsb
  • The binary file format (BIFF12) for Excel 2010 and Excel 2007.
• .xltx
  • The default file format for an Excel template for Excel 2010 and Excel 2007.
  • Cannot store VBA macro code or Excel 4.0 macro sheets (.xlm).
• .xltm
  • The macro-enabled file format for an Excel template Excel 2010 and Excel 2007.
  • Stores VBA macro code or Excel 4.0 macro sheets (.xlm).

 

• Hide or Unhide Rows or Columns
• There are several dedicated keyboard shortcuts to hide and unhide rows and columns.
  • Ctrl+9 to Hide Rows
  • Ctrl+0 (zero) to Hide Columns
  • Ctrl+Shift+( to Unhide Rows
  • Ctrl+Shift+) to Unhide Columns – If this doesn't work for you try Alt, O, C, U (old Excel 2003 shortcut that still works).