DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
format
|
|
|
organize
|
|
|
clean
|
|
|
correct
|
Detailed explanation-1: -The beauty of pivot tables in excel is they allow you to interactively explore your data in different ways. Therefore, it helps to make data analysis easier and more effective.
Detailed explanation-2: -Idea #2 – Show just top values This will greatly reduce the size of your pivot table. You can also collapse a sub-level detail so that user can press + if they want to see details. To set top 1 filter, simply click on the filter icon on field you want to set it, go to value filters > top 10 and then set it to top 1.
Detailed explanation-3: -A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data. PivotTables work a little bit differently depending on what platform you are using to run Excel.