A student can remain correct if one of the grades written in cells D1, D2, D3 is less than 5. The formula that displays the students situation at the end of the semester is:

HOW TO USE THE CONCATENATE FUNCTION IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

A student can remain correct if one of the grades written in cells D1, D2, D3 is less than 5. The formula that displays the student’s situation at the end of the semester is:

A	=IF(D1<5, D2<5;D3<5;"CORRECTED";"PROMOTED")
B	=IF(D1>5, D2>5;D3>5;"CORRIGENT";"PROMOTED")
C	=IF(AND(D1<5, D2<5;D3<5);"PROMOTED";"CORRIGENT")
D	=IF(OR(D1<5, D2<5;D3<5);"CORIGENT";"PROMOVAT")

Explanation:

There is 1 question to complete.

FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO USE THE CONCATENATE FUNCTION IN EXCEL