![]() ![]() Objective:The purpose of this exercise is to extract information from worksheet.Ģ. 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. 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. ![]() 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |