Most users look for these 3 options.
One positive -
Yes,OK,Add,Retry,Wait..etc.One negative -
No,Abort,Quit,Exit
and the third one is:
- "Escape from this Message Box" -
Cancel
So, using Yes, NO, and Cancel makes three different types of thoughts.
That means, their usage depends on the case.