The condition operators affects the condition itself, which primarily are hit based (exceptions are present)
The exclude/include affect based on the container level - hit/visit/visitor
I am going to take the example I had used in Adobe summit to explain:
Suppose there are 4 visits with the following pages seen:

This is the output you will see when you use the combination of operator and visit based container

To explain further, each hit is going to be analyzed against the condition to see if it matches.
- When an include container is used, it takes all the content of the visit if any hit matches the condition within the visit. This will not exclude if the condition doesn't match.
- When an exclude container is used, it excludes all the content of the visit if any hit matches the condition within the visit. This will not include content if the condition doesn't match.
I am better at explaining it orally. Hope this helps.
Now lets look at your question: "The purpose is to get result for all visited pages that "during the visits, never visited the page name: coupon".
For this you want exclude all visits if the page "coupon" is present. So you will be using the following:
Container level: Visit
Container setting: Exclude
condition: Page contains coupon
-Hyder