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

KING OF EXCEL

KINGEXCEL.INFO ( KING OF EXCEL ) Welcome KINGEXCEL.INFO - Nothing Is Unable ... About Excel Tricks, Learning VBA Programming, Dedicated Software, Accounting, Living Skills ...

Saturday, March 21, 2020

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

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


DOWNLOAD PDF
DOWNLOAD AZW3

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

📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1

No comments:

Post a Comment