USING MICROSOFT EXCEL
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: -Detailed Solution In Microsoft Excel, a pivot table allows the user to summarize and analyze worksheet data by extracting pieces of data from a much larger data set.