USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following is not a built-in Group By option when grouping dates in PivotTables?
|
|
Days
|
|
|
Weeks
|
|
|
Months
|
|
|
Hours
|
Explanation:
Detailed explanation-1: -If even one of the cells contains invalid data, the grouping feature will not be enabled. Pivot Table won’t allow you to group dates and you will get a cannot group that selection error. So, the ideal step would be to look for those cells and fix them!
Detailed explanation-2: -Step 1: Right click on any date within date column in pivot table. From the menu click group. Step 2: From the dialogue box select year, month and quarters options. Click OK.
There is 1 question to complete.