Question: a . Using the VLOOKUP function, identify the Name of the sales representative for shipment. Use the HR Database spreadsheet. Put your answers in column

a. Using the VLOOKUP function, identify the Name of the sales
representative for shipment. Use the HR Database spreadsheet.
Put your answers in column "I" for each row of data provided.
2 points

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

BIZ3189 Management Information Systems Take-home Exam 1 The tasks in this exam aim at developing a basic level of understanding on Excel and how you can use it to develop Decision Support Systems....

Q:

Please solve this Excel spreadsheet using the directions! Thank you so much! Directions: Excel Spreadsheet: The manager of Paco's Dog Treats, Inc. imported inventory data. This data must be cleansed....

Q:

Sam Project for Advanced functions and conditional formatting Excel 2013 I am having trouble with questions 14-19. Assignment do tomorrow Computer Software 178 New Perspectives Excel 2013 Tutorial 8:...

Q:

Project General Information and Background In this project you are working with cost and financial information for a small computer manufacturer. The company manufacturers only two premium computers....

Q:

MGMT 2100 - Assignment #1: Spreadsheet Skills General Instructions: For this assignment you will complete a tutorial introduction to some important features of Microsoft Excel, and then search for...

Q:

Story plot: tall, square, symmetric. For each technique, give the relevant matrix equations to obtain the solution x, and point out the properties of the matrices involved. Highlight one potential...

Q:

Product Costs Worksheet: Step 1: Use the "Part Number" as the reference and V look-up function to bring the "Cost per Component" information from the "Inventory Master File" worksheet. For reference...

Q:

In this project you are working with cost and financial information for a small computer manufacturer. The company manufacturers only two premium computers. One targets the high-end gamers market and...

Q:

Bao Vong is the sales manager for Murray Medical, a medical device manufacturer with headquarters in Morristown, New Jersey. Bao is analyzing the performance of account representatives and the sales...

Q:

Product Costs Worksheet: Step 1: Use the Part Number as the reference and V look-up function to bring the Cost per Component information from the Inventory Master File worksheet. For reference on how...

Q:

What is a syn_flood attack?

Q:

Ernlo is an accrual basis corporation with a June 30 fiscal year-end. On June 2, 2015, Ernlo entered into a binding contract to purchase a six-month supply of heating oil from a local distributor at...

Q:

The only costs of investing in a closed - end investment company are the commissions to buy and sell the shares. True False

Q:

Your company purchased a piece of land five years ago for $150,000 and subsequently added $175,000 in improvements. The current book value of the property is $225,000. There are two options for...

Q:

4. Bureau of Labor Statistics on Work Stoppages in the Public Sector. The BLS reports major work stoppages, which include worker-initiated strikes and lockouts by their employers involving 1,000...

Q:

3. If there is a contract violation found and the arbitrator sustains Mr. Mitchells Grievance, should he be promoted and receive back pay for the failure to promote him? Why? Why not? At the Coral...

Q:

3. Labor Relations and Teachers. Locate and read David Denholms The Impact of Unionism on the Quality of Education as well. The Education Policy Institute in Washington, D.C., provides links to...