Basic Google Translate Functions

Google Translate is a very useful tool to interpret foreign languages to a language you understand. Translate allows you to travel across the world and be able to function without the language barrier. It is also great a tool to interpret full websites online.

Basic Translate Feature

You can type in any language into the the translate box and google will recognize the language and translate to the selected language. You can also paste text into the box.

enter-text-here

The translated text will appear on the right side of the text box. This text is copyable.

translated-text

Translating Whole Websites

To translate a website copy and paste the URL into the translate box. The click on the blue hyperlinked URL in the translated section. This will translate the website to the language that is selected.

translated-url

In some cases, Google will recognize a site is in a different language and you can click the translate button on the far right end of the address bar next to the bookmark star.

Saving Phrases

You can save phrases that you have translated by clicking on the star in the translate box under the translated phrase.

save-phrase-feature

The saved phrases can be accessed by clicking on the star shape to the upper right of the translate box.

saved-phrases

Sharing Phrases

You can share a translation with people via Email, Twitter, or Google+. To share click the furthest right tool at the bottom of the translation box and select the option you want to use.

share-button

When you share via Email, it will automatically be copied into a new Email draft.

screenshot-2016-12-13-at-10-34-12-am

When shared via Twitter, it will create a tweet with the translated information ready to tweet.

screenshot-2016-12-13-at-10-30-41-am

When you share via Google+, It will create a post that you can comment on.screenshot-2016-12-13-at-10-33-20-am

Questions and Comments

Thank you for viewing, if you have any questions or comments you can email me at pchavez@apps.ashgrove.k12.mo.us . Thank you.

Bio

Paul Chavez – Student

Paul (@ChavezHelpDesk) is a senior at Ash Grove High School. He is involved in Student Help Desk and Beta Club. He is also on the football, basketball, and baseball teams. He is one of nine children in his family. In the future, Paul will be attending college at a college that is yet to be determined.

20160908_100249

 

Advertisements

Google Spreadsheets (Sheets) Tips – Paul Chavez

Google is an easy, efficient way to store, organize, and analyze your data. Sheets is a tool that can be used very effectively when used properly. These tools will help you navigate your way through Sheets and will help you save time.

Inserting a Comment

There are three main ways to insert a comment into Google Spreadsheet.

1.  Select the cells that you wish to leave a comment on. Click on the “Insert” tab in the upper left corner. Once the drop down menu opens on the “Insert” tab, select the option labeled “Comment.” Proceed to enter your comment into the box that appears and left click “Comment” for it to be submitted. An alternate way to submit your comment is by pressing on your keyboard ctrl + enter.   insert-tab-1

2.  Select the cells that you wish to leave a comment on. Right click inside the cells selected and click “Insert Comment.” Proceed to insert your comment and click “Comment” for it to be submitted. An alternate way to submit your comment is by pressing on your keyboard ctrl + enter.Screenshot 2016-10-06 at 10.26.36 AM.png

3.Select the cells that you wish to leave a comment on. On your keyboard press Ctrl + Alt + M to insert a comment. Proceed to enter your comment into the box that appears and left click “Comment” for it to be submitted. An alternate way to submit your comment is by pressing on your keyboard ctrl + enter.

 

Using Borders

borders

To insert a border on your spreadsheet, select the cells, click on the “Borders” symbol, and select the border you want to use. You can also change the color of the border and the border style once you click the “Borders” symbol. 

borders-tab

Changing Formats of Numbers

Changing formats gives you different ways to present data.

formatting

Select the “Format” tab on the access bar, click “Number”, and select the option you want from the list. If the format you want is not present, click the “More Formats” option to choose more options or create your own format.

 

Copying Box into Multiple Rows/Columns

 

This a pretty easy tool to use. Place your cursor in the bottom right corner of the box you wish to copy, the cursor should become a small symbol resembling an addition sign. Left click and hold, then drag your cursor into the rows/columns you wish to copy it into.

Freezing

If you are having trouble keeping your data organized, then freezing might be for you. Freezing rows or columns is an effective way to use headers on your sheets. The freeze bars are located on the perimeter of the cell to the left of the “A” tab and above the “1” tab.

untitled-drawing-9

Formula Continuation Tip

If you have a minimum of 2 cells with a formula you would like to continue, you can easily continue that formula without having to keep typing it out. Select the cells with the formula you want to continue the formula from. Then, click and hold on the bottom right corner of the highlighted cells and drag to the cells you wish to continue with the formula.

 

More Information

If you would like to learn more about Google Sheets, go to Cole Davis’ Blog. He has created another blog about sheets, Google Sheets: Basic Functions. If you have any questions over this content or Sheets, you can contact me via email at:  pchavez@apps.ashgrove.k12.mo.us 



Bio

Paul Chavez – Student

Paul (@ChavezHelpDesk) is a senior at Ash Grove High School. He is involved in Student Help Desk and Beta Club. He is also on the football, basketball, and baseball teams. He is one of nine children in his family. In the future, Paul will be attending college at a college that is yet to be determined.

20160908_100249