Which of the following is not in the Pivot table field list box?Select one:A.ValuesB.FormulasC.Report filterD.None of these
Question
Which of the following is not in the Pivot table field list box?Select one:A.ValuesB.FormulasC.Report filterD.None of these
Solution
The correct answer is B. Formulas. In a Pivot Table field list box, you will typically find Values, Report Filters, Column Labels, and Row Labels. However, Formulas are not directly included in the Pivot Table field list box. You can create calculated fields or items which are based on formulas, but they are not a standard feature in the field list box.
Similar Questions
Uma can remember that when you create a Pivot Chart the Field filters appear on the Pivot Chart. Sean has just walked in talking about how useful Report Filters are. Uma now cannot recall if Report Filters also appear on the Pivot Chart. Do they? (Hop over to Excel and create a chart for a table that contains a report filter if you are confused as well).
Which of the following statements are true for Pivot Tables?(Multiple answers possible. Partial credit awarded)1 pointYou can use a text field in the Values areaYou can apply different functions - average, count, etc - to numeric fieldsNumeric values can only be summedCount can only be applied to text field
A pivot table Field List does not contain this option:ValuesRow LabelsSortColumn Labels
Where do we find the option of a pivot table?Select one:A.HomeB.DeveloperC.InsertD.Formulas
Information in pivot tables can only be used within the table. 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.