When you right-click and select the 'Format Cells' option in MS Excel 2010, which of the following Tab is NOT visible?

The correct answer is Sheet.

Key Points

• The Format Cells dialog box has the following options for formatting cells:
  • The number tab – allows you to specify the numerical data type. For example, currency, date, percentage.
  • Fill – allows you to add shading and background colors to a cell.
  • Protection – allows you to lock or hide a cell.
  • Border – allows you to select a border style for your cell from a variety of different options.
  • Font tab – allows you to change the attributes of cell font, including font face, size, style, and color.
  • Alignment tab – allows you to change the position and alignment of the data within a cell.

Additional Information

Some important shortcuts used in MS Excel:

• Ctrl + N Create a new workbook.
• Ctrl + O Open an existing workbook.
• Ctrl + S Save the active workbook.
• F12 Save the active workbook under a new name, displays the Save as dialog box.
• Ctrl + W Close the active workbook.
• Ctrl + C Copy the contents of the selected cells to Clipboard.
• Ctrl + X Cut the contents of the selected cells to Clipboard.
• Ctrl + V Insert the contents of the Clipboard into the selected cell(s).