开始使用免费开始使用

Select rows

In this exercise, you'll begin to populate our pivot table by selecting the Row Labels. On the right, you'll find the blank pivot table that was created in the previous exercise, containing the Top 10 companies by Revenue for 2017.

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

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

本练习是课程的一部分

Google Sheets 中的 Pivot Table

查看课程

练习说明

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

动手互动练习

通过我们的互动练习之一,将理论转化为实践

开始练习