4.2:  Create, Edit & Format a Spreadsheet
Create a Spreadsheet:
There are different ways of getting started using Google Spreadsheets: you can create a new Google spreadsheet, you can upload a spreadsheet from a computer, or you can use a template from the templates gallery.

To create a new spreadsheet, go to your Drive, click the red NEW button, and select Sheets from the drop-down menu. You can always type sheet.new in your omnibox as well!

Edit & Format a Spreadsheet:
To enter content in an empty cell, click the cell and add your content. To edit a cell that already has content, double-click the cell and edit the content. Alternatively, you can click the cell once and press Enter or F2.

If you want to improve the look of text that requires line breaks, such as addresses, you can create lines breaks within a cell while editing. To create a line break, place your cursor in a cell and press Ctrl+Enter.

You can format data in your spreadsheets in a variety of ways using the options in the spreadsheet toolbar. You can hover over an icon on the toolbar to see a message describing what that option can do. Below is the toolbar in Sheets.

You can format numbers in a spreadsheet in a variety of ways, including decimal, percent, and scientific notation. You can also select different date formats and currencies to correctly display the data in your spreadsheet.

To format or change the format of numbers, dates or currencies in a spreadsheet, follow these steps:
  1. Select the range of cells you'd like to format or modify.
  2. Click the 123 toolbar icon.
  3. Select the number, date, or currency format you'd like to apply to the range of cells.
Activity:
Learn more about other formatting tools in Google Spreadsheets.


Using Formulas in Spreadsheets:
You can add a formula to any cell in a spreadsheet by typing an equal sign (=) followed by the name of the function. Auto-suggest will show a box displaying the name and syntax of the formula you're building. You can also use the function tool on the toolbar (show right).

For example, let's say you want to calculate the absolute value of a sum of several numbers in the cell range A1:A7. To calculate the sum of these numbers, you would enter '=SUM(A1:A7)' into a cell.

When you reference other cells in a formula, we highlight those cells in contrasting colors to help you more easily build a formula. When you click on the cell that contains a completed formula, you'll also see these cells highlighted.

https://lh5.googleusercontent.com/SZeBV0YvdZnGZcpeFQZOK-LxhPXX8Hx09hzLtUaWAbxjNU3dYqwc7SxtnRVxLr_EUK0eZp3WCNutLWcriGqJHAkT4_iMvlCWz2JA_kR95Q4OWPvxTqzLWUflXomB5v8R9miL2NRL
Insights, instantly 
Updates to Explore in Sheets help you decipher your data easily, whether you’re new to spreadsheets or a formula pro. Just ask Explore — with words, not formulas — to get answers about your data. You can ask questions like “how many units were sold on Black Friday?,” “what are the top three items by sales price?,” or “what was the total cost of jackets last month?” Less time crunching numbers + crafting formulas = more time to find key insights and use them.

We’ve also added new formatting suggestions to help make your data pop. Explore in Sheets is available on the web, Android and now on iOS, too!

Activity: Learn more about functions and formulas in Google's comprehensive list of functions.