BASIC FUNCTIONS OF EXCEL

Let's start some Basic Functions which are there when you open Ms-Excel File. Let's see the file image when you open the MS-Excel file. You can open a file you can press Window Key from your keyboard+R and type there EXCEL. It will open excel new file like this image. Or there is option in open Excel when you press on window key.

Here we will see how functions are working cut,copy, paste, format painter etc. These are all functions of Home Menu. Here we should have some data for use these functions. We will use mouse and some functions and commands we will do with keyboard. These all functions have given are functions of home menu. Files are used in excel in the form of table. Let us take an example of this below file.

We will do all the options one by one. as you see total column is blank. First we fill this column. Just select the rows or columns which do you want to sum. Just click auto sum on the right side of menu bar.

Now if you want to add other student's total, you don't need to auto sum every time, just place your mouse cursor on Paras total and drag it or double click here. It will show the answer.

here you will see the answer.

Now you will see cut, copy and paste option. Select the date what do u want to cut, copy and paste. Select the data which do u want to cut and select the other cell where do u want to paste it and click the paste. As well as you can do copy paste. You can do the commands which are showing in home menu bar. Options are in the left side of menu bar. You can use shortcut commands by keyboard also that is for CUT (Ctrl+X), For Copy (Ctrl+C), and for paste (Ctrl+V). You can also use these commands instead of using mouse.

There is also a main function of paste that is paste special but we will learn it later because there are many options which are used in paste special. We have to copy and then choose paste special. First we have to select data and click copy and then paste special and then option we want to choose. Have a look about Paste Special.

Now Lets know about Font (Style of Typing), Size of Text, Bold, Italic and Underline Text. See in the image and where I mark in the images there are options of font, size, Bold, Italic and underline. where is write calibri is font you can check and do font of what you like to give your text and size also. There is also write B, I and U in image. B means bold your text, I means Italic your text. and U means underline your text. Let us see image.

Here you see I have mentioned in the image which is font, font size, bold, italic and underline. I have given command Harish as bold, Geeta as Italic and Manisha is underline. You will know exactly when you do it same. I am giving you shortkut keys of these Commands.
Bold:         Ctrl+B
Italic:         Ctrl+I
Underline: Ctrl+U
Font and Font Size: Shift+Ctrl+F

There are two options showing with Font size, one is for increase font size and other is for decrease font size. and showing color is one for cell color and second is for font color. Now let us see how to add border of your data. Just select your data and there is a option to fill the border. Have a look in the image.

Here you can see and choose option what do u want to choose. But most probably we choose all borders option. Have a look image.










We Will see other options in next Post.
Thanks.