DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Next to the last column of data in your worksheet.
|
|
|
Below the last row of data in your worksheet.
|
|
|
It depends on whether you select to insert the Pivot Table in the current worksheet or a new worksheet and where your cursor is.
|
|
|
Above the first row of data in your worksheet.
|
Detailed explanation-1: -Where is a Pivot Table inserted? Next to the last column of data in your worksheet. Below the last row of data in your worksheet. It depends on whether you select to insert the Pivot Table in the current worksheet or a new worksheet and where your cursor is.
Detailed explanation-2: -Go to Insert > PivotTable. Excel will display the Create PivotTable dialog with your range or table name selected. In this case, we’re using a table called “tbl HouseholdExpenses". In the Choose where you want the PivotTable report to be placed section, select New Worksheet, or Existing Worksheet.
Detailed explanation-3: -Pivot table is in the Insert tab within table group command.
Detailed explanation-4: -A table which horizontally-organised data points. A table used to compute financial pivot values.
Detailed explanation-5: -A PivotTable is an interactive way to quickly summarize large amounts of data. You can use a PivotTable to analyze numerical data in detail, and answer unanticipated questions about your data.