By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
The News GodThe News God
  • Politics
  • News
  • Business & Finance
  • Lifestyle & Health
  • Sports
  • Tech & Autos
  • Home and Garden
  • Other Categories
    • Travel
    • Education
    • Entertainment
    • Law
    • General
Reading: Google Sheets Now Suggests Automatic Formulas and Functions According to the Worksheet Context
Share
The News GodThe News God
  • Politics
  • News
  • Business & Finance
  • Lifestyle & Health
  • Sports
  • Tech & Autos
  • Home and Garden
  • Other Categories
Search
  • Politics
  • News
  • Business & Finance
  • Lifestyle & Health
  • Sports
  • Tech & Autos
  • Home and Garden
  • Other Categories
    • Travel
    • Education
    • Entertainment
    • Law
    • General
Follow US
  • Blog
  • Blog
  • Advertise
  • Advertise
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

Abubaker Rafiq
Abubaker Rafiq  - Content Writer October 30, 2021
Updated 2021/10/30 at 4:27 PM
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.

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…

You Might Also Like

Important Tips to Make Your Apple Watch App Development Successful

How Is Polycarbonate Made?

How To Fix Access Panels With Minimal Tools

What You Need to Do Before Launching Your Cryptocurrency Exchange

London Declared Biggest Non-US Tech Hub

Abubaker Rafiq October 30, 2021
Share this Article
Facebook TwitterEmail Print
Share
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

Stay Connected

235.3k Followers Like
69.1k Followers Follow
11.6k Followers Pin
56.4k Followers Follow
136k Subscribers Subscribe

Latest News

Important Tips to Make Your Apple Watch App Development Successful
Important Tips to Make Your Apple Watch App Development Successful
Tech & Autos July 1, 2022
Money Saving Tips for Online Shopping
Money Saving Tips for Online Shopping
Business & Finance July 1, 2022
How To Delay Your Period For A Summer Holiday
How To Delay Your Period For A Summer Holiday
Lifestyle & Health June 30, 2022
Polycarbonate
How Is Polycarbonate Made?
Tech & Autos June 30, 2022

You Might also Like

Important Tips to Make Your Apple Watch App Development Successful
Tech & Autos

Important Tips to Make Your Apple Watch App Development Successful

July 1, 2022
Polycarbonate
Tech & Autos

How Is Polycarbonate Made?

June 30, 2022
How To Fix Access Panels With Minimal Tools
Tech & Autos

How To Fix Access Panels With Minimal Tools

June 30, 2022
What You Need to Do Before Launching Your Cryptocurrency Exchange
Tech & Autos

What You Need to Do Before Launching Your Cryptocurrency Exchange

June 30, 2022

© 2022 Thenewsgod. All Rights Reserved.

  • About
  • Contact Us
  • Terms of Use & Privacy Policy
  • Advertise
  • Disclaimer

Removed from reading list

Undo
Welcome Back!

Sign in to your account

Lost your password?