19 Google Spreadsheets Parts and Functions You Need to Know

Google Sheets Parts and Functions
Google sheets or spreadsheets are an internet application using your internet browser. This is one of Google's free offers when you create your Google account like Gmail. This is an interactive computer application used for any organization, office or group of persons. That they need to analyze certain aspects of data using the tabular table. And is also an accounting mechanism and storage of data using the free storage offer from Google

This application is like Microsoft Office Excel, it's also a worksheet application, but it's offline because it's locally installed on your computer. This application also has a license which you can't fully use this application without the payment for a Microsoft subscription. Now without the presence of Microsoft office, you can use this Google spreadsheet application as the best alternatives.

To make you familiarize and knowledgeable in this application this is a big help to you to learn more.


  1. TITLE BAR- This is the part where you can identify the filename of your spreadsheets and its position above the user interface of this application.
  2. MAIN MENU- It's the main tool that you can use for your application. They are FILE, EDIT, VIEW, VIEW, INSERT, FORMAT, DATA, TOOLS, ADD-ONS, and HELP.
  3. RIBBON MENU- Its other tool use for this application, its design as an icon or small pictures inline with its other in a bar. That you can easily select and click after you highlight any data within your spreadsheets or worksheets area.
  4. COMMENT BUTTON- It's a unique built-in feature of this application where you can put a comment inside the worksheets. Whenever you click this button you have two selections either notifications or a comment. When having a group discussion you can easily put a comment or notification to your groupmate.
  5. SHARE BUTTON- You can use this if you wanted to send your sheets to your friends or to your workmates or either to your big boss. You need the email address of the persons who will receive the worksheets of data.
  6. GOOGLE PROFILE ACCOUNT BUTTON- This is a button for your profile account. whenever you want to exchange to other Google products or logout into Google you can click this button. 
  7. FORMULA BAR or EDITOR BAR- This bar that has an Fx symbol at the left is called the formula bar. You can use this to compose any logical formula for any calculation. Like for example A1 + B1, this is a simple formula that will add the data in column A row 1 and column B row 1. This is called the editor bar whenever you use this bar to edit or change the data inside the table. 
  8. AUTO ADD SHEET BUTTON- It's a plus symbol button that when you click it will create another tab sheet position on the right side.
  9. PAGE OR SHEETS SELECTOR- This is a button once you click all the sheets that you have in your application will list goes up. So that you can select and click a page or sheets you want to display. 
  10. WORKSHEETS OR SHEETS TAB- This a tab button when you click it will display a worksheet. But when you click the arrow down beside it, it will display a list of commands. For example, if you want to delete a spreadsheet, you can click this button and click delete. 
  11. HORIZONTAL SCROLL BAR- You can use this button if you want to scroll or move your worksheet going left or right.
  12. EXPLORE OR HELP BUTTON- You can click this button if you want help outright in your worksheets or get insights instantly. All you need is to highlight data within the worksheets.
  13. VERTICAL SCROLL BAR- Use this tool when you need to scroll or move your worksheet up or down.
  14. WIDGETS SIDEBAR- This is the position of a tool on the right-side panel. This time this is only three applications: calendar- that you can check the date, keep- that you can keep or take notes or get any data from your synchronize data from a mobile phone and task- that you can add your workflow and you can open using the single click and help you remember easily your work.
  15. ACTIVE CELL OR WORKSHEET CELL- This is a rectangle look,  it's a very important, its task to create the execution. Whenever there are changes you want to make on a date it will happen inside this tool. If you create a formula and execute it for a certain calculation this tool will work for you. This tool is the intersection between the column and the row to identify the exact range of data to execute.
  16. AUTOFILL TAB- It's a part of the Active Cell, but it has a separate task. If you want to auto calculate a range of data within a column or a row you need these tools. All you need is to create or form a formula on the first column of a row of data. Then point to this tab and hold down your left mouse button and drag it down. Use this tool if you want to fill a date within the column and the row or auto-fill a series of numbers. 
  17. COLUMN HEADERS- It's a range of Alphabets or letters that represent the number of columns, every set of data needs a column.
  18. ROW HEADERS- It's a range of numbers that represents the number of rows within a column, every set of data needs to identify the specific location with the column or intersection. So that a user can calculate correctly.
  19. WORKSHEETS AREA- The biggest part of the user interface of this application, its composition of vertical and horizontal grid lines represents the intersection of columns and rows.

So much here, this is the first step if you want to learn how to use this application. The next topic is all about the most basic formula that uses for spreadsheets same as the Microsoft Office Excel application.


19 Google Spreadsheets Parts and Functions You Need to Know combinebasic 5 of 5
Google sheets or spreadsheets are an internet application using your internet browser. This is one of Google's free offers when you...
Share on linkedin

About combinebasic

I'm a husband, a blogger and Biomedical Machines Specialist, also a computer instructor and technician and a crazy writer, I like to write and build blogs and avid fan of social media. I have built this blog just to help others through information. Follow us on Facebook and Twitter.

    Blogger Comment
    Facebook Comment


Post a Comment

Note: We have Zero Tolerance to Spam. Avoid Promotions with 'Links' considered as spam will be deleted immediately upon our review.