Logo
Section 1 / 5

表格技巧(第一部分)

了解 Google 表格的基本组件,如何定位和引用数据,并应用基本的视觉格式设置。

导入

表格技巧(第一部分)

了解 Google 表格的基本组件,如何定位和引用数据,并应用基本的视觉格式设置。

...
Overview of spreadsheet layout
...
New Google Sheet
...
Cell reference example using the Name Box
...
Selecting cell A1 to enter a name as text input
...
Adding a numeric value (500) in cell B2
...
Viewing cell content in the Formula Bar after selecting A1 again
1.

If you’re in cell D5, what’s directly above it? What’s to its left?

0/500
...
Formatting tools in the toolbar
...
Font size drop-down in the toolbar
...
Font type drop-down in Google Sheets
...
Cell with custom text color and filled background
1.

What could go wrong if your spreadsheet has no formatting at all?

0/500

思考题

...
Range operator example
...
Selected range A1:A5 highlighted in the sheet
...
Colored cells highlighting a range (e.g., A1:A5)
...
Multiple tabs
...
Adding a new sheet
...
Insert a clickable link to another sheet
...
Type and select the target sheet name to create the link

步入数据分析

表格技巧(第二部分)