EXCEL PRACTICAL QUESTIONS - 5

EXCEL PRACTICAL QUESTIONS
VLOOKUP AND HLOOKUP FORMULA

WORKSHOP - 1
Create the following data sheet in MS Excel.

1. Find the employee name, department and salary with help of Vlookup formula.

Note: Use the Emp. Code column data as search key in the Vlookup function. 

WORKSHOP - 2
Create two worksheet in MS-Excel.
1. Discount sheet
2. Product_Item sheet

DISCOUNT SHEET

PRODUCT_ITEM SHEET

1. Find the Discount Rate in the Product_Item sheet from the Discount sheet by help of Vlookup function.

Note: Use the Price column data as search key in the Vlookup function.

PRACTICE QUESTION (SET - 1)

PRACTICE QUESTION (SET - 2)

PRACTICE QUESTION (SET - 3)

PRACTICE QUESTION (SET - 4)

PRACTICE QUESTION (SET - 5)

HOME