Problem

Procedure

View data using database features

Microsoft Excel has a limited database features like Sorting the Data, Querying Data on specified criteria, Filter, Subtotals and Pivot Tables.

I. Copy the entire data in DESCRIPTIVE Worksheet to New Worksheet and rename this sheet as Database

Sort Database : In the present database Villages are not in sort order . Now it will be sort on villages

1. Position the mouse pointer in Cell A1
2. Select SORT Option from the DATA Menu
3. Select VILLAGE as the option for SORT BY
4. Select ASCENDING as option for Sort order
5. Select N as the option for THEN BY
6. Select ASCENDING as option for Sort order
7. Click OK .

Then it will display the data in villages order Calculating Village wise Averages for each parameter

1. Copy the entire data in DATABASE Worksheet to New Worksheet and rename this sheet as SUBTOTAL
2. Select SUBTOTAL Option from the DATA Menu
3. Select VILLAGE as the option for AT EACH CHANGE IN
4. Select AVERAGE as option for, USE FUNCTION
5. Select the required parameters for which villages wise Average to be calculate. ( Crop Yield, Total Land Holding , FYM, N, P , K etc..)
6. Click OK to get the Required Averages

Querying Database : Display the data only for Village E

1. Copy the entire data in DATABASE Worksheet to New Worksheet and rename this sheet as FILTER
2. Clicj on DATA Menu
3. Select AUTO FILTER option FILTER Sub Menu. Then this command will assign drop down button to each data columns in the worksheet automatically.
4. Click on the button in Village Column
5. Select VILLAGE from the displayed list of Villages Then it will display the data for Village E only.