0
A predefined formula that allows us to do complicated calculations easily is known?
Wiki User
∙ 13y ago
...as a function.
Wiki User
∙ 13y ago
Add your answer:
Earn +20 pts
A predefine formula that allows us to do complicated calculations easily is known as a?
function
Is the Microsoft Word have a calculation?
It is not normally used for doing them, but you can actually do calculations in Microsoft Word. In the Table menu there is an option called Formula which allows you to do some. If you want to do a lot of calculations you are better off to use Microsoft Excel.
What is a Summary formula?
A Summary formula is a formula in Salesforce that allows users to calculate aggregate values (like Sum, Average, Min, Max) on a grouped set of records in a report. It can be used to perform calculations on data to generate summary information for reports and dashboards.
How can estimating be helpful before gettin an actual answer?
Estimating can be helpful before getting an actual answer because it allows you to make quick calculations and get a rough idea of what the final answer might be. It helps in determining if the answer is reasonable or if there might be a mistake in the calculations. Estimating can also save time and effort by giving a sense of whether further calculations are necessary or if the rough estimate is sufficient.
Why do we use the calculator?
Because it allows us to perform calculations that would be too difficult (or too slow).
What box on the formula bar will allow you to select any cell by entering its cell number?
The Name Box, beside the formula bar, allows you to select a cell by entering its cell address.The Name Box, beside the formula bar, allows you to select a cell by entering its cell address.The Name Box, beside the formula bar, allows you to select a cell by entering its cell address.The Name Box, beside the formula bar, allows you to select a cell by entering its cell address.The Name Box, beside the formula bar, allows you to select a cell by entering its cell address.The Name Box, beside the formula bar, allows you to select a cell by entering its cell address.The Name Box, beside the formula bar, allows you to select a cell by entering its cell address.The Name Box, beside the formula bar, allows you to select a cell by entering its cell address.The Name Box, beside the formula bar, allows you to select a cell by entering its cell address.The Name Box, beside the formula bar, allows you to select a cell by entering its cell address.The Name Box, beside the formula bar, allows you to select a cell by entering its cell address.
What spreadsheet feature allows the user to see how changing one or more numbers changes the outcome of calculations?
Scenario
What account is a predefined user account with limited privileges that allows a user to log on to the computer?
You can either turn on a guest account or you can start a new profile with limited privlages in the control pannel.
What allows the user to enter or edit the value or formula contained in the active cell?
The formula bar.
What does formula of derivative of an inverse allows you to do?
The formula for the derivative of an inverse (finv)' = 1/(f' o (finv)) allows you get a formula for the derivative of the inverse of any function that you already know the derivative of. For example: What is the derivative of sqrt(x)? You could figure this out using the definition of the derivative, but it is complicated. You already know that the derivative of x2 is 2x. So let f = x2; finv = sqrt(x), f' = 2x. This gives: (sqrt(x))' = 1/(2 sqrt(x)). Now you have derived a "square root rule" with almost no work.
What part of the Excel user interface displays the value or formula contained in the active cell and allows you to edit that value or formula?
The Formula Bar.
When is it better to use a function or a formula?
In a spreadsheet, all calculations that you do are formulas. If you cannot use formulas, then a spreadsheet has very little use. In math there are standard formulas for doing specific types of calculations. You would use a formula when you want to do those specific calculations.It is impossible to list all formulas here, because every formula you would do is different. It would be like asking someone to write all sentences that there are in the English language. There are a limited number of functions and types of calculations, in the same way that there are a limited amount of letters and words, but putting them together allows infinite possibilities. You use formulas to solve the problem that you are trying to solve, in the same way you put words together to say what you want to say.A very simple example of a formula which would add values in two different cells would be:=A1+A2A1 refers to a cell in Column A, Row 1 and A2 is the cell in Column A and Row 2. The formula must start with the equals sign. Without it, it will be treated as a piece of text. This formula will add the numbers that are in the two cells and put the result in the cell that the formula is typed into. No formula can be typed into a cell referenced in its formula. So the above formula could not be put in cell A1 or cell A2.
