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.