DATABASE FUNDAMENTALS
HOW TO INSERT HEADERS FOOTERS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
You create a PivotTable to:
|
|
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.
|
Explanation:
Detailed explanation-1: -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-2: -In the PivotTable, right-click the value field you want to change, and then click Summarize Values By. Click the summary function you want.
There is 1 question to complete.