DATABASE FUNDAMENTALS
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: -Drag a date field into the Row or Columns area in the PivotTable Fields task pane. Select a date field cell in the pivot table that you want to group. Excel may have created a Year and/or Month field automatically. Right-click the cell and select Group from the drop-down menu.
There is 1 question to complete.