GOOGLE SHEETS
What is google sheet?
Google sheet is a product of google as same as like Microsoft Excel but it is more advance than the Excel.
Features :
1. Anyone can work from his home.
2. More than 1 users can enter data in the google sheets at the same time by sharing the link of the sheet by email.
3. We can use more than 100 functions to automate the sheet.
STEPS OF CREATING GOOGLE SHEET:
1. Login to your google account
2. Select SHEET from google apps as in the following image.
3. To create new google sheet click on + with Blank option as follows
4. With this you will see a blank spreadsheet as follows
5. At the top left corner you can change the name of Spreadsheet . Look in the image below.
6. You can format the cells by selecting them by changing the FONT , FONT-SIZE, COLOR OF TEXT and COLOR OF BACKGROUND .
If you want to look on the functions available in the google sheet then go the INSERT tab in the MENU bar and then tab on function where you will see all the unctions which are more than 100 functions.
By using the SHARE option in the right corner you share your spreadsheet to others.
A fascinating feature is that you can allow anyone to edit this spreadsheet by sending them this spreadsheet on email with Editor option as given the image below.
You can share the spreadsheet to others to only view the spreadsheet using VIEWER option.
OR even you can share the link of the spreadsheet to anyone by whatsapp or other social-media sites.
Also in the spreadsheet you can add the HYPERLINK in the cell to attach any website or any other sheet , so that anyone can access both the sheets or can refer the Website.
1. Tap on the cell where you want to give the link
2. Write =HYPERLINK("URL","VIEWING NAME")
As you type second line in the cell from above you will get auto suggestion and give the URL of another sheet or Website and give the name of WEBSITE.
In this way you can create google sheet.
0 Comments