Scribd
Upload
14 views4 pages

Data Analyst & Data Science Tasks

Uploaded by

Gyan Anand
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 views4 pages

Data Analyst & Data Science Tasks

Uploaded by

Gyan Anand
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
You are on page 1/ 4

Q: Using Excel Formula seperate first name, last name and User ID

Full Name User ID First NameLast Name User ID


Andrew Carnegie 1001 Andrew Carnegie 1001
Henry Ford 1002 Henry Ford 1002
Oprah Winfrey 1003 Oprah Winfrey 1003
Larry Page 1004 Larry Page 1004

𝐏𝐥𝐞𝐚𝐬𝐞 𝐬𝐮𝐛𝐦𝐢𝐭 𝐲𝐨𝐮𝐫 𝐭𝐚𝐬𝐤𝐬 𝐛𝐲 𝐬𝐞𝐧𝐝𝐢𝐧𝐠 𝐢𝐭 𝐝𝐢𝐫𝐞𝐜𝐭𝐥𝐲 𝐭𝐨 𝐨𝐮𝐫 𝐋𝐢𝐧𝐤𝐞𝐝𝐈𝐧 (𝐃𝐌) 𝐚𝐧𝐝 𝐚𝐥
𝐋𝐢𝐧𝐤𝐞𝐝𝐈𝐧 (𝐃𝐌) 𝐚𝐧𝐝 𝐚𝐥𝐬𝐨 𝐬𝐡𝐚𝐫𝐞 𝐚 𝐜𝐨𝐩𝐲 𝐯𝐢𝐚 𝐞𝐦𝐚𝐢𝐥.
Q: Using Excel VLOOKUP formula, fetch the Department and Salary of employees based on thei

Employee ID Name Department Salary

101 John Smith HR 45000


102 Mary Johnson IT 60000
103 David Brown Finance 55000
104 Susan Clark Marketing 50000

𝐏𝐥𝐞𝐚𝐬𝐞 𝐬𝐮𝐛𝐦𝐢𝐭 𝐲𝐨𝐮𝐫 𝐭𝐚𝐬𝐤𝐬 𝐛𝐲 𝐬𝐞𝐧𝐝𝐢𝐧𝐠 𝐢𝐭 𝐝𝐢𝐫𝐞𝐜𝐭𝐥𝐲 𝐭𝐨 𝐨𝐮𝐫 𝐋𝐢𝐧𝐤𝐞𝐝𝐈𝐧 (𝐃𝐌) 𝐚𝐧𝐝 𝐚𝐥
employees based on their Employee ID.

Employee ID Name Department Salary

101 John Smith HR 45000


103 David Brown Finance 55000
104 Susan Clark Marketing 50000

𝐋𝐢𝐧𝐤𝐞𝐝𝐈𝐧 (𝐃𝐌) 𝐚𝐧𝐝 𝐚𝐥𝐬𝐨 𝐬𝐡𝐚𝐫𝐞 𝐚 𝐜𝐨𝐩𝐲 𝐯𝐢𝐚 𝐞𝐦𝐚𝐢𝐥.

You might also like