Truist interview question

Excel related questions regarding Boolean operators etc.