All categories

3 years ago

Which of the following can be used to locate data in a particular column?

Computers and Technology

1 answer:

dangina [55]3 years ago

4 0

Answer:

A. VLOOKUP

Explanation:

VLOOKUP is an Excel function to look up data in a table organized vertically. VLOOKUP supports approximate and exact matching, and wildcards (* ?) for partial matches. Lookup values must appear in the first column of the table passed into VLOOKUP.

Purpose

Lookup a value in a table by matching on the first column

Return value

The matched value from a table.

Syntax

=VLOOKUP (value, table, col_index, [range_lookup])

Arguments

value - The value to look for in the first column of a table.

table - The table from which to retrieve a value.

col_index - The column in the table from which to retrieve a value.

range_lookup - [optional] TRUE = approximate match (default). FALSE = exact match.

You might be interested in

Which of the following are characteristics of a good webmail message select all that apply

emmainna [20.7K]

add choices please :)

6 0

3 years ago

This is your code.

lubasha [3.4K]

Answer:

Explanation:

We will be going inside B array, because he was in second place in array E,and will be the first element of array B, so it's 35

E can be understanded as:

E=[[21, 'dog', 'red'],[35, 'cat', 'blue'],[12, 'fish', 'green']], so, you can see array E as array of arrays or so-called two-dimensional array

6 0

2 years ago

What is the wave speed of a wave that has a frequency of 100 Hz and a wavelength of 0.30m?

swat32

Answer:

The speed is

=

30

m

s

−

1

Explanation:

The speed of a wave is given by

speed

(

m

s

−

1

)

=

frequency(Hz)

×

wavelength (m)

The frequency is

f

=

100

H

z

The wavelength is

λ

=

0.3

m

The speed is

v

=

λ

f

=

0.3

⋅

100

=

30

m

s

−

1

6 0

3 years ago

Research shows that a passive close to a cover letter leads to more interviews. Please select the best answer from the choices p

Alchen [17]

The answer is False.

According to research, a passive close doesn't lead your cover letter to have more interviews. In writing the closing part of your cover letter, it is easy to have a passive sentence but it sounds like less confidence to the employer. The last part of the cover letter should contain strong content to give an impression to the person who reads.

6 0

3 years ago

Read 2 more answers

Which of the following is not true about network design?Group of answer choicesIn designing LAN networks, network designers tend

sergey [27]

Answer:

In designing LAN networks, network designers tend to design err on the side of providing for less capacity than what is currently necessary.

Explanation:

In designing LAN networks, network designers tend to design err on the side of providing for less capacity than what is currently necessary is not true about network design.

8 0

3 years ago