SOME OTHER FUNCTIONS OF EXCEL

Important Functions:

There are some other important functions which are used in Home Menu Here we will know about that functions. One important function is in when Save, Undo and Redo is in upside, and we can open other functions also. Just have a look on image.

By click an arrow we can enable New Options Like New for make new file, Open for open an existing file and many more and by clicking More Commands there would be show many commands we can enable. Save, Undo and Redo are default enable while we open EXCEL. We use Save for our file where we are doing our work, Undo if we have done wrongly delete some value and we want that value again, Undo is for going back our work. In file if we had delete the word Sham and we want it again except type it then we press Undo and if we want to again delete at that time we press Redo. Redo is just opposite of Undo. We use some shortcut keys of these commands if we don't want to use mouse. Short cut command of Select All is Ctrl+A.

Save:        Ctrl+S

Undo:       Ctrl+Z

Redo:       Ctrl+Y

Select all: Ctrl+A

Now we will see the use of Format Painter, Wrap Text and Merge at Center. For a big data these functions are necessarily used in Excel. Now we will see the functions of Format Painter and Wrap Text.

FORMAT PAINTER:

                                  Here to show you, I have change one cell's font and size and copy paste it to other cells. Format Painter is mostly used in excel. If we want to format it as it is we select for format it will automatically change. Have a look at the image.

In the image both cell's data is same and if we want to change some data select which font and size data do u want to give cell Ashu, that its size and font is different. Let us suppose that you want to change is like Paras. Then click on Paras and then select Format Painter and then click on cell Ashu it will look like Paras. Have a look on image.  

Here in this image we had selected cell Paras and then click on Format Painter. We want to change Font Color, Font Style and Font Size like exactly cell Paras so we select Paras for Format Painter. Select Paras then Format Painter then cell Ashu, it will look like as cell Paras, every thing would be change Just have a look and image.

WRAP TEXT:

                        If we want to write some big text like Total of subjects instead of Total, it will not show in small column. We have to increase our Column's Size. Then it will show properly. See image.

Here we increase the size of the column Total of Subjects for show proper text in Border. Wrap Text is used if we don't want to increase the size of the cell and fit it to the column. Have a look at the image. Wrap Text is used of our facility. If we don't want to increase the size of column then wrap text is used. Like if we want to print something in one page, it will take more than one page then we can use wrap text. 

See an image.

You can use wrap text like this.














Hi "Merge and Center" is big work done by this software. So we will do this command. Like if we want to write in data of all student's marks or All Class  Subject Marks. then it will not possible to write in one cell. Have a look.

In the image we can see that All Class Subject Marks is written in column A but other columns are empty. So for show in all the columns we use the command Merge at Center. Then it will show in all the columns. We will use the command like this. First click the row 1 and then click on insert. It will insert a row above row 1.
Then write what do u want to write. Our data is from column A to Column G. Select from column A to column G in row 1. Then select Merge at Center command. It will adjust and do your written in center. Have a look by image.

 Hi, Here are some more options here you can use some more commands, like Sort and Filter. Other commands are not most important used in professionally. Otherwise if you want to know any command I will tell you. I will tell here sort and filter just look at the images.
Sort: 
        Here you can sort of numbers or name ascending or descending order. Select the cell which do u want to sort in ascending or descending order. See the image.

You can see in the image there are many options in  Sort and Filter. When you click on arrow there are many options.





Here is an option showing filter. You can click on filter and see all the options which are showing by filter the document yourself. Select the cell where do u want to open a filter and select on filter. Filter will apply on all the first cells. Have an image of FILTER for you.

Click on the arrow and it will show like the below image. If we want to show a single person subject's marks, then it will show. It will show result how many NAMES with select. Have a look an image with this.

In the showing above image we have selected only GEETA. It will show all marks subject's result of GEETA and hide other persons result.

It is showing all the result, all subject's marks and TOTAL of GEETA. Filter is a main work done in Excel.



Here are necessarily options used in BASIC HOME MENU which use when we open any excel file. These options are showing and do most important functions for us. These options have many work in professional field. We don't need to use other functions. Other options are miscellaneous. If u need, I will tell you option which you say, PLEASE Tell me in comments. How you like my posts. Please comment me and follow my blog.

I will tell other options in Next Post.

THANKS!!!