Name: 如何使用Google Sheets (How To Use Google Sheets)
Uploaded: 2020-12-31T18:20:31.000Z
Duration: 7 min 34 s

Use the clickable sections below to skip through different parts of this tutorial.

使用下面可點擊的部分來跳過本教程的不同部分。

分詞構句

Once logged in, click on the Google Maps icon at the top right corner of your screen.

登錄後，點擊螢幕右上角的谷歌地圖圖標。

You can also launch sheets through Google Drive.

你也可以通過Google Drive啟動工作表。

Click on plus new Google sheets on then blank spreadsheet.

在空白的電子表格上點擊加新的谷歌表格。

When using sheets, Google Drive automatically saves everything as you go.

使用sheet時，Google Drive會自動將所有內容隨手保存。

Just make sure you're connected to the Internet.

You'll represented with a blank sheet and other template options.

你將代表一個空白表和其他模板選項。

Google Sheets offers ready made templates for personal and business use, such as the invoice Template weekly Planner on Expenses report.

Google Sheets提供了現成的模板，供個人和企業使用，如發票模板每週計劃員的支出報告。

We'll start with a blank sheet to name your sheet, click on untitled spreadsheet and type the name.

我們先用一張空白的表格來命名你的表格，點擊無標題的電子表格，然後輸入名字。

By clicking on the folder icon, you'll be able to choose from an existing Google Drive folder or create a new one.

通過點擊文件夾圖標，您將能夠從現有的Google Drive文件夾中選擇或創建一個新的文件夾。

每份文件都是由一張紙組成的。

You'll see this at the bottom where it says sheet one.

你會在底部看到這個，上面寫著第一張。

You can have multiple sheets within each document to add a new one.

每個文檔內可以有多張單子來添加新的單子。

Click on the plus icon to rename your sheet double click on sheet one.

點擊加號圖標，重命名你的工作表，雙擊工作表一。

輸入你的新名字，然後按回車鍵。

Click on the arrow positioned next to the title to see more ways to organize your sheet.

點擊標題旁邊定位的箭頭，查看更多整理表的方法。

You could duplicate your sheet or copy it to another spreadsheet to keep certain sheets private.

你可以複製你的工作表或將其複製到另一個電子表格中，以保持某些工作表的隱私。

Within a document, you can activate a password by clicking here.

在文檔中，您可以通過點擊這裡激活密碼。

You can also change the color of your sheet by hovering your cursor over.

您也可以通過將遊標懸停在工作表上改變工作表的顏色。

To import data into your sheet, go to the top menu and click file and then import.

要將數據導入到您的工作表中，請進入頂部菜單並單擊文件，然後導入。

A pop up menu will appear and you'll be presented with options of where you can upload your file from.

一個彈出式菜單會出現，你會看到你可以從哪裡上傳文件的選項。

Let's upload an Excel file from our computer, click on upload and click Select file from your device.

我們從電腦上上傳一個Excel文件，點擊上傳，然後點擊選擇設備上的文件。

Choose Google Sheets will ask you how you'd like to format your uploaded data.

選擇Google Sheets會問你想如何格式化你上傳的數據。

You can create a new spreadsheet, replace data at selected cell or replace the entire spread shoot.

您可以創建一個新的電子表格，替換選定單元格的數據或替換整個電子表格。

We'll select to create a new spreadsheet.

我們會選擇創建一個新的電子表格。

You'll need to ensure that your Excel file is converted to ensure it works properly in Google Sheets.

你需要確保你的Excel文件被轉換，以確保它在Google Sheets中正常工作。

To do this go to the Google Drive settings tool.

要做到這一點，請進入Google Drive設置工具。

Click on settings, then click the box next to convert up loads.

點擊設置，然後點擊轉換上載旁邊的方框。

Your files will now be automatically converted in the future.

你的文件現在會在未來自動轉換。

Sheet consists of cells, columns and rows, columns that indicated alphabetically at the top and rose numerically down the side.

表格由單元格、列和行組成，列在頂部按字母表示，列在側面按數字表示。

You can select each column or each row by clicking on its letter or number.

你可以通過點擊每一列或每一行的字母或數字來選擇它。

You can double click on a cell types of information and press enter.

您可以雙擊單元格類型的資訊並按回車鍵。

When using Google sheets, you'll want to know which sell your information is in when using formulas.

在使用谷歌單子時，你要知道你的資訊在哪個賣場使用公式。

Each cell is named by the column letter, followed by the row number.

每個單元格用列號命名，然後是行號。

The Row nine is highlighted on the left G nine.

You can select multiple cells, which is useful when you need to create formulas or want to move cells around, click on a cell and drag your cursor across other cells to select a group.

您可以選擇多個單元格，當您需要創建公式或想要移動單元格時，這很有用，點擊一個單元格，然後將遊標拖動到其他單元格上選擇一組。

We'll click on C five and then dragged down to see 13.

我們點擊C五，然後向下拖動就可以看到13。

Once selected, you can hover over the edge of the selection until you see the grab icon, click and drag to move yourselves around.

選定後，你們可以將鼠標懸停在選區的邊緣，直到看到抓取圖標，點擊並拖動來移動自己的位置。

When using formulas in Google sheets, you may need to refer to a group of cells you're selecting.

在Google工作表中使用公式時，你可能需要參考你所選擇的一組單元格。

This range would be called C five colon H 13.

You can use basic formulas in Google sheets to create a formula.

你可以在Google sheets中使用基本公式來創建一個公式。

Select the cell where you want to see your answer at the top of your screen.

選擇您想在螢幕上方看到您的答案的單元格。

Click on the white Bar next to the FX sign.

For each cell, you'll be able to write formulas here as well as edit.

對於每個單元格，你可以在這裡寫公式，也可以編輯。

Let's use a formula to add up how much stock we have.

我們用一個公式來計算一下我們有多少庫存。

First, double click where you want the total and then type the equation in the FX bar always started formula with an equal sign followed by the formula instruction type equals, followed by some in capital letters, followed by open bracket, followed by the range Our ranges from D five to D 13 as thes air the numbers we want to total.

首先，雙擊你想要總計的地方，然後在FX欄中鍵入公式，總是以等號開始公式，然後是公式指令鍵入等號，後面是一些大寫字母，後面是開放的括號，後面是範圍我們的範圍從D五到D13作為空氣的數字，我們要總計。

So will type D five colon D 13, followed by a closed bracket sign to complete the equation.

所以將打出D五冒號D13，後面再打上一個封閉的括號來完成等式。

If the formula has been entered correctly.

The total will immediately be showed in the cell.

If you've made a mistake, perhaps you've misspelled something.

如果你犯了錯誤，也許你拼錯了什麼。

一個空氣，一個符號會這樣出現。

Then you should go back to your FX bar, and you can edit it until it's correct.

那麼你應該回到你的FX欄，你可以編輯它，直到它的正確性。

You could learn how to create other formulas by learning the Google Sheets language.

你可以通過學習Google Sheets語言來學習如何創建其他公式。

Create a header so it remains at the top of your sheet.

創建一個頁眉，使其保持在你的工作表的頂部。

When you scroll down, hover your mouse over the gray line at the bottom of the top left corner, sell and it'll turn blue, click on it and drag past the head of cell and release.

當你向下滾動時，將鼠標懸停在左上角底部的灰色線條上，賣出，它會變成藍色，點擊它，拖過單元格的頭部，然後釋放。

All the cells in Row one are now a header.

現在第一行的所有單元格都是頁眉。

You can use the same method to lock cells in a column, customize your header by clicking on it and using the format icons at the top of your page.

您可以使用同樣的方法鎖定一列中的單元格，通過點擊它和使用頁面頂部的格式圖標來定製您的標題。

First, highlight the data you want to use in your chart, then go to insert and click on chart.

首先，高亮顯示你要在圖表中使用的數據，然後去插入並點擊圖表。

Your chart will appear alongside and editing window to change from a to D bar chart to a different style of graph.

您的圖表將出現在旁邊和編輯窗口，以改變從一個到D條形圖到不同風格的圖形。

Select chart type and choose the design you want.

選擇圖表類型，選擇你想要的設計。

You can add a Siri's to your chart by selecting.

您可以通過選擇將Siri的添加到您的圖表中。

Add Siri's to delete it, click on the three dots and then select.

添加Siri的要刪除它，點擊三個點，然後選擇。

Remove for more ways to change your chart, click on the customized tab to change your background color and format your chart.

刪除更多的方式來改變你的圖表，點擊自定義標籤來改變你的背景顏色和格式的圖表。

 Click on charts style and select your preferences. 

點擊圖表風格，選擇你的喜好。