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

question 7

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.