$1.$ Create the following in Excel. Marks $\_\_\_\_\_\_\_/2$

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$001$ Malcolm Pingault East Human resources $$72,000$

E$002$ Shannon Lee South Accounts $$80,000$

E$003$ Annie Philips West Human resources $$60,000$

E$004$ Michael Lee North Sales $$68,000$

E$005$ Jamie Morrison East Human resources $$62,000$

E$006$ Diana Stone East Marketing $$60,000$

E$007$ Rob Dukes West Accounts $$70,000$

E$008$ Tammy Heiret West Customer support $$76,000$

E$009$ Sandy Stewart East Marketing $$65,000$

E$010$ Nikki Cleary South Administration $$75,000$

E$011$ Davis Lee East Accounts $$72,500$

E$012$ Sonia McCormick East Administration $$78,000$

$2.$ Use LOOKUP such that Name and earnings should be displayed when any Employee ID is entered for $$Search based on Employee ID$.$ After applying the formula, Enter E$006$ for Employee ID$.$ Marks $\_\_\_\_\_\_\_/4$

$3.$ 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