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
You find that you are missing a very important file. After much searching, you have determined that it is no longer on your comp
Pani-rosa [81]

You can use backup utility programs and file management programs.

5 0
3 years ago
Read 2 more answers
categorize each job role as an administrative job or management job auditor director legal secretary payroll clerk etc ​
abruzzese [7]

Explanation:

look after the office jobs

3 0
3 years ago
Why is it important to minimize cable clutter in a rack?
V125BC [204]

Answer: Cable clutter is the mess created due to cables of the operating system units in the rack.The reduction in the cable clutter is important because it make the computing environment clear and prevent the blockage in flow of air, reducing the litter in rack environment etc  

The clearance of the cable clutter can be done with the help of cable managers for collecting the cables and tying them into one section, organizing and clearing the cabinets of rack.

8 0
3 years ago
Targeting encourages drivers to scan far ahead and _____________. A. focus their visual attention on the next point on the road
Colt1911 [192]
<span>A. focus their visual attention on the next point on the road.  A driver must have a target, it can be the car in front, a building pr a structure on the road.  Targeting enables the driver to look further ahead on the road and thus be ready for any obstacle on the road.</span>
3 0
3 years ago
Read 2 more answers
Windows server 2012 r2 includes hyper-v in which edition(s)?
SashulF [63]
<span>The Standard and Datacenter editions.</span>
7 0
4 years ago
Other questions:
  • Margins can be modified in the page layout or by using__.
    15·1 answer
  • One metric ton is approximately 2,205 pounds.
    6·1 answer
  • The fossil record is usually incomplete due to the destruction of fossils.
    10·1 answer
  • Given an array arr of type int , along withtwo int variables i and j , write some code thatswaps the values of arr[i] and arr[j]
    6·1 answer
  • Is it necessary that every autonomous system use the same intra-AS routing algorithm? Why or why not?
    10·1 answer
  • ____ allows you to control how objects enter, move on and exit slides
    13·2 answers
  • Lisa is modifying a spreadsheet. Which view will allow Lisa to see how her changes will look when she prints the spreadsheet?
    13·2 answers
  • What is data Communications​
    11·2 answers
  • IN WHICH COUNTRY DO THEY LET YOU PLAY MINECRAFT IN SCHOOL?
    8·2 answers
  • For this activity, you will practice being both proactive and reactive to bugs. Both are necessary to get rid of errors in code.
    5·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!