FUNDAMENTALS OF COMPUTER

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?
A
Days
B
Weeks
C
Months
D
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.