How to check if column in table are true and return a value if all are true

I have a table with “checklist” fields. I’d like to be able to query the table and return “yes” or “no” if all fields are equal to a certain value. How is the best way to do this?

Thanks for your help!
Cynthia