britt40478ox78h3 britt40478ox78h3
  • 17-01-2018
  • Computers and Technology
contestada

Column A contains numbers from rows 1-20. You can use the formula ----?---- to find the value of the largest number divided by the total number of values.

Respuesta :

calculista
calculista calculista
  • 22-01-2018

Using Excel formulas
 =LARGE(A1:A20, 1)/COUNT (A1:A20)

 Count (Ai:An) Function that allows to count the total number of values in a cells range between Ai and An that contain only numbers.

  Large (Ai:An, k) Function that allows to find the value of the largest number in a cells range between Ai and An, the number k determine the k-th largest value

 

Answer Link
everandeli2011 everandeli2011
  • 19-01-2021

Answer:

=MAX(A1:A20)/COUNT(A1:A20)

Explanation:

Got it right on plato

Answer Link

Otras preguntas

round 1045 to the nearest thousand
What does the product of any whole-number factor multiplied by 100 always have ? Explain
write all names that apply to 7/8
why do you suppose the population of deer declined in 1925, although the elimination of predators?
how do you round off 199,814.rounding off the the 9 beside comma
When you solve a problem involving money, what can a negative number represent
how do you round 415,203 to the thousands place
Which was the most major cause of foreign interest in Persia? a. Persia had weak export laws. b. Persia reversed its strong immigration policy. c. Persia mai
convert 27/20 to a decimal
Which belief was generally held by the delegates to the Constitutional Convention of 1787? A. A stronger central government was necessary to maintain order. B.