FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Line chart. On a PivotTable, what is a field with values not entered as data but determined by a computation involving data in other fields called? Calculated field. What can you use to easily filter PivotTables and cube functions interactively in a worksheet? Slicer.

Detailed explanation-2: -A calculated field is a new field that performs calculations based on existing fields in your PivotTable. For example, you could use a calculated field to find the average ticket sales using an existing total sales field and a field containing the number of tickets sold.

Detailed explanation-3: -NOTE: Typically, nonnumeric fields are added to the Rows area, numeric fields are added to the Values area, and Online Analytical Processing (OLAP) date and time hierarchies are added to the Columns area.

Detailed explanation-4: -On the Analyze or Options tab, in the PivotTable group, click Options. On the Display tab, under Display, do one or more of the following: To show items with no data on rows, select or clear the Show items with no data on rows check box to display or hide row items that have no values.

Detailed explanation-5: -The pivot table error, “field name is not valid", usually appears because one or more of the heading cells in the source data is blank. To create a pivot table, you need a heading value for each column.