The Explore command in Google Docs, Sheets and Slides allows you to research information without leaving your file. You will receive instant suggestions based on the content of your sheet, and can view related topics at any time.
As well as a feature that allows you to ask plain English questions about your data, the Explorer option in Google Sheets now includes formatting suggestions, to help you present your data in the best way for your audience. In addition, you can ask the Explorer option to create charts based on your data.
To explore the data in a sheet:
Click on the Explore button near in the bottom-right corner of the screen
Suggested questions about your data will be listed at the top of the Explorer pane - click on a question to view the answer, or type your own question in the Ask a question about your data box
Under the Answers area, click on a Formatting option to format your data
Scroll down the Explore pane to view pivot tables and charts for your data
Click on a chart or pivot table to show options to add the chart or table to your sheet
If the Explore button shows in grey, this means that Google has no insights to offer on your data. Try selecting specific data in the sheet to view insights on that data.