0
A function means purpose. For example, the lung needs oxygen (for people and animals) and carbon dioxide (for plants). Function can also be variable quantity in Math. What's variable quantity? A variable quantity whose value depends upon the varying values of other quantities. I can't give you an example because I can't understand the meaning. A formula is a plan. It is sometimes the one to solve something. Example, for cubic Area formula. The formula will be S2 X 6 = A2. Then for the rectangular prism. the formula will be: [2 x (l x w)] + [2x (h x w)] + [2 x (h x l)] = A2.
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
What are four ways to add a function to a formula?
Type the formula directly in the cell or the formula. Use formula AutoComplete. Select a function from the Function Library group, or click the Insert Function button to select a function from the Insert Function dialog. Use AutoSum
A formula prewritten by excel is called?
Function
What is the nested formula of MS Excel?
A nested formula is where one or more functions are placed inside another function to make a formula. For example you can write a formula where you put an IF function within an IF function and this would be a nested formula.
In a spreadsheet a built in formula is called?
In a spreadsheet a built-in formula is called a function.
What is the function of a formula?
everything is the purpose of Formula !
Are all formulas functions?
Yes, functions can be part of a formula. You can have a formula without a function, but any function when used is a formula.
Can you replace a formula with its function so it can remain constant?
No but if you replace a constant with a function it will remain a formula
Can you replace a formula with its function so it remains constant?
No but if you replace a constant with a function it will remain a 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.
What is a built-in calculation such as SUM or AVERAGE is called?
If built-in it is a function. If the user types it into a cell, it is a formula.
What can be used to find an Excel function by typing a description of the formula?
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.
A nested function is placed in the cell below the first formula true or false?
False. A nested function is a function within another function, so it would be in the same formula. An alternative to nesting would be to put a separate function in a different cell and use its result in the other formula. In that case it would not have to be put in the cell below the first formula.
