Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
1 . Create the following in Excel. Marks _ _ _ _ _ _ _ / 2 Outlander Spices Employee information Search based on Employee
Create the following in Excel. Marks Outlander Spices Employee information Search based on Employee ID Search based on Name Employee ID Name Name LOOKUP Region VLOOKUP Earnings LOOKUP Department VLOOKUP Employee ID Name Region Department Earnings E Malcolm Pingault East Human resources $ E Shannon Lee South Accounts $ E Annie Philips West Human resources $ E Michael Lee North Sales $ E Jamie Morrison East Human resources $ E Diana Stone East Marketing $ E Rob Dukes West Accounts $ E Tammy Heiret West Customer support $ E Sandy Stewart East Marketing $ E Nikki Cleary South Administration $ E Davis Lee East Accounts $ E Sonia McCormick East Administration $ Also use VLOOKUP such that Region and Department should be displayed when any Name is entered for Search based on Name After applying the formula, Enter Davis Lee
Create the following in Excel. Marks
Outlander Spices
Employee information
Search based on Employee ID Search based on Name
Employee ID Name
Name LOOKUP Region VLOOKUP
Earnings LOOKUP Department VLOOKUP
Employee ID Name Region Department Earnings
E Malcolm Pingault East Human resources $
E Shannon Lee South Accounts $
E Annie Philips West Human resources $
E Michael Lee North Sales $
E Jamie Morrison East Human resources $
E Diana Stone East Marketing $
E Rob Dukes West Accounts $
E Tammy Heiret West Customer support $
E Sandy Stewart East Marketing $
E Nikki Cleary South Administration $
E Davis Lee East Accounts $
E Sonia McCormick East Administration $
Also use VLOOKUP such that Region and Department should be displayed when any Name is entered for Search based on Name After applying the formula, Enter Davis Lee
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started