Explain in detail format menu of MS-Excel 2010.
Answers
Answer:
Find out Format Cells in Ribbon if you do not have Classic Menu for Office
Click the Home tab;
Go to Cells group;
Click the Format button;
Then you will view that at the bottom of Format button. drop down list is Format Cells items.
Answer:
Explanation:
Cells... --- The Cells... menu item opens the cell format dialog. This dialog is used to set cell data types and formats. It is explained in Section 9.1.
Column --- The Column menu item opens a sub-menu with choices to allows the user to modify the view of the selected columns.
Row --- The Row menu item provides the same functions as the Column menu item but operates on rows.
Sheet --- The Sheet menu item opens a sub-menu with operations to change properties of the worksheet.
Autoformat... This menu item opens the autoformat dialog to give user access to a list of format templates. Format templates are useful for users who are often filling out tables in a particular format. The user picks an area of the worksheet into which they want to apply the template.
Workbook... This menu item opens a dialog which allows users to configure the current workbook. The dialog currently has four choices.
Text autocomplete can be unset which means that numeric will not compare text as it entered against text in above it in the column