Scribd
Upload
14 views2 pages

Excel INDEX MATCH Practice Data

The document contains employee salary information for the months of January, February, and March, detailing names, departments, and salaries. It includes questions regarding the row and column positions of selected employees and their respective salaries. Specific answers are provided for selected employees, particularly Siddharth Patel, across the three months.

Uploaded by

ROHIT SINGH TOMAR
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
14 views2 pages

Excel INDEX MATCH Practice Data

The document contains employee salary information for the months of January, February, and March, detailing names, departments, and salaries. It includes questions regarding the row and column positions of selected employees and their respective salaries. Specific answers are provided for selected employees, particularly Siddharth Patel, across the three months.

Uploaded by

ROHIT SINGH TOMAR
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

January Drop Down selections

Employee Name Department Salary Month Empoyee Names


Priya Singh IT ₹ 49,841 March Siddharth Patel
Rahul Verma HR ₹ 85,688
Meera Joshi Finance ₹ 51,756
Rohan Mehra Marketing ₹ 41,454
Aarav Sharma RD ₹ 62,812 MATCH
Siddharth Patel Sales ₹ 47,516 Q1. Find the Row position of Selected Em
Ans. 6
February
Employee Name Department Salary Q2. Find the Column position of Selected
Priya Singh IT ₹ 52,341 Ans. 3
Rahul Verma HR ₹ 88,188
Meera Joshi Finance ₹ 54,256 INDEX (v1)
Rohan Mehra Marketing ₹ 43,954 Q3. Find the Salary of Selected Employee
Aarav Sharma RD ₹ 65,312 Ans. ₹ 47,516
Siddharth Patel Sales ₹ 50,016
INDEX (v2)
March Q4. Find the Salary of Selected Employee
Employee Name Department Salary Ans. ₹ 55,016
Priya Singh IT ₹ 57,341
Rahul Verma HR ₹ 93,188
Meera Joshi Finance ₹ 59,256
Rohan Mehra Marketing ₹ 48,954
Aarav Sharma RD ₹ 70,312
Siddharth Patel Sales ₹ 55,016
wn selections
Headers January
Salary February
March

w position of Selected Employee Name in January month

umn position of Selected Header Name in January month

ary of Selected Employee Name for the January Month

ary of Selected Employee Name for the Selected Month


50016

You might also like