USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Records
|
|
|
Fields
|
|
|
Cells
|
|
|
Ranges
|
Detailed explanation-1: -In the PivotTable Fields List, at the top, are the fields we’ll use to create the PivotTable. They are the same as the column headings in the source data. At the bottom are the four areas of a PivotTable; the fields can be added to: ROWS, COLUMNS, VALUES, and FILTERS.
Detailed explanation-2: -When you create a Pivot Table report, each column of your source data becomes a field that you can use in the report. Fields summarize multiple rows of information from the source data.
Detailed explanation-3: -In the PivotTable Field List, you can add fields to the PivotTable or PivotChart by doing one or more of the following: To place a field in a designated area of the layout section, in the Choose fields box, select the check box of the field that you want. You can then rearrange fields later if you want.
Detailed explanation-4: -To display the PivotTable Field list, right-click any cell in the pivot table and select Show Field List from the menu. When we add fields to the Column Labels area of a Pivot Table, they appear as headings on the left of the table.