USING MICROSOFT EXCEL
HOW TO INSERT HEADERS FOOTERS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
expand external data forms into a user-friendly format.
|
|
|
transform small amounts of data into a user-friendly format.
|
|
|
summarize many workbooks into a user-friendly format.
|
|
|
summarize large amounts of data into a user-friendly format.
|
|
|
summarize many worksheets into a user-friendly format.
|
Detailed explanation-1: -Filter the information by clicking on the dropdown list in the Row Labels cell and selecting the appropriate built-in filter options. To make filtering easier for all users, you can add specific filters to your pivot table by dragging the relevant fields to the filters area in the pivot table field list.
Detailed explanation-2: -A PivotTable is an interactive way to quickly summarize large amounts of data. You can use a PivotTable to analyze numerical data in detail, and answer unanticipated questions about your data. A PivotTable is especially designed for: Querying large amounts of data in many user-friendly ways.
Detailed explanation-3: -In the PivotTable, right-click the value field you want to change, and then click Summarize Values By. Click the summary function you want.