[Free ebook Amazon]The Basics of Excel Functions: Using logical, lookup and basic statisticalmathematical functions by E Atkins - EBOOKS AND TIPS FREE

Ebooks and Tips free for you.

# [Free ebook Amazon]The Basics of Excel Functions: Using logical, lookup and basic statisticalmathematical functions by E Atkins

Author:E Atkins
Language: eng
Format: azw3 + pdf
Published: 2019-08-30
Example 13:
We want to find the position of a number in a list of numbers. In this case, we want the exact number, so we need to add 0 as the last argument.
The cell C2 has the formula =MATCH(97,A1:A6,0).
Basic Statistical Functions
AVERAGE
This function returns the arithmetic mean of the values selected. In Excel, it is written as
=AVERAGE(number1, [number2], ...)
Example 14:
We want to find the average age of children in a sports club.
The cell C3 has the formula =AVERAGE(A2:A7). Here we haven’t entered individual numbers into the formula, but have selected the range A2:A7 to average.
#evba #etipfree #eama #kingexcel