All categories

2 years ago

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

Computers and Technology

1 answer:

dangina [55]2 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

Wendell notices that the company's top executives share a belief that managers are directly responsible for the organization's s

Debora [2.8K]

This belief reflects an omnipotent view of management.

8 0

2 years ago

WHO SAYS BUP ALL THE TIME

Delvig [45]

Answer:

Mario

Explanation:

7 0

3 years ago

The protocol that enables computers on the Internet to communicate with one another is called ___

iren2701 [21]

Answer: TCP/IP

Explanation:

8 0

3 years ago

Read 2 more answers

What command would you use to copy the content of a file named report1 to another called report1uc. Convert the content of repor

Ray Of Light [21]

Answer:

Answered below.

Explanation:

This answer is applicable to Linux.

There are several commands for copying files in Linux. cp and rsync are the most widely used. cp though, is the command used to copy files and their contents.

To copy a file named report1.txt to another file named report1uc.txt in the current directory, the following command is run.

$ cp report1.txt report1uc.txt

You can change the case of the strings in the file by using the tr command.

tr [:lower:] [:upper:]

For example,

$ echo brainly | tr [:lower:]. [:upper:]

Result is BRAINLY.

7 0

3 years ago

Where does append add the new elements?

ZanzabumX [31]

Answer:

"Option 1: To the end of an array." is the correct answer.

Explanation:

The word "Append" means adding to the end of a document.

Appending means whatever new content is added, it is added at the end of the document or data structure.

Similarly,

Appending an array means adding new elements to the end of the array.

Hence,

"Option 1: To the end of an array." is the correct answer.

7 0

3 years ago