Functions of MS Excel
24) Save as workspace - To save your multiple workbook with specific name, in other words we can say it gives the permission to the user to merge the number of file and can easily open in same window.
25) Name manager - Under this command we can execute the various other commands to operate the number of table like define name, use in formula, create from the selection, in other words we can say it execute the entire table as a formula.
26) Trace dependent - To show the arrow that indicate, what cell affect the value of the currently selected cells.
27) Trace precedent - To show the arrow that indicate, what cell affect the value of selected multiple cells.
28) Find - To find or search a text string from the selected paragraph.
Shortcut key is Ctrl + F
29) Replace - To change or replace any text string with other one.
Shortcut key is Ctrl + H
30) Go to - To go for target cell or selected value range.
Shortcut key is Ctrl + G
31) Conditional formatting - Highlight interesting cells, emphasizes unusual value and highlight the value according to given condition with specific color.
32) Format painter - By this command you can fill the same color pixel value for the target cell.
33) Zoom - By this command you can set the zooming value for the entire worksheet like 25%, 50%, 75%, 100% etc.
34) New - To insert a new workbook in Excel application.
Shortcut key is Ctrl + N
35) Open - To open any existing file which is saved by you with special keywords.
Shortcut key is Ctrl + O
36) Save as - To save your exist workbook with other name, in other words we can say it creates a duplicate file of your current existing file.
37) Undo - By this command you can go for backward step of current using command.
Shortcut key is Ctrl + Z
38) Redo - To go forward position of the worksheet.
Shortcut key is Ctrl + Y
39) Cut - To cut the data from one location & paste it to another location.
40) Copy - To copy the data which is selected by you.
41) Paste - To paste the data for target location which is lastly copied by you.
42) Paste special - It is special process to paste the data because it explains the format & linking for the pasting.
43) Save - To save new workbook with given specific name with its extension.
Shortcut key is Ctrl + S
44) Custom view - To set the view for target cell with specific name.
45) Hyperlink - To link any text string with specific file.
46) Filter - It contains two commands to filter the number of data.
47) Auto filter - To create a drop down list from the selected table.
48) Advance filter - It is advance process to filter the data from the selected table. Under this command we can give the condition criteria for the selected table. Like : - is greater than, is less than, between
Note: In this command you can also insert a message for the selected cell.
49) Print preview - To display the preview of current existing file before the print.
Shortcut key is Ctrl + F2
50) Print - To print the number of data on a page.
Shortcut key is Ctrl + P
51) Left - To return the left most character from the text string.
Syntax: =Left("text",number) (enter)
52) Right - To return the right most character from the text string.
Syntax: =right("text",number) (enter)
53) Mod - To return the reminder value from the selected value.
syntax: =mod(numbers,divisor) (enter)
54) Pivot table - To insert a table with headings. In this option we can show our matter with optional.
Example: Name & Salary
55) Table - To insert a Table with predefine headings.
56) Pictures - To insert a bit mapped or jpg image from the browser window.
57) Clip art - To insert different kind of clip arts.
Example: Nature, Animals, Home, Computer etc.
58) Auto shape - It contains various other drawing or graphic.
Example: Arrow, Shape, Smiley face etc.
59) Header - It appears on the top location of the document on which you can specify the name of Company & Address.
60) Footer - It appears at bottom location of the document on which you can specify the Email ID, Website contact number of Company.
61) Object - It gives the permission to the user to insert external data of graphic from other application software.
62) Symbol - To insert a predefine symbol for the entire sheet.
63) Margins - There are many margins to sheet. In other words we can say it is used to leave space around the page then we can use this optional.
64) Orientation - There are two types of Orientation :- (i) Portrait orientation (ii)
By using this option we can set our matter in length or width page.
65) Print area - By using this command we can set print area in selected matter in sheet.
66) Define name - It gives the permission to the user to execute define name for any value selection. In other words we can say we can use define name in formula.
67) Sort - To set the number of data in ascending order.
68) Remove duplicate - By this command we can remove the duplicate value from the selected criteria.
69) Consolidate - To adjoin maximum number of sheet data in same or target worksheet. You can execute the various functions to calculate the number of data.
70) Translate - It gives the permission to the user to translate the specific text string with another language.
24) Save as workspace - To save your multiple workbook with specific name, in other words we can say it gives the permission to the user to merge the number of file and can easily open in same window.
25) Name manager - Under this command we can execute the various other commands to operate the number of table like define name, use in formula, create from the selection, in other words we can say it execute the entire table as a formula.
26) Trace dependent - To show the arrow that indicate, what cell affect the value of the currently selected cells.
27) Trace precedent - To show the arrow that indicate, what cell affect the value of selected multiple cells.
28) Find - To find or search a text string from the selected paragraph.
Shortcut key is Ctrl + F
29) Replace - To change or replace any text string with other one.
Shortcut key is Ctrl + H
30) Go to - To go for target cell or selected value range.
Shortcut key is Ctrl + G
31) Conditional formatting - Highlight interesting cells, emphasizes unusual value and highlight the value according to given condition with specific color.
32) Format painter - By this command you can fill the same color pixel value for the target cell.
33) Zoom - By this command you can set the zooming value for the entire worksheet like 25%, 50%, 75%, 100% etc.
34) New - To insert a new workbook in Excel application.
Shortcut key is Ctrl + N
35) Open - To open any existing file which is saved by you with special keywords.
Shortcut key is Ctrl + O
36) Save as - To save your exist workbook with other name, in other words we can say it creates a duplicate file of your current existing file.
37) Undo - By this command you can go for backward step of current using command.
Shortcut key is Ctrl + Z
38) Redo - To go forward position of the worksheet.
Shortcut key is Ctrl + Y
39) Cut - To cut the data from one location & paste it to another location.
40) Copy - To copy the data which is selected by you.
41) Paste - To paste the data for target location which is lastly copied by you.
42) Paste special - It is special process to paste the data because it explains the format & linking for the pasting.
43) Save - To save new workbook with given specific name with its extension.
Shortcut key is Ctrl + S
44) Custom view - To set the view for target cell with specific name.
45) Hyperlink - To link any text string with specific file.
46) Filter - It contains two commands to filter the number of data.
47) Auto filter - To create a drop down list from the selected table.
48) Advance filter - It is advance process to filter the data from the selected table. Under this command we can give the condition criteria for the selected table. Like : - is greater than, is less than, between
Note: In this command you can also insert a message for the selected cell.
49) Print preview - To display the preview of current existing file before the print.
Shortcut key is Ctrl + F2
50) Print - To print the number of data on a page.
Shortcut key is Ctrl + P
51) Left - To return the left most character from the text string.
Syntax: =Left("text",number) (enter)
52) Right - To return the right most character from the text string.
Syntax: =right("text",number) (enter)
53) Mod - To return the reminder value from the selected value.
syntax: =mod(numbers,divisor) (enter)
54) Pivot table - To insert a table with headings. In this option we can show our matter with optional.
Example: Name & Salary
55) Table - To insert a Table with predefine headings.
56) Pictures - To insert a bit mapped or jpg image from the browser window.
57) Clip art - To insert different kind of clip arts.
Example: Nature, Animals, Home, Computer etc.
58) Auto shape - It contains various other drawing or graphic.
Example: Arrow, Shape, Smiley face etc.
59) Header - It appears on the top location of the document on which you can specify the name of Company & Address.
60) Footer - It appears at bottom location of the document on which you can specify the Email ID, Website contact number of Company.
61) Object - It gives the permission to the user to insert external data of graphic from other application software.
62) Symbol - To insert a predefine symbol for the entire sheet.
63) Margins - There are many margins to sheet. In other words we can say it is used to leave space around the page then we can use this optional.
64) Orientation - There are two types of Orientation :- (i) Portrait orientation (ii)
By using this option we can set our matter in length or width page.
65) Print area - By using this command we can set print area in selected matter in sheet.
66) Define name - It gives the permission to the user to execute define name for any value selection. In other words we can say we can use define name in formula.
67) Sort - To set the number of data in ascending order.
68) Remove duplicate - By this command we can remove the duplicate value from the selected criteria.
69) Consolidate - To adjoin maximum number of sheet data in same or target worksheet. You can execute the various functions to calculate the number of data.
70) Translate - It gives the permission to the user to translate the specific text string with another language.
Arif Khan is a passionate Tutor & Blogger writes on Educational Topics. He also uploads his Tuition status on The AK Tuition.
No comments
Thank You for your comments