Computers and Technology, 14.05.2020 18:57 lilacastro

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.

Answers: 3

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 21.06.2019 16:10, kendall984

Which is a benefit of peer-to-peer networking? easy to add or remove devices main server has a fast processor more reliable than a client/server network same software versions on all computers

Answers: 3

continue

Computers and Technology, 22.06.2019 16:10, katherineweightman

When copying and pasting text, the first step is move your cursor type the text select the copy command select the paste command

Answers: 2

continue

Computers and Technology, 22.06.2019 16:30, mesposito

Technician a says that a dry sump system uses no oil storage sump under the engine. technician b says that a wet sump system uses no oil storage sump under the engine. who is correct?

Answers: 3

continue

Computers and Technology, 23.06.2019 18:00, bubbles173883

While inserting images, the picture command is usually used to insert photos from a digital camera, and the clip art command is usually used to a. edit the sizes and other characteristics of photos that have been inserted. b. take a screenshot of an image and copy it to the clipboard for pasting. c. search for drawings or other images from a library of prepared pictures. d. make illustrations using lines and shapes that are easy to manipulate.

Answers: 1

continue

You know the right answer?

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