Google Sheets- what is its equivalent to MS Excel tables?

[datatronics505]

Hi,
So I am currently involved just a bit with Google Sheets and one thing that, to me, seems to be missing is Excel's concept/functionality of tables. Sheets have named ranges and it does the work of naming objects but the rest of the table functionality that Excel tables have is missing. What is Sheets equivalent to Excel tables, if there any?
It's always nice to add a column to an existing table in Excel and watch as the new column immediately inherit the formatting of the rest of the table, as is adding a row that immediately inherits formatting and formula of every column it is a part of. Autofill a formula down the column without you needing to do autofill click yourself, etc... do Sheets even have equivalent to this?

 

[Bobby_Styles]

I am trying to learn how I can add a row to this sheet and have all the formulas auto populate. I have spent the last 2 days searching the internet and not found it or if I did it made no sense. please assist.

Link to my sheet