Capgemini interview question

Logical functions and conditional functions questions in Excel