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]
2 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]2 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
Which one of the following analog VOM ranges would be selected to measure a DC
tensa zangetsu [6.8K]
<span>100 mA of course. You cannot use 10 mA because it will be over the range and the higher ranges are not accurate at 90 mA</span>
7 0
3 years ago
PLEASE HELP, THANK YOU SO MUCH!
ozzi

Answer:

The correct answer is "Once a day".

Explanation:

According to social media marketing, it is a good idea to check your reader at least once a day. Readers help business by tracking what the consumers are seeing and what times of the day. Checking the reader at least once a day help people in marketing to be updated, because people's preference keep changing all the time.

3 0
3 years ago
Types of network model​
dexar [7]

Answer:

OSI Model and TCP/IP Model

Explanation:

4 0
2 years ago
Determine the type of plagiarism by clicking the appropriate radio button.
AleksAgata [21]

Answer:

a)

Explanation:

From the writing of the student, it shows that he plagiarized the work word for word, in that

1. There was the page number of the article in his writing

2. In addition, the reference shouldn't have been added at this stage of writing but the student did added it.

5 0
2 years ago
Write a loop that sets new scores to old scores shifted once left, with element 0 copied to the end. ex: if old scores = {10, 20
Inga [223]

#include <iostream>
using namespace std;

int main() {
   const int SCORES_SIZE = 4;
   int oldScores[SCORES_SIZE];
   int newScores[SCORES_SIZE];
   int i = 0;

   oldScores[0] = 10;
   oldScores[1] = 20;
   oldScores[2] = 30;
   oldScores[3] = 40;

   /* Your solution goes here */

   for (i = 0; i < SCORES_SIZE; ++i) {
      cout << newScores[i] <<" ";
   }
   cout << endl;

   return 0;
}

3 0
2 years ago
Read 2 more answers
Other questions:
  • Jenis-jenis grafik bagi imej​
    10·1 answer
  • A local government uses Short Message Service (SMS) text messages to alert local residents when roads are closed. Which of the f
    13·1 answer
  • Professionals within the creative imaging fields must have which of the following items to showcase technical expertise?
    14·2 answers
  • What is the most common example of a magnetic storage medium in a personal computer
    5·1 answer
  • Fred has to write a report on the general opinion of the influence of television on political decision-making. What internet res
    11·2 answers
  • Is there a way to earn free robux
    7·2 answers
  • Select all the sets that are countably infinite. Question 3 options: the set of real numbers between 0.1 and 0.2 the set of all
    12·1 answer
  • Answer the questions given below, share your ideas.Use the space for your answer.
    14·1 answer
  • Which operation is not efficiently supported by heaps?
    8·1 answer
  • Which extra step do verizon devices require for fenrir to be allowed to connect to the device?
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!