Question

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

Answer 1

THIS IS COMPLICATED BECUASE THW FIRST THINF IM Thinking IS EXCEL IN MICROSOFT AND WELL IF YOU MEAN THAT THEN ENTER THE FOLOWING FORMULA......=MAX(FIRST CELL:LASTCELL/FIRSTCELL:LASTCELL)

Answer 2

Answer:

Supposing values are placed in cells A1 to A99,  the formula =MAX(A1:A99)/COUNT(A1:A99)  find the value of the largest number divided by the total number of values.

Explanation:

The MAX function returns the largest numeric value in a range of values and the COUNT function counts the number of cells that contain numbers