開始使用免費開始

Select columns

In this exercise, you'll further populate your pivot table by selecting the Column Labels.

You will populate the Columns by selecting among the following categories: Name, Headquarters, and Industry.

You'll start by selecting a single Column Label, then removing it, then you'll select multiple Column Labels

本練習屬於課程

Google Sheets 的樞紐分析

檢視課程

練習說明

  • Select Add in the pivot table editor next to the Columns section, and choose Industry; this will list each industry in the dataset.
  • Now click the X in the upper right section of the Industry box in the pivot table editor, this will remove the names.
  • Now select Add and choose Year, select Add again, and choose Headquarters.

動手互動練習

將理論付諸實踐,立即體驗我們的互動練習

開始練習