The News GodThe News GodThe News God
  • Politics
    • Trump
  • News
    • Wars & Conflicts
  • Business & Finance
  • Lifestyle & Health
  • Law
  • Sports
  • Tech & Autos
  • Home & Garden
  • Videos
  • More
    • Travel & Tour
    • Education
    • Entertainment
      • Biography
      • Net Worth
      • Famous Birthdays
    • General
    • Pets
    • Blog
    • About Us
    • Disclaimer
    • Media Partners
    • Why You Need to Read Business News Everyday
    • Authors
    • Terms of Service & Privacy Policy
Reading: Google Sheets Now Suggests Automatic Formulas and Functions According to the Worksheet Context
Share
Font ResizerAa
The News GodThe News God
Font ResizerAa
  • Politics
  • News
  • Business & Finance
  • Lifestyle & Health
  • Law
  • Sports
  • Tech & Autos
  • Home & Garden
  • Videos
  • More
Search
  • Politics
    • Trump
  • News
    • Wars & Conflicts
  • Business & Finance
  • Lifestyle & Health
  • Law
  • Sports
  • Tech & Autos
  • Home & Garden
  • Videos
  • More
    • Travel & Tour
    • Education
    • Entertainment
    • General
    • Pets
    • Blog
    • About Us
    • Disclaimer
    • Media Partners
    • Why You Need to Read Business News Everyday
    • Authors
    • Terms of Service & Privacy Policy
Follow US
  • About Us
  • Authors
  • Advertise
  • Contact Us
  • Disclaimer
  • My Bookmarks
  • Terms of Use & Privacy Policy
  • Media Partners
The News God > Blog > Tech & Autos > Google Sheets Now Suggests Automatic Formulas and Functions According to the Worksheet Context
Tech & Autos

Google Sheets Now Suggests Automatic Formulas and Functions According to the Worksheet Context

Rose Tillerson Bankson
Last updated: October 30, 2021 4:27 pm
Rose Tillerson Bankson - Editor
October 30, 2021
Share
4 Min Read
SHARE

For the Google Sheets web application, there are often allegations (complaints might be the better description) that it is a much simpler version of spreadsheets compared to Microsoft Excel.

Since this service is free, we certainly cannot expect a large number of features and functions that are part of the existing Office suites, but Google is working intensively to improve Google Sheets.

Google Sheets Gets a New Update

It has been announced these days that Google Sheets is getting a new update that will introduce automated suggestions for formulas and functions in spreadsheets. The suggestions will work based on the context of displaying the tables and data in the worksheet. Google states that data analysis is done much faster in this way, and with the new application of machine learning models for various, random forms of data entered, users will get an automatic suggestion for using formulas.

Related Posts

THIS IS HOW INSTAGRAM ALGORITHM WORKS IN 2022
THIS IS HOW INSTAGRAM ALGORITHM WORKS IN 2022
The Importance of Updating your Software on the Latest Version
6 Best Sites To Buy Instagram Views In 2022 
Choosing the Perfect Template for Your Website: 5 Factors You Must Consider

The news of the update was published as a post on Google’s blog and its implementation began on August 25, and the option is expected to become available to all users within a two-week period. Once the required update has been performed, formula suggestions will be available to users as a default. If users want to disable the automatic usage of formula suggestions, they can do so by going to the “Tools” menu and unchecking the “Enable formula suggestions” box.

Formula suggestions are derived automatically from the context of the table and its data and, at the same time, the range of affected data is automatically marked. In a situation where we place ourselves in a cell below the list of numbers or values in Google Sheets, a box with a formula suggestion and a range of data cells will automatically open.

What Did the Tests Show?

Tests have shown that it really is a great tool. When we have, for example, one column of numerical data, users are offered the option of adding or calculating the average of the marked data by placing it in a cell below it. After the free-choice proposal of the summation of data (SUM) was accepted, further placement in the cell below the obtained result and re-entering the sign “=” to enter the new formula of the SUM option was no longer because it was already used for the same data sequence.

In formula selection situations, Google Sheets looks not only at the history of each user’s most commonly used formulas but also at the specific context of each new table and the ways in which the data is presented through column headers and headings.

Maybe it is not the right time or place, but Google Sheets proved effective in calculating the VIG (Vigorish) margin, i.e. the house edge, in gambling/sports betting at all casinos labeled as the best Booongo online casino (or some other online casinos offering games of splendid software providers). Every gambler or sports bettor should have a few spreadsheet formulas at his disposal. Spreadsheets allow you to organize, manage, explore, and visualize data in a logical manner. You can use Google Sheets to load and manipulate data, as well as simulate games, size bets, track schedules, detect hedging possibilities, and more – if you commit a little time. But more on that in a later article…

The Complete Guide to Flowcharts
A Complete Guide to Recover and Fix a Corrupted Hard Drive
How To Spy On Facebook Messages Free Without The Phone?
Which Free Tools are Exciting for Gamers?
5 Specific Details to Consider When Building Your Real Estate CRM
Share This Article
Facebook Email Print
Share
What do you think?
Love0
Sad0
Happy0
Sleepy0
Angry0
Dead0
Wink0
Previous Article How to Remotely Delete Games From the PS5 Console Using the PlayStation App?
Next Article 5 Proven Ways to Make Your Assets Untouchable During a Lawsuit

Latest Publications

Nigeria Issues Flood Alert
Nigeria Issues Flood Alert As Heavy Rain is Expected in 19 States
News
August 6, 2025
What Scientists and Skywatchers Are Saying About the Latest UFO Sightings
What Scientists and Skywatchers Are Saying About the Latest UFO Sightings
News
August 6, 2025
Two Killed and Dozen Injured In Russian Strike in Zaporizhzhia
Two Killed and Dozen Injured In Russian Strike in Zaporizhzhia
News
August 6, 2025
Wildfire in France killed 1 and injured several and is still spreading
Wildfire in France killed 1 and injured several and is still spreading
News
August 6, 2025
Valedictorian’s Mother and Tutor Caught Stealing Exam Papers
Mother and teacher steal exam papers to help student become valedictorian
News
August 5, 2025

Stay Connected

235.3kFollowersLike
69.1kFollowersFollow
11.6kFollowersPin
56.4kFollowersFollow
136kSubscribersSubscribe

You Might also Like

Top Strategies to Optimize Fleet Performance
Tech & Autos

Top Strategies to Optimize Fleet Performance

July 5, 2023
Zoviz Changed Branding Game by Introducing AI Logo Generator and Brand Kit Maker!
Tech & Autos

Zoviz Changed Branding Game by Introducing AI Logo Generator and Brand Kit Maker!

February 15, 2024
Here Are the Must-Know Technical Writing Techniques
Tech & Autos

Here Are the Must-Know Technical Writing Techniques

September 21, 2021
Wired Vs. Wireless: Choosing The Best Home Technology For Your Needs
Tech & Autos

Wired Vs. Wireless: Choosing The Best Home Technology For Your Needs

April 24, 2023
Show More
© 2025 Thenewsgod. All Rights Reserved.
  • About
  • Contact Us
  • Terms of Use & Privacy Policy
  • Disclaimer
  • Authors
  • Media Partners
  • Videos
Welcome Back!

Sign in to your account

Username or Email Address
Password

Lost your password?