Change the formula to use absolute references instead of relative references. Instead of =A2+B3, use =$A$2+$B$3.
=AVERAGE(Firstcell:lastcell) i think
You can use the Insert Function button fx on the Formula bar to find an Excel function by typing a description of the formula at the Insert Function dialog box, in the Search for a function text box and then click Go.
Absolute references are fixed. Relative addresses are not. You use an absolute reference when you want to move the cell contents without changing the formula.
to value
Fx represents functions. It is on the Formula Bar and on the Insert Function Button. Clicking on it starts the process of allowing you to enter a function.
It is changing the contents of the cell, like changing a formula or putting a new value in it. You can start editing by clicking on the content in the formula bar or pressing the F2 key.Cell editing is making any changes to the contents of the cell whether the contents is text, data (numbers) or a formula. Double click on a cell and you can edit it in the cell instead of on the formula bar.
It has no special name. It is just the plus sign.
yes
In Excel, a working function is already a formula. A function is defined as being a built-in formula. So in that sense you cannot change a function into a formula, as it already is one. It can also be part of a formula. A formula can contain many functions. Changing a function does not necessarily constitute what-if analysis. A lot of what-if analysis is done by changing values that formula use rather than formulas themselves.
Save As
There are lots of ways. Go to the Insert Menu and choose Function. Click on the Fx just beside the formula bar, or on the Formulas ribbon.
scroll bars