Finding minimum, maximum and average number in a list and counting the number of cells.
You will do some comparison between the length of longest buildings of the world by using formulas.
MAX() formula provides to find the maximum value in the range described into the paranthesis.
MIN() formula provides to find the minimum value in the range described into the paranthesis. Let's find the average of the total height of buildings.
AVERAGE() formula provides to calculate the average value of a range which is written into the paranthesis. Let's find how many buildings are considered at this datashhet.
COUNT() function provides to count the number of cells that contain numbers, and count numbers within the list of arguments.
Related Tutorials
, ISTEXT(), ISNUMBER() and ISBLANK() functions.png)
Using IF(), ISTEXT(), ISNUMBER() and ISBLANK() functions.
Using UPPER(), LOWER() and PROPER() functions with NESTED IF().
Latest
-
Understanding How HYPERLINK Works In Excel
Excel has a built in function to create hyperlinks &...
-
Understanding how MS Excel Query Works
“Query” in MS Excel has same meaning as ...
-
An Introduction To Excel Power Map
Our today’s post is about “Power Map&rdq...
-
Using Pivot Charts For Displaying Data
Conventional charts are mostly used for displaying r...
-
Using “Calculated Items” For Analyzing A Pivot Table
In our last post, we explored how to use calculated ...
