subject

First, Craig enters "=MATCH(B5, Emp_Name,0)” into cell B6. Then he types "Diana Stone” into cell B5. Then Craig enters the below formula into B7:

=INDEX(Emp_Info_6, B6)

However, after doing this, the value of Diana Stone’s earnings is not appearing in cell B7. Which error did Craig make?

The name “Diana Stone” should also have been included in cell B7.
The name “Diana Stone” should have been entered into cell B6 instead of cell B5.
The employee identification number should have been included in the INDEX formula.
The row number should appear before the column number in the INDEX formula.

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 21.06.2019 22:00
Signal sets company contracts to deliver one hundred 52-inch plasma high-definition television sets to a new retail customer, tuner tv store, on may 1, with payment to be made on delivery. signal tenders delivery in its own truck. tuner's manager notices that some of the cartons have scrape marks. tuner's owner phones signal's office and asks whether the sets might have been damaged as they were being loaded. signal assures tuner that the sets are in perfect condition. tuner tenders signal a check, which signal refuses, claiming that the first delivery to new customers is always for cash. tuner promises to pay the cash within two days. signal leaves the sets with tuner, which stores them in its warehouse pending its "grand opening sale" on may 15. two days later, tuner's stocker opens some of the cartons and discovers that a number of the sets are damaged beyond ordinary repair. signal claims tuner has accepted the sets and is in breach by not paying on delivery. will signal succeed on these claims? explain.
Answers: 1
question
Computers and Technology, 23.06.2019 12:00
3. when you right-click a linked spreadsheet object, what commands do you choose to activate the excel features? a. linked worksheet object > edit b. edit data > edit data c. linked spreadsheet > edit d. object > edit data
Answers: 2
question
Computers and Technology, 23.06.2019 15:00
Barbara is interested in pursuing a career in the science and math pathway. which qualifications will her reach that goal? a.an advanced knowledge of physics and math b.an advanced knowledge of engineering and math c. an advanced knowledge of physics and robotics an d. advanced knowledge of machinery and math
Answers: 1
question
Computers and Technology, 24.06.2019 00:30
The best definition of an idiom is a. a word or phrase that describes a noun b. a word or phrase describing a verb c. a phrase containing figurative language in which the word expresses a different idea from its exact meaning d. a phrase that compares two unlike objects or ideas
Answers: 2
You know the right answer?
First, Craig enters "=MATCH(B5, Emp_Name,0)” into cell B6. Then he types "Diana Stone” into cell B5....
Questions
question
Mathematics, 15.10.2020 08:01
question
Medicine, 15.10.2020 08:01
question
Mathematics, 15.10.2020 08:01
question
Mathematics, 15.10.2020 08:01
question
Mathematics, 15.10.2020 08:01