If you haven't noticed this little gem, that's because it is hidden at the bottom right corner of your Sheets screen.
While the Explore button has been there for a little while, it has recently gotten a few updates. Let's take a look at what the Explore button can do...
Get Answers About Your DataOne really cool features in Explore is the Answers section. At the top of any Explore pane, you will see a search box that says, "Ask a question about your data". So for instance, with the demo sheet available with the new explore button, there is a great deal of data about the World Cup. You could simply type in "Who was the winner?" and get a quick answer about that data.
Learn from the FormulaWant to know how they did that? With any question you ask you can click See Formula and see the Sheets formula used to find the data related to your question. For example, in a question about who the winner is, Sheets uses the unique filter to arrive at the answer:
Once you find your answer, and view the formula, you can click on the formula and it will be copied to your clipboard so you can use it and apply it elsewhere. This is a great way to learn more about the use of Functions and Formulae.