CST-MODULE 4

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

Layout section

The lower portion of the PivotTable Fields pane containing the four areas for layout; use this area to rearrange and reposition fields in the PivotTable.

PivotTable Fields Pane

A window that lists, at the top, all of the fields—column titles—from the source data for use in the PivotTable report and at the bottom, an area in which you can arrange the fields in the PivotTable.

Field section

The upper portion of the PivotTable Fields pane containing the fields—column titles—from your source data; use this area to add fields to and remove fields from the PivotTable.

Values area

An area to position fields that contain data that is summarized in a PivotTable report or PivotChart report. The data placed here is usually numeric or financial in nature and the data is summarized—summed. You can also perform other basic calculations such as finding the average, the minimum, or the maximum.

Filters area

An area to position fields that you want filter the PivotTable, enabling you display a subset of data in the PivotTable report

Columns area

An area to position fields that you want to display as columns in the PivotTable report. Field names placed here become column titles, and the data is grouped in columns by these titles.

ROWS area (Pivot Table)

An area to position fields that you want to display as rows in the Pivottable report. Fields names placed here become row titles, and the data is grouped by these row titles


Set pelajaran terkait

Drivers Ed - Kansas driving handbook

View Set

Landmark Supreme Court Cases - Law and Justice Feb 2021

View Set

Chapter 49: Disorders of Endocrine Control of Growth and Metabolism

View Set

ECON 224 Chapter 1 and 2 Quick Quiz

View Set

GenPath: (9) Environmental and Nutritional Diseases

View Set

Human Growth and Development Chapter 3

View Set

Throckmorton Money & Banking Exam 2

View Set