0
Cell a1 has the value -10 cell b1 has value plus 2 write formula to calculate the average of these 2 values and provide the result?
Wiki User
∙ 13y ago
A1 --> -10
B1 --> =A1+2
C1 --> =SUM(A1:B1)/2
B1 = -8
C1 = -9
Wiki User
∙ 13y ago
Add your answer:
Earn +20 pts
This is an expression used to calculate a desired result?
formula
How does an autosum formula differ from an average formula?
an autosum formula is a sum of all of its values.an average formula is the result of an autosum divided by the number of values.
Mathematical equation assigned to a cell that Excel uses to calculate a result?
formula
What is the formula used to calculate result in Microsoft Excel?
The formula you use depends upon what you are trying to calculate. If you want to multiply two cells (e.g. A1 and C2), the formula would be =A1*C2.
Formula and result of area of circle?
The formula for the area of a circle is: Area = (pi) x (Radius)2 . When you know the radius of the circle and you use it to calculate the area of the circle, the result will be equal to (pi) x (Radius)2 .
What is the avereage of 92 and 141?
To calculate the average of two numbers, add them and divide the result by 2. The average of 92 and 141 is 116.5
What would be the EXCEL formula to calculate 15 percent of 6058.82?
15 / 6058.82 = 0.00247572959751238690041955364246. Formatting the cell for percentages will yield a result of 0.25%
What are the used of dimensional equation?
A dimensional check in an equation can provide a quick check about the possible correctness of the equation. For example, if you are supposed to calculate a speed, the dimensions of the result MUST be of the form [distance] / [time] (or something that you can simplify to distance/time). If it doesn't, the formula is wrong. If it does, it MIGHT be correct.
How can we calculate the average speed for several different parts of the journey?
Measure the distance covered in a section and divide by the time taken to cover that distance. The result is the average speed for that section.
What is the average speed of a car that travels 40mph for 1 hour and 60 mph in another hour?
For this type of problem, you need to:(1) calculate the total distance elapsed, (2) calculate the total time elapsed, (3) divide the result of (1) by the result of (2).
What is the average of 5000 and 7000?
To calculate the average of two numbers, add them together, and divide the result by 2. (For the average of three numbers, you add up the three numbers, and divide by three, etc.) The average is (5000 + 7000)/2 = 6000
Which of Newtons laws can be modified to calculate gravity?
You don't MODIFY any of his laws; you just use the formula to calculate the gravitational force, plugging in the numbers for masses and distance. Usually the masses would be in kilograms, the distance in meters, and the result in newton.
