1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Lorico [155]
3 years ago
5

50+ POINTS AND BRAIN IF CORRECT Which function is used to return the value in a particular row and/or column in a worksheet and

can also be used with multiple rows and columns?
MATCH

INDEX

VLOOKUP

SEEK
Computers and Technology
1 answer:
Stolb23 [73]3 years ago
5 0

Answer:

VLOOKUP

Explanation:

It is the VLOOKUP function that is applied to return the value in a certain row or column in a worksheet, and it can also be used for multiple rows and columns, The formula is =VLOOKUP( VALUE TO LOOK FOR IN THE 1ST COL OF THE TABLE, TABLE( FROM WHICH TO GET THE VALUE, COLUMN INDEX OF THE COLUMN IN THE TABLE  FROM WHICH TO GET THE VALUE, RANGE LOOKUP(EXACT MATCH OR APPROXIMATE MATCH))

Example,

=(H2, A1:D10, 3, true)

You might be interested in
Consider the following two tables where EmployeeNum is primary key in both tables. What is the result of combining the two table
Ilya [14]

Answer:

B) Employee (EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum, Street, City, State, PostalCode)

Explanation:

3 0
3 years ago
Menciona dos ventajas que ofrece el procesador de textos word
Drupady [299]

Answer:

si porque si y me gusta comer papas fritas heello

8 0
3 years ago
Construct a formula in cell D11 to calculate the sales tax amount for transaction 578. Be sure to appropriately reference the tr
Vlada [557]

Answer:

Explanation:

Formulas!D11: =C11*0.0675

4 / 7  (57.1%)

Feedback:

[-2] The formula in cell D11 does not reference the sales tax rate

[-1] The tax rate reference is not absolute

Copy the formula you used in cell D11 down to calculate the sales tax amount for the remaining transactions.

1 / 1  (100.0%)

Feedback:

Construct a formula in cell E11 to calculate the total amount for transaction 578. Be sure to appropriately reference the transaction amount in cell C11 and the sales tax amount in cell D11 so that you can reuse your formula to calculate the total for the remaining transactions.

Formulas!E11: =SUM(C11:D11)

6 / 6  (100.0%)

Feedback:

Copy the formula you used in cell E11 down to calculate the total for the remaining transactions.

2 / 2  (100.0%)

Feedback:

Use the SUM function to calculate the “Grand Total” in for all transactions in cell E24.

Formulas!E24: =SUM(E11:E23)

4 / 4  (100.0%)

7 0
3 years ago
If the following Java statements are executed, what will be displayed?
Solnce55 [7]

Answer:

The top three winners are

Jody, the Giant

Buffy, the BarbarianAdelle, the Alligator

8 0
3 years ago
How do you destroy data on hard drive?
Nataly_w [17]
You have to destroy the hard drive as it is like a memory for the computer so it can never be deleted
7 0
3 years ago
Read 2 more answers
Other questions:
  • PPE that should be used by every technician include all of the following, EXCEPT
    6·2 answers
  • What are the disadvantages of plasma display?
    9·1 answer
  • A technician is using a network-attached desktop computer with a Type 2 hypervisor to run two VMs. One of the VMs is infected wi
    14·1 answer
  • f the copyright date on the homepage is more than 1 year old, the website should always be considered unmaintained
    8·1 answer
  • A technician has just finished installing a secondary OS on a workstation. After rebooting the computer, the technician receives
    13·1 answer
  • An administrator wants to configure hosts to automatically assign IPv6 addresses to themselves by the use of Router Advertisemen
    14·1 answer
  • Which of the following statements about software licensing are true? Select 3 options.
    5·1 answer
  • What is the primary difference, if any, between a web master and a web producer? While a web master maintains a company’s websit
    6·1 answer
  • Which computer language uses short words known as mnemonics for writing programs?
    14·1 answer
  • True or false: Quality score is an algorithm that scores each of your search ads on spelling and grammar.
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!