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

Kevin correctly answered 75% of 32 test questions. How many more questions would Kevin have to answer correctly to get more than 80% correct?
Besides drinking water, how is water helpful for life and nature?
I don't have a question but x + 8900 = 390​
A 0.50 kg lead ball at 45 c is dropped into a calorimeter with water at 20 the final temperature of the ball-water system is 25c, what is the mass of the water?
Brainliest! Help please, thank you!!!
Imagine you have to create a well balanced meal for yourself and three friends. How can you make sure that the food you serve them will not contain food borne
What is NOT a reason for companies to merge?
Explain the impact of negligent misrepresentation on a contract
53. (a) if the symbol [tex]\lbrack\rbrack[/tex] denotes the greatest integer function defined in example 10 , evaluate (i) [tex]\lim _{x\rightarrow-2^+}\lbr
towns and manors help pls