0
Using Excel to scrutinize the impact of changing values in cells that are referenced by a formula in another cell is called?
Wiki User
∙ 13y ago
what-if analysis or sensitivity analysis
Its What-if Analysis
Wiki User
∙ 13y ago
Wiki User
∙ 13y agoThis is called the what-if analysis or sensitivity analysis
Add your answer:
Earn +20 pts
What type of cell reference is required if a formula containing a cell reference requires that the referenced cell remain the same even if the formula is moved to another cell position?
An absolute reference.
What is used to find cells that are referenced in a formula in excel?
range finder
After entering a formula that calculates numbers you get nothing or number sign for an answer. What is causing the problem?
After entering a formula that calculates numbers, you get: #### for an answer. What is causing the problem? ANSWER:One of the cells referenced in the formula was hidden Excel did not recognize the function you used The column width is too narrow to display the formula result The workbook on which you are working has become corrupted One of the cells referenced in the formula was formatted as text
When changing a subscript in a correctly written chemical formula it will change what?
Changing the subscript in a chemical formula changes the number of atoms to which the particular subscript belongs. Doing this changes the formula completely, making it representative of another substance completely.
Is the point and click method is a convenient way to construct a formula when the referenced cell are not adjacent?
Yes.
What is an amending formula?
An amending formula is a procedure for changing the Constitution.
Use what to check which cells are referenced in the formula assigned to the active cell?
Pressing F2 will show the formula and the referenced cells in it will be colour-coded and highlighted. Pressing and holding the Ctrl key and then pressing the [ key will select the cells referenced in the formula.
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.
What is an easy way to verify that a formula references the cells that you want to reference in Excel?
Double-click on the cell that contains a formula and look for what other cells are outlined. Those are the cells that are referenced by the formula.
Is changing a function to a formula not an example of what-if analysis?
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.
Can Changing a subscript changes the formula of the compound true or false?
It not only can change but really DOES change the formula.Changing the subscript in a chemical formula changes the number of atoms to which the particular subscript belongs. Doing this will change the formula completely, making it representative of another substance completely.
Is it possible to insert a number into a Microsoft excell cell with a formula already in the cell automatically generating an answer without having to write the formula everytime?
If a formula is in a cell and a number is entered into the same cell, then the formula will be gone and replaced by the number. You can enter a number in a cell that is referenced by a formula in another cell. The cell with the formula in it will update when the number is entered into the other cell. Say you change the value in A2 and the cell A3 contains the formula: =A2*10 Then the total in A3 will update when any change in A2.
