google sheets or google spreadsheets is one of Google's applications that are included as part of the free google docs of its Google Drive service. It is somewhat similar to excel and is used to create tables of your data and allows you to organize, edit and store your information in the form of a table.
Features of the google sheets application that make it better than others
- Works on any phone and all operating systems.
- of free apps.
- It is based on the Internet and therefore can be used anywhere and anytime.
- Featuring all known spreadsheet functions.
- It is easy to use and somewhat similar to Excel, so if you know how to use Excel, you will use google sheets easily.
- It also allows you to download and create your own plugins and write custom codes as well.
- You can also collect and edit data using the spreadsheet and save files, even when you're not connected to the Internet.
- You can convert a file to a spreadsheet file from Google.
Common google sheets terms
Before you start using google sheets, there are some terms that you should know first to help you and be able to use the program with ease, including:
- Cell: The main component of a spreadsheet.
- Column: A group of columnar cells.
- Row: A group of horizontal cells grouped together to form a row.
- Range: It helps to select several cells together, whether it is a row or column, or both.
- Function: are some operations that are written in the cell to calculate the value of a cell, row, or column, manipulate data, and others.
- Formula: A set of functions, cells, rows, and columns that are used to obtain a given result.
- Worksheet: The rows and columns that make up your spreadsheet. One spreadsheet can contain many worksheets.
- Spreadsheet: The entire document that includes all of your worksheets.
The menu bar.
Toolbar and Formats.
Formulas and functions bar.
How to download google sheets on phones
To download google sheets on Android phones :
You can download the program through Google Play, after that click on Install the program. This will install the application on your phone, and then you can open the application and work on it.
To download the program on iPhone and iPad :
You can upload and download the app through the App Store, then tap Install.
How to create a spreadsheet and write data in it
Google Sheets works on any smartphone or computer and works on all operating systems. All you need is a web browser or Google Sheets app on your iOS or Android device, as well as a free Google account. On a Mac or PC, head over to this link and you're good to go.
There are 3 ways to create a new spreadsheet in Google Sheets:
- By pressing the red “New” button in the Google Drive control panel, then select Google sheets.
- You can open the list from within a spreadsheet, then select a file, and then choose a new spreadsheet.
- Or by pressing "Blank" or selecting a form on the main Google Sheets page.
- With these steps, you can create a new blank spreadsheet or a pre-filled form if you choose one.
After that, you can choose any cell in the worksheet and write anything you want. When you're done entering data into the cell, you can do one of four things:
- To save the data and move to the beginning of the next row, press Enter.
- To save the data and move to the right in the same row, press Tab.
- You can also use the arrow keys on the keyboard to move up, down, left, and right, and to move a single cell.
- Click on any cell to move to that cell.
If you don't want to type the data manually, there are several different ways to add data to the spreadsheet at once:
- Copy and paste from a list of text or numbers into a spreadsheet.
- Copy and paste an HTML table from a Web site.
- Import an existing spreadsheet in CSV, Xls, and xlsx format.
- Copy any value in a cell across a range of cells by clicking and dragging.
You can visit this site to learn more about Google Sheets.
Comments
Post a Comment