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 Trainings

Practice: Basic functions-III

Practice: Basic functions-III

Using basic functions with more practices.


Practice: Basic functions-IV

Practice: Basic functions-IV

Using basic functions with more practices.


Profitability of a Theater

Profitability of a Theater

Using four operations and statistical functions over a scenario which is related plays tickets status of a theater.