Question

how can we analyse data imported into a table?​

Answer 1

Answer:

Select the PivotTable Report option, which imports the tables into Excel and prepares a PivotTable for analyzing the imported tables, and click OK. Once the data is imported, a PivotTable is created using the imported tables

mark as brainliest

if it is helpful

Answer 2

Answer: Create your pivot data using the data. Now  that you've imported all your information into Excel ,you can create a pivot table to organize and compare the data. Right now, your spreadsheet just contains raw data. To take things step by step further, you can create a pivot table to analyze the information

hopefully it helps