0
If you have written a formula you can drag it down or across other cells what is this called?
Wiki User
∙ 14y ago
I am not sure what you are asking, but my best guess is that the question should be "How do you create a formula you can drag to other cells without changing the original cells in the forumula?"
The answer to the new question is: Use absolute cell references. Instead of using =SUM(A1:A23) write =SUM($A$1:$A$23). When you move the formula with absolute cell references, it does not change.
Wiki User
∙ 14y ago
Wiki User
∙ 14y agoIt can be called Filling of Copying.
Add your answer:
Earn +20 pts
A way of showing your data in pictorial form?
If you have written a formula you can drag it down or across other cells this is known as
What is the term for all of the cells that go across the spreadsheet horizontally?
The cells that go across the spreadsheet horizontally is called a row of cells.
What are the cells that go across a spreadsheet called?
A row.
What reference to use to copy a formula across a range of cells and have the formula automatically update the cell row and column?
relative cell reference
Cells in the nervous system communicate to each other across gaps called?
synapses.
What is the movement called when a call does not use energy to move particles across the cells membrane?
It is called passive diffusion.
What allows you to check both the cells being referenced in a formula and the formulas that reference those cells?
You use a facility called formula auditing. You can then use Trace Precedents to see what cells are referenced by a formula. You use Trace Dependents to see which cells use the active cell. You can also press Ctrl and the [ key to trace precendents and Ctrl and the ] key to trace dependents.
Which term describes describes the difference in the concentration of a substance across a cells membrane?
This is called the osmotic gradient.
What is the formula to calculate red blood cells?
formula for calculating red blood cells
What are the vertical columns called and how are the elements of each row relate?
The verticals are called , just as you questioned, columns; they are designated by letters. the relation between cells is according to formula that apply to values in the cells.
What is relative reference?
if you move or copy the formula to another cell, the cells referred formula will changed. Excel adjusts the cell references relative to the new cell in which the formula is pasted. this is called relative referencing.
An easy way to verify that a formula references the cells that you want it to reference is to use Excel's?
Range finder. Double clicking on the formula activates the range finder and you can see what cells are in the formula. This can help you see if the correct cells are in the formula.
