DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Column Labels
|
|
|
Formulas
|
|
|
Values
|
|
|
Report Filter
|
Detailed explanation-1: -A: Correct answer is Text box. Text box can be used to add to insert values.
Detailed explanation-2: -Layout Areas At the bottom of the PivotTable Field List pane are the four areas of the pivot table: Report Filter, Column Labels, Row Labels, and Values.
Detailed explanation-3: -PivotTable Fields is a Task Pane associated with a PivotTable. The PivotTable Fields Task Pane comprises of Fields and Areas. By default, the Task Pane appears at the right side of the window with Fields displayed above Areas. Fields represent the columns in your data – range or Excel table, and will have check boxes.
Detailed explanation-4: -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.