TEST (class X)

How do I enter a formula in Excel?

Describe copy and paste options in Excel, how many options do we have and for which purposes can we use them?

What is the difference between COUNT, COUNTIF, and COUNTIFS?

What can MAX or LARGE do in Excel?

What result will be from this function: =AVERAGEIF(A1:B5, ">5")

How can you put a statement in A2 to indicate that A1 is larger than B1? Include a formula that is "correct".

Write a function to find the male students who have an average grade larger than 4.5, and tell how many students we have.

Write the function so that the final result is the number 18.

Describe each function. What do we do?
=IF(A1>=40, "PASS", "FAIL")
=SUM(C2+C3)
=COUNT(A1+A2+A3)

Now you must explain the functions AND & OR.
=IF(AND(A1>30, B1<20), "TRUE", "FALSE")

=IF(OR(C2>58, C3<74), "correct", "incorrect")

And write the results for the first and second function.