DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Clicking on the Insert Tab and inserting a Pivot Table.
|
|
|
Create or select data that needs to be analyzed.
|
|
|
Deciding on which fields (column and row labels) to use to analyze the data
|
|
|
None of the above options are correct.
|
Detailed explanation-1: -What is the first step for creating a Pivot Table? Clicking on the Insert Tab and inserting a Pivot Table. Deciding on which fields (column and row labels) to use to analyze the data. Create or select data that needs to be analyzed.
Detailed explanation-2: -To convert this pivot table to an ordinary data table, simply select the entire pivot table (in this case, we select the range E1:I6) and press Ctrl+C to copy the data. Then right click the cell where you’d like to paste the data (we’ll choose cell E8) and click the option titled Paste Values: What is this?
Detailed explanation-3: -Clicking on the Insert Tab and inserting a Pivot Table. Create or select data that needs to be analyzed. Deciding on which fields (column and row labels) to use to analyze the data. None of the above options are correct.