Question

Explain the use of any five function of MS-Excel by giving examples

Answer 1

Use of any five features of MS EXCEL with examples are :

(i) Simple Design : The Design of MS EXCEL is simple and looks very professional.

(ii) Autosum Feature : In excel, you can Autosum any number by just right clicking and hold the button till u drag the cursor till the last number you want to calculate. It is really very fast and good for calculation purposes.

(iii) Charts : One of the best features of excel is that you can make charts of the data that you entered in excel. There is a large variety of charts in excel like Coloumn, pie, line,doughnut, area, sparkline etc.

(iv) Autofill Feature : This is also a very important feature provided in ms excel. It does that if u enter a data in sequence which is universal true, you can go to bottom most corner of the cell and drag it using right click till u get the required amount of Autofill result. It is valid for things like weeks, months, several pattern of numbers.

(v) Add header of footer : Excel allows us to add header and footer, for example header is the heading and is placed in uppermost and footer is printed bottom most of page.

Use of any five functions in MS EXCEL are :

(i) Sum : It is used to add several numbers and get the desires result. For example, 1+2+3+4+5 = 15

(ii) Average : It is used to calculate the average of several number. For example, Average of 1,2 and 3 is 2.

(iii) Maximum : It is used to get the maximum number of the data entered. For example, maximum number from 23,45,65,12,78 is 78.

(iv) Minimum : It is used to get the minimum number of the data entered. For example, minimum nunber from 23,45,65,12,78 is 12.

(v) IF

The IF function is often used when you want to sort your data according to a given logic. For example, IF(logical_test, [value_if_true], [value_if_false])