0
What function is used to calculate a value in a series of cells?
Wiki User
∙ 11y ago
Many functions can be used to calculate a value. It depends on what exactly what you want to do. To total a range of cells you use the SUM function, one of the most commonly used functions. The following will add the values in all the cells from A2 to A20.
=SUM(A2:A20)
Wiki User
∙ 11y ago
Add your answer:
Earn +20 pts
How do you calculate sine value without using math function?
Using its Taylor-series.
How do you calculate mid value in statistics using Excel?
You would use the MEDIAN function. If the cells with your data were from A2 to D50, then the function would be:=MEDIAN(A2:D50)
What the feature can generate a series of values into adjacent cells based on the value of cells?
Auto Fill is the feature that can generate a series of value into adjacent cells based on the value of other cells.
What feature can generate a series of values into adjacent cells based on the value of other cells?
Auto Fill is the feature that can generate a series of value into adjacent cells based on the value of other cells.
How do you calculate average value of a function?
64084096071065
How is solving for a specified variable in a formula different to finding a solution for an equation or inequality?
With a formula, you know the variable's value, and you have to calculate the value of the function of it. With an equation, you know the function's value, and you have to calculate the value of the variable.
How is solving for a specified variable in a formula similar to finding a solution for an equation or inequality?
With a formula, you know the variable's value, and you have to calculate the value of the function of it. With an equation, you know the function's value, and you have to calculate the value of the variable.
What function would be used to calculate the future value of an investment?
The FV() function.
What Excel function can be used to calculate the futue value of any investment?
The FV function.
How do you evaluate functions?
To evaluate a function means to replace the variable with some value, and calculate the value of the function. For example, in the parabola y = x2 (or, using functional notation, f(x) = x2), if you replace x with 10, and calculate x2, you are evaluating the function for that specific value.
When two identical cells are connected either in series or parallel across a 2 ohm resistor they send the same current through it calculate the internal resistance of each cell?
as the given cells have the same current flowing in through them (current flowing through the cells connected in series is equal to the current flowing when connected in parallel ) equate the formula's of cells connected in series and cells connected in parallel.thus by equating we get the value of the internal resistor as 2 ohms.
Does the PMT function calculate the breakpoint of the lowest value for a specific category?
true
