This is a short video that shows how you can use Google Translate in Google Sheets.
I used the formula:
=GOOGLETRANSLATE(A2:A6, "en", "fr")
The first entry is the range of the cells you want translated
The second entry is Source Language "en" or "auto" to auto-detect
The third entry is Target Language "fr"
You can use the two-letter language code for any language you want to translate.