Where does excel automatically display statistics like count, average, and sum when a range of values is selected?

Question

Computers & Technology

Guest

12 November, 09:23

Where does excel automatically display statistics like count, average, and sum when a range of values is selected?

+5

Answers (1)

Know the Answer?

Maia · Answer 1

Excel will automatically display statistics mentioned above on the cell that the formula was entered. Take for example, values 2,4,6,8, and 5 fill up cells A1, A2, A3, A4, A5 correspondingly. If you put = SUM (A1:A5) in cell A6, you will have the sum of the values placed in the mentioned cells. This depends on the formula entered which may also be average, product, etc.