Your Web News in One Place

Help Webnuz

Referal links:

Sign up for GreenGeeks web hosting
August 26, 2021 05:59 pm

Google Sheets formula suggestions are like autofill for math





Illustration: Alex Castro / The Verge



Google has announced that Google Sheets is getting the ability to intelligently suggest formulas and functions for your spreadsheet, based on the data you're trying to analyze. For example, typing “=” into a cell below a list of numbers will pop up a box that lets you automatically add the numbers together, find their average, and more.


From my admittedly simple tests, it seems to be a pretty smart system. For example, with one column of data, it suggested that I could be looking for either the sum or average of the numbers. After I chose the sum and moved down to the next cell, it only suggested finding the average for the same range of numbers, not including the sum I’d just calculated. It’s a simple thing, keeping track of what’s data...



Continue reading…




Original Link: https://www.theverge.com/2021/8/26/22642192/google-sheets-intelligent-formula-functions-spreadsheet-context-aware-math

Share this article:    Share on Facebook
View Full Article

The Verge

The Verge is an ambitious multimedia effort founded in 2011

More About this Source Visit The Verge