USING MICROSOFT EXCEL
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: -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-2: -What is the use of a Pivot Table? A Pivot Table is used to summarise, sort, reorganise, group, count, total or average data stored in a table. It allows us to transform columns into rows and rows into columns. It allows grouping by any field (column), and using advanced calculations on them.
Detailed explanation-3: -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.