The News GodThe News GodThe News God
  • Politics
    • Trump
  • News
    • Wars & Conflicts
  • Business & Finance
  • Lifestyle & Health
  • Law
  • Sports
  • Tech & Autos
  • Home & Garden
  • More
    • Travel & Tour
    • Education
    • Entertainment
      • Biography
      • Net Worth
      • Famous Birthdays
    • General
    • Games
    • 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
  • More
Search
  • Politics
    • Trump
  • News
    • Wars & Conflicts
  • Business & Finance
  • Lifestyle & Health
  • Law
  • Sports
  • Tech & Autos
  • Home & Garden
  • More
    • Travel & Tour
    • Education
    • Entertainment
    • General
    • Games
    • 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

Unveiling the Secrets of Jaguar Refinement
Unveiling the Secrets of Jaguar Refinement
7 Benefits of Having Solar Panels Installed at Your Home
How to find the best online SEO marketing company in Canada
Decluttering Your Digital Life: Tips Beyond the Inbox

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…

How Architecture Firms Can Boost Efficiency with Different Types of Software
Illuminating Sustainability: The Advantages of Solar Street Lighting
WhatsApp Chatbots Mastery: Elevate Your Customer Service Game
The Top Tips for Preventing Car Scratches
Pros and cons of using TikTok: is it the next big app?
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

New York Tour Bus Crash
At least 5 dead, Dozen Injured in New York Tour Bus Crash
News
August 26, 2025
Florida Sheriff Flaunts $50,000 Gold Chain Seized in Drug Bust
Florida Sheriff Flaunts $50,000 Gold Chain Seized in Drug Bust
News
August 25, 2025
Israeli Airstrike on Nasser Hospital
At least 15 people, including 4 journalists after Israeli strikes on Gaza Hospital
Wars & Conflicts
August 25, 2025
Jelena Jensen's biography
Jelena Jensen’s bio, net worth, career, personal life, measurements and more
Biography
August 25, 2025
Scarlet Red Biography, Wiki, Net Worth, Age, Boyfriend, Career, Height and More
Scarlet Red Biography, Wiki, Net Worth, Age, Boyfriend, Career, Height and More
Biography
August 25, 2025

Stay Connected

235.3kFollowersLike
69.1kFollowersFollow
11.6kFollowersPin
56.4kFollowersFollow
136kSubscribersSubscribe

You Might also Like

How to Properly Compare Cars Before Making a Purchase: A Guide

July 22, 2024
6 Ways to Boost Website Performance using PHP Framework
Tech & Autos

6 Ways to Boost Website Performance using PHP Framework

November 23, 2021
Essential Skills Every Successful Electrician Should Master
Tech & Autos

Essential Skills Every Successful Electrician Should Master

April 1, 2025
Maximising vehicle security: What to do and how
Tech & Autos

Maximising vehicle security: What to do and how

September 6, 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?