Filter: -Here filter means display the records conditionally. There are two types filter used in MS-Excel: -

Ø Auto Filter

Ø Advanced Filter

Auto Filter: -It is a part of filter method when you use the auto filter then a combo box will come out of selected data range then you select any one particular record.

Process: -

Ø Select your data range

Ø Click on data tab

Click on filter

Advance filter: - It is also part of filter this command is used for filtering the condition out of data range.

ROLL	NAME	PHY	CHE	MATH	TOTAL
1	RAJ	78	87	67	232
2	SOHAN	45	87	78	210
3	JILANI	67	98	98	263
4	AMIT	89	76	45	210
5	IRSHAD	67	56	67	190
				MATH
				>=80

ü Create a condition out of data range

ü Select your data range

ü Click on home tab

ü Click on advance

Then a dialog box open

List range: -It means data range

Criteria range: -It means condition cell address

Copy to: -It means result cell address

ü Check copy to another location

ü Click on Ok

Text to columns: -It is used to split the data in one cell into separate columns.

Process: -

ü Select your cell

ü Click on data tab

ü Click on text to columns

ü Check delimited option

ü Click on next

ü Check any option (Like: -Comma, Semicolon, Space etc)

ü Click on next

ü Click on finish

 Validation: -MS-Excel provides the features of validation which used to specify as user need condition on selected cells and also given message after specified the condition when the user enter as your required data and the enter data does not satisfied your specified condition then ignore and display message.

Process: -

ü Select your cell range

ü Click on data tab

ü Click on validation

ü Then a dialog box open

ü Click on setting tab

ü Click on allow drop down list and select whole number

ü Enter minimum and maximum value

ü Click on error alert tab and enter message (Please enter your value >=80 &<=30)

ü Click on ok

Goal Seek: -It is an analysis of MS-Excel which used to modify the value of precedents cell that increase or decrease with current row single cell.

Process: -

ü Select your precedents cell value

ü Click on data tab

ü Click on what if analysis

ü Click on goal seek

Then a dialog box open

Set cell: -It means enter that cell address which you have to modify.

To value: -It means target cell address.

By changing cell: -It means that cell address which you have to share the value.

ü Click on ok

ü Again click on ok

Scenario: -It is an analysis of MS-Excel which used to modify the value of depending cell and final change to precedents cell.

Process: -

ü Select your data range which you have to modify

ü Click on data tab

ü Click on what if analysis

ü Click on scenario

ü Click on add button

ü Enter any name

ü Click on ok

ü Modify the value of selected cells

ü Click on ok

ü Click on show

Subtotal: -MS-Excel provides the feature of subtotal which used to calculate subtotal and grand total value according to control field to generate subtotal of numeric field the record must be sorted on ascending or descending.

Process: -

ü First sort your data in ascending or descending order

ü Click on data tab

ü Click on subtotal

ü Then a dialog box open

ü Select as your required field from at each change in drop down list

ü Select as your required function

ü Check as your required numeric field

Click on ok