Grade_12_Term2_Revision

Statistical functions summarizes a sample of values by a single value

• True

• False

  All of these are complex formula Except---------.

•  2+3*4-1

• 3*4

• (5+2)*8

In this complex formula: 

=2*(8-6)/2^5

 which part will be calculated first if the parentheses are removed?

Using the order of operations specify which part of this complex formula will be calculated first                                                           

 (7+5)^2*3              

Using the order of operations specify which part of this complex formula will be calculated first                                                           

6^2-2*(5+1+3)                 

Using the order of operations specify which part of this complex formula will be calculated first                                                           

80-7+85/5*3                

What would =COUNT(A:B) return?

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

• MAX()

• IF

• MIN()

=COUNTIF(A1:A10,"<>")

Counts cells that are -------

• Not mentioned

• Blank

• not blank

=MAX(Ali,ahmed) 

Will return------

• zero

• error