Critical Thinking Case-Based Questions Case 5-3 as He Prepares His

Multiple Choice

Critical Thinking Case-Based Questions Case 5-3 As he prepares his assignment for his Marketing class, Ted goes to his friend Carter for help with PivotTables because Carter has had a lot of experience with them in his job. Ted wants to be able to use his PivotTable to combine items into groups. Which of the following is true?

A) Items that appear as row labels cannot be grouped.
B) Items that appear as column labels can be grouped.
C) If items are dates, they cannot be grouped automatically using the Grouping dialog box.
D) If items are numbers, they cannot be grouped manually using the Ctrl key to select items in a group and then choosing Group from the shortcut menu.