![microsoft excel 2007 practical exercises microsoft excel 2007 practical exercises](https://i.gr-assets.com/images/S/compressed.photo.goodreads.com/books/1349011725i/2035406._UY630_SR1200,630_.jpg)
In the Sort By option select REGION and the Ascending option. For a different sort, highlight the column headings, open the Data menu, and select theĦ. The data in the spreadsheet is now arranged from the highest to the lowest value.Ĥ. Select the MURDER label, select the Descending option, and then click on the OK button. This provides a list of all the variable labels in the first row of the spreadsheet. Click on the down arrow button in the Sort By option. Since the first row of the spreadsheet has data labels we do not want these labels to be sorted with the data, select My list has Header Row.ģ.
![microsoft excel 2007 practical exercises microsoft excel 2007 practical exercises](https://d13ot9o61jdzpp.cloudfront.net/images/INDEX_MATCH1.png)
(Note: At the top-right of the Sort Options screen the My List Has No Header Row option is selected. Open the Data menu and select the Sort option. Highlight the column headings for columns A through G.Ģ. Arrange data in ascending order with respect to Region and then with respect to State in the given data. Arrange data in ascending order with respect to the column of Murder in the given data.2. Show all employees whose names starts with A & SĮxercise: 1. Show all employees who are working in department no. Show all employees whose salary is between 1500 to 25006. Show all employees whose salary is less than 20005. Objective:The purpose of this exercise is to extract information from worksheet.Ģ. The following option of MS-Excel will be usedĢ. Objective:The purpose of this exercise is to filter out information from worksheet. The Hlookup() formulas will be used in this exercise. Objective:The purpose of this exercise is to find out data using HLOOKUP formula. The vlookup() formulas will be used in this exercise.Ģ. Objective:The purpose of this exercise is to calculate grades using Vlookup formula. of flights coming on terminal 2 using formula. You have to find out the city, departure time and terminal of Flight No. Instructions:The following formulas of MS-Excel will be used in this exercise.Ģ. Objective:The purpose of this exercise is to find out data using Vlookup formula. Add a column for Remarks after grade column7. In M1 and M2 columns value greater than 15 not allowed3. Objective:The purpose of this exercise is to create students Marks sheet.ġ. Calculate total salary of those employees whose salary is less than 500010.
![microsoft excel 2007 practical exercises microsoft excel 2007 practical exercises](https://d20ohkaloyme4g.cloudfront.net/img/document_thumbnails/994675c0cb5bbf29fc1d0575f4610524/thumb_1200_1553.png)
Calculate Tax (if Gross is greater than 15000 then 10% otherwise 0)8. Calculate Medical Allowance (if Basic Salary is greater than 5000 then 60% otherwise 45%)6. Allowance (if Basic Salary is greater than 5000 then 30% otherwise 20%)5. Calculate House Rent (if Basic Salary is greater than 5000 then 45% otherwise 30%)4. In Basic Salary column values greater than 10,000 not allowed3. Instructions:The following options & formulas of MS-Excel will be used in this exercise.ġ. Objective:The purpose of this exercise is to create employees salary sheet.