Pivot tables must show the pivot table on the same sheet as the data, otherwise Excel cannot do pivot charts automatically True False
Question
Pivot tables must show the pivot table on the same sheet as the data, otherwise Excel cannot do pivot charts automatically True False
Solution
False. Pivot tables do not need to be on the same sheet as the data. Excel can create pivot charts from pivot tables regardless of their location.
Similar Questions
Information in pivot tables can only be used within the table. True False
Pivot tables do not process dates like Excel usually does, because ordering dates can be necessary and grouping couldn't otherwise be done True False
Pivot tables are the same as regular tables and therefore use the square brackets to refer to them True False
Pivot tables must have a row and column but don't have to have a filter category True False
Grouping data in a pivot table can be done manually or automatically True False
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.