To translate selected cells in one click and paste the translation results in the document right away, you may click on the "Translate selection and replace" button. You can find it in the "Sheet" tab of the plugin. Please note that this action cannot be undone and it is also important to click on a "Yes" button once you see the corresponding warning to get the translation results.
Please refer to the video below to see how this button works.