Computer Science, asked by anmolsharmaanmolshar, 3 months ago

write the formula to calculate the average of the cell values from A1 through A10?

Answers

Answered by richitavermadpsv

Answer:

hope it's helpful to you!

Explanation:

SUM. Formula: =SUM(5, 5) or =SUM(A1, B1) or =SUM(A1:B5) ...
COUNT. Formula: =COUNT(A1:A10) ...
COUNTA. Formula: =COUNTA(A1:A10) ...
AVERAGE. Formula: =AVERAGE(number1, [number2],...) ...
MAX function. This function Returns the largest value in a set of values. ...
MIN Function. ...
Percentage.

Answered by Anonymous

Answer:

formula. =sum(A1: a10)or

Count the cells with a certain value. For example, if you have =COUNTIF(A1:A10,"TEST") in cell A11, then any cell between A1 through A10 with the word "test" is counted as one. So, if you have five cells in that range containing the word "test," the value "5" is shown in cell A11 (10-5=5).

Previous Question

Next Question

Similar questions

Chemistry, 1 month ago

wool is used create different fabrics...

English, 1 month ago

You can Report suspicious emails at [email protected] or call at 53333...

English, 1 month ago

Yesterday, tow, robbers, robbed, the, panjab...

Accountancy, 3 months ago

M/S XYZ Ltd issued a Cheque to a supplier A Ltd. The Cheque was wrongly accounted by XYZ Ltd in the ledger account of another supplier-B Ltd. The rectification entry passed in the books of XYZ Ltd. is 1) "A Ltd A/c Dr To Suspence A/c Cr" 2) "B Ltd A/c Dr To A A/c Cr" 3) "A Ltd A/c Dr To B A/c Cr" 4) "A Ltd A/c Dr To Purchase A/c Cr"...

English, 3 months ago