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

What is the shortcut key to apply /remove the subscript effect? Ctrl+= Ctrl-+

telo118 [61]

Answer:

Press "Ctrl, "Shift" and "=" on your keyboard to turn off superscript formatting.

5 0

2 years ago

Which statement best describes the difference between a spreadsheet and a database?

Dmitrij [34]

Answer:

Databases store data in tables that interact; spreadsheets store data in cells that interact.

Explanation:

3 0

2 years ago

Read 2 more answers

Pressing and holding _______ while clicking enables you to select multiple contiguous files or folders.

liq [111]

Answer:

Hi LizBiz! The answer is Ctrl key on Windows, or Command key for Mac.

Explanation:

The Ctrl (Windows) key or equivalent Command key on Mac has a special purpose which allows special operations to be performed when combined with another action, such as clicking on multiple pictures or files for selection.

8 0

2 years ago

Write a method that prints on the screen a message stating whether 2 circles touch each other, do not touch each other or inters

beks73 [17]

Answer:

The method is as follows:

public static void checkIntersection(double x1, double y1, double r1, double x2, double y2, double r2){

double d = Math.sqrt(Math.pow((x1 - x2),2) + Math.pow((y1 - y2),2));

if(d == r1 + r2){

System.out.print("The circles touch each other"); }

else if(d > r1 + r2){

System.out.print("The circles do not touch each other"); }

else{

System.out.print("The circles intersect"); }

}

Explanation:

This defines the method

public static void checkIntersection(double x1, double y1, double r1, double x2, double y2, double r2){

This calculate the distance

double d = Math.sqrt(Math.pow((x1 - x2),2) + Math.pow((y1 - y2),2));

If the distance equals the sum of both radii, then the circles touch one another

if(d == r1 + r2){

System.out.print("The circles touch each other"); }

If the distance is greater than the sum of both radii, then the circles do not touch one another

else if(d > r1 + r2){

System.out.print("The circles do not touch each other"); }

If the distance is less than the sum of both radii, then the circles intersect

else{

System.out.print("The circles intersect"); }

}

6 0

2 years ago

How to make a Tip Calculator in code?

ki77a [65]

You should have the percentage of tip based on the service that you received.
Then you multiply the percentage of tip by the amount of money that you have to pay for what you bought.

4 0

3 years ago