Start /Open the Ms- Excel
Intro.To Ms- Excel Screen
Menu Name
Menu Options
Menu Name
Menu Options
File Menu
Show The Task Pane.
Create The New Blank Work Book.
Type The Text In Work Sheet.
Save The Work Book/File.
Close The Work Book/File.
Open The Work Book/ File.
Create The Template Work Book.
Save As The Work Book/File.
Save The Work Book As A Web Page.
Save The Workspace.
Search The File/ Work Book.
Display The Web Page Preview.
Display The Page Preview.
Set The Top Margins.
Set The Bottom Margins.
Set The Left Margins.
Set The Right Margins.
Set The Sheet Orientation Portrait.
Set The Orientation Landscape.
Set The Scaling.
Set The Paper Size.
Create The Header & Footer.
Set The Gridlines At The Print Time.
Set The Row & Column Headings At The Print Time.
Set The Page Order.
Set The Print Area.
Clear Print Area.
Print The File.
Set The File Properties.
Edit Menu
Undo.
Redo.
Cut.
Copy.
Paste.
Paste Only Formulas.
Paste Only Values.
Paste Only Formats.
Paste Only Comments.
Paste As Hyperlink.
Show Office Clipboard.
Fill The Down.
Fill The Right.
Fill The Up.
Fill The Left.
Fill The Series.
Justify The Text.
Clear All Selected Cells.
Clear Only Formats.
Clear Only Contents.
Clear Only Comments.
Delete The Selected Cells And Shift The Left Cells.
Delete The Selected Cells And Shift The Up Cells.
Delete The Selected Row.
Delete The Selected Column.
Delete The Selected Sheet.
Move The Sheet.
Copy The Sheet.
Find The Specify Text.
Find And Replace The Specify Text.
Go To Any Cell Address.
View Menu
Display The Normal View.
Display Page Break Preview.
Show / Hide The Tack Pane.
Show/ Hide The Toolbar.
Show/ Hide The Formula Bar.
Show/ Hide Status Bar.
Create The Header & Footer.
Show/ Hide The Comments.
Create Or Show The Custom View.
Display The Full Screen.
Set The Zoom Setting.
Insert Menu
Insert The Cells Right.
Insert The Cells Down.
Insert The Row.
Insert The Column.
Insert The Worksheet.
Insert The Chart.
Insert The Chart Title.
Insert The Category Title(X).
Insert The Chart Category Title (Y).
Show/ Hide The X Or Y Asix Values.
Show/Hide The Gridlines In Chart.
Show/ Hide The Legends In Chart.
Change The Placement Of Legends.
Show/Hide The Data Labels.
Show/Hide The Data Table In Chart.
Set The Insert Chart Place Active Sheet Or New Sheet.
Insert The Page Break And Create The New Page.
Insert The New Comment.
Insert The Clip Art In Active Sheet.
Insert From File.
Insert Auto Shapes In Active Sheet.
Insert The Word Art In Active Sheet.
Insert The Diagram In Active Sheet.
Insert The Hyperlink.
Format menu
Format The Cells Value In Decimal Place.
Format The Cells Value In Currency Format.
Format The Cells Value In Date Format.
Format The Cells Value In Percentage Format.
Format The Cells Value In Fraction Format.
Format The Cells Value In Text Format.
Format The Cells Value In Custom Format.
Format The Cells Value In Normal Format.
Format The Selected Cells Text Orientation.
Format The Cells Text Alignment Horizontal Left.
Format The Cells Text Alignment Horizontal Center.
Format The Cells Text Alignment Horizontal Right.
Format The Cells Text Alignment Vertical Top.
Format The Cells Text Alignment Vertical Bottom.
Format The Cells Text Alignment Vertical Center.
On/ Off The Text Wrap In Selected Cells.
On/ Off The Shrink To Fit In Selected Cells.
Merge The Selected Cells.
Format The Font Style In Selected Cells.
Format The Font Style Bold In Selected Cells.
Format The Font Style Italic In Selected Cells.
Format The Font Size In Selected Cells.
Format The Font Style Underline In Selected Cells.
Format The Font Color In Selected Cells.
Display The Border.
Change The Border Color And Style.
Remove The Border.
Format The Pattern In Selected Cells.
Change The Selected Row's Hide.
Auto Fit The Selected Row.
Hide The Selected Row.
Unhide The Selected Hide Row.
Change The Selected Column Width.
Auto Fit The Selected Column.
Hide The Selected Column.
Unhide The Selected Hide Column.
Change The Standard Width.
Rename The Active Sheet.
Hide The Active Sheet.
Unhide The Hide Sheet.
Change The Sheet Background.
Auto Format The Active Sheet.
Format The Selected Cells In Conditional Formatting.
Change The Active Sheet Style.
Tools Menu
Check The Spelling Errors.
Set The Track Changes.
Accept or Reject Changes.
Protect The Active Sheet.
Unprotect The Protect Sheet.
Protect Workbook.
Unprotect The Protect Workbook.
Find The Missing Value By Goal Seek.
Create And Save The Scenarios.
Set The Data Result In Scenarios.
Display And Use The Scenarios Value.
Delete The Scenarios Sheet And Name.
Use The Auditing Trace Precedents.
Use The Auditing Trace Dependents.
Remove All Show Arrows.
Show The Evaluate Formula Value.
Show The Watch Window.
Show The Auditing Toolbar In Formula Auditing Mode.
Show The Formula Auditing Toolbar.
Define The Macro.
Run The Macro.
Delete The Macro.
Create The Auto Correct.
Use The Auto Correct Word.
Delete The Auto Correct Word.
Create Custom Menu And Toolbar.
Set The Excel Setting.
Data Menu.
Sort The Table Data In Ascending.
Sort The Table Data In Descending.
Define The Heading Row.
Auto Filter The Data.
Show The Data In Condition.
Show All Data Remove The Auto Filter.
Display The Data in Form View.
Display The Data In Form View With Criteria.
Delete The Record In Form View.
Add New Record In Form View.
Sub Total The Selected Data.
Remove The Sub Total Column.
Set The Input Message In Validation.
Set The Validation Criteria.
Set The Error Alert Message In Stop.
Set The Input Alert Message Warning.
Set The Input Alter Message Information.
Clear All Validation And Message.
Display The Data In Text to Column.
Create The Group Of All Selected Columns.
Create The Group Of All Selected Row.
Show/ Hide The Details Of Group Columns.
Ungroup The Selected Group Row.
Group The Auto Outline.
Clear The Outline.
Window
Create The New Window.
Arrange All Open Window With Tiled Case.
Arrange All Open Window With Horizontal Case.
Arrange All Open Window With Vertical Case.
Arrange All Window With Cascade Case.
Hide The Active Window.
Unhide The Active Window.
Split The Active Window.
Change The Split Window Size.
Freeze The Panes.
Unfreeze The Panes.
Remove The Panes.