moisboss1670 moisboss1670
  • 14-05-2021
  • Mathematics
contestada

What function returns a reference to a cell (or cell range) that is a specified number of row and columns from a base cell?

Respuesta :

MrRoyal
MrRoyal MrRoyal
  • 15-05-2021

Answer:

The offset function

Step-by-step explanation:

In Microsoft Excel, the offset function or formula returns reference to a particular cell.

The syntax is:

= OFFSET(reference, rows, cols)

Where:

reference = the base cell

rows and cols are the direction to move

For instance:

OFFSET(A1, 3, 1) will return cell B4

Because:

3 will shift down the reference from A1 to A4

1 will shift right the reference from A4 to B4

Answer Link

Otras preguntas

Can someone summarize the 1999 movie version of "Animal Farm" for me?
Solve for x 3x+3/x-1=3x+2/x+4
In order to synthesize proteins, carbohydrates, lipids, and nucleic acids, cells require _____. disaccharides energy an adenosine group a sugar group
Which statement describes what these four powers have in common?
If a wheel falls from an airplane that is flying horizontally at an altitude of 500 m, how long will it take for the wheel to strike the ground? 10 s 50 s 80 s
Why do we still read Romeo and Juliet?
What is the expanded form of the series represented below? A. -3 + 2 + 7 + 12 + 17 B. -3 + 3 + 8 + 13 + 18 C. 2 + 7 + 12 + 17 + 22 D. 5 + 2 + (-1) + (-4) + (-7
Who said we need to put our individual wants aside for the good of the whole group
Give an example of a theory in science
What is Beah’s purpose in writing A Long Way Gone?