Question: please help! 0 A B D E F G I J 1 2 3 4 5 6 7 8 9 10 11 ID 14 30

please help! 0 A B D E F G I J 1 2 3 4 5 6 7 8 9

please help!

0 A B D E F G I J 1 2 3 4 5 6 7 8 9 10 11 ID 14 30 53 56 66 72 79 First Name Mia John Jessica Mark James Emily Richard Last Name Clark Lewis Walker Reed Anderson Smith Lopez Salary $188,657 $97,566 $58,339 $125,180 $70,855 $64,901 $91,632 12 a). Use VLOOKUP function to find Name and Salary information based on ID 13 ID First Name Last Name Salary 14 66 15 30 16 79 17 18 B). Use the INDEX function to find the Salary information of 5th person in the dataset 19 Salary 20 21 22 23 24 25 26

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 General Management Questions!

1st. Case Assignment - Materiality Mini Case A Saved Help Save & Exit Submit ! This question will be sent to your instructor for grading. Check my work 1 In this mini-case you will determine overall...

I'm unable to upload an excel file to this platform. How else can I submit the material? A B C D E F G H J 1 2 3 4 5 NVIDIA Corporation Income Stmt ($ in Millions) For the Years 2012 to 2017 17-Jan...

using the above balance sheet and income statement, forecast the items on the income statement and balance sheet for 2018 using the percent of sales method. What is the discretionary financing needed...

Please Provide all formulas used. My course requires the use of formulas even when they are not needed or there is a quicker way. Thanks! O PROTECTED VIEW Be carefulfiles from the Internet can...

I only need PART 3 QUESTION 2 answered, "prepare adjusting journal entries on January 31 and post to the ledger." please only use given format and information!!! thank you!! I provided entries from...

After many years trying to come up with an experience retail concept, you have finally found one. Its calledThe Guild. Building the Guild will cost approximately $17,000,000. It will include a number...

Spreadsheet 10.1: Problem 10-6 Sensitivity Analysis (L03) Blooper's analysts have come up with the following revised estimates for its magnoosium mine: Initial investment Revenues Variable costs...

11. The file Dow.xlsx contains monthly returns on the 30 Dow stocks during the past 20 years. Use this data to determine the three stocks with the largest mean monthly returns. 12. Using the Dow.xlsx...

I only need PART 3 QUESTION 4 answered, "prepare closing entries at January 31, 2018 and post to the ledger." please use the ledger format, thank you!!! Part 1 Carl Redmon completed the following...

I only need PART 3 QUESTION 1 answered, "prepare journal entries for the above transactions and post these entries to the ledger." Please use the format provided, thank you!! Part 1 Carl Redmon...

One of the simplest and most revealing devices for summarizing data and presenting them in a meaningful fashion is the statistical table. A table is a systematic arrangement of statistical data in...

Describe how the following transactions of Sun Microsystems, Inc. would affect the three elements of the accounting equation. a. Paid research and development expenses for the current year. b....

Celeste transferred 1 0 0 percent of her stock in Supply Chain Comparry to Marketing Corporation in a Type A merger. In exchange, she recemed stock in Marketing weth a fair market value of $ 5 0 0 ,...

What is an example of constructive feedback? provide reference