R_Statistical (MAX,MIN,Average)

-------------------summarizes a sample of values by a single value.

• Statistical functions

• Math functions

• Logical functions

-------------tell you what the largest numeric value is in a set of values or in a range of cells.

• MAX()

• MIN()

• IF

The MAX function returns the largest numeric value in supplied data:

=MAX(12,17,25,11,23)

returns

When given a range, =MAX(A1:A10)

MAX returns the ------------ value in the range:

• Biggest

• Smallest

• Not mentioned

The MAX function can accept a mix of arguments: check the next syntax if they are true or false

=MAX(5,10)

 =MAX(A1,A2,A3)

=MAX(A1:A10,100)

=MAX(A1:A10,C1:C10)

• True

• False

Find the latest(largest)delivery date

=MAX(Ali,ahmed) 

Will return------

• Error

• Zero

=MAX(B2:B7)

Will return

• Error

• Zero

Ali wants to know the highest mark he got in which subject--------------.

• Max()

• SumIf()

• Sum()

-------------returns the smallest numeric value in a range of cells.

• MAX()

• MIN()

• IF