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, 22.06.2019 18:30, cascyrio2002

What is outfitting a workplace with video in a technology

Answers: 2

continue

Computers and Technology, 22.06.2019 19:00, trintrin227

In he example code, what does the title attribute create? a tool tip an element a source a markup

Answers: 1

continue

Computers and Technology, 23.06.2019 15:00, abelxoconda

1. which of the following statements are true about routers and routing on the internet. choose two answers. a. protocols ensure that a single path between two computers is established before sending packets over it. b. routers are hierarchical and the "root" router is responsible for communicating to sub-routers the best paths for them to route internet traffic. c. a packet traveling between two computers on the internet may be rerouted many times along the way or even lost or "dropped". d. routers act independently and route packets as they see fit.

Answers: 2

continue

Computers and Technology, 24.06.2019 00:00, amy7233

Afashion designer wants to increase awareness about her brand. which network can she use and why she can use the blank to blank her products online. answers for the first blank: internet, extranet, or intranet answers for the second blank: market, design, and export

Answers: 1

continue

Do you know the correct answer?

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