Thursday, 9 September 2021

How Google Spreadsheet is different from Excel


Google Spreadsheet & Its Features 

q  Google Sheets is an online spreadsheet app that lets you create and format spreadsheets and work with other people.

q Google Sheets allows users to edit, organize, and analyze different types of information. It allows collaborations, and multiple users can edit and format files in real-time, and any changes made to the spreadsheet can be tracked by a revision history.

Excel vs Spreadsheet


q  Google sheets and excel are very much same in the terms of formulas and calculations and many of their features of them are same.

q  Both have data in the form of a table or in other words rows and columns.

q  The major difference between excel and google sheets is that google sheets provide us with us link which can be shared with other users to give them permission to read or edit the sheet at once while in excel only one person can edit the file at a time.

Creating Google Spread Sheet

ü  You must have a Gmail account to create a Google sheet.

ü  You need to Login to your active Gmail Account.

ü  Go to Google drive as shown in Image.

ü  Click on New.

ü  Then Click on Google Sheets.

ü  You will get a new spreadsheet on screen.

Adding Title to Google Spread Sheet

ü  You can Change the Name of your sheet here.

ü  The changes you will make will be saved automatically in your Drive. 

Sharing Google Spread Sheet

ü  You can share your sheet with your Colleagues, Seniors Through Email ids or through Link too.

ü  To Share your Sheet you need to click on Share button as shown in Image below.

ü  You will get this box when you click Share button.

ü  You can add Email ID here to share sheet.

Adding E-Mail ID

ü  You can add Email Id here & you can click on Notify People to send a notification to  His/her Email Id.

ü  Then you can select the choice of editing- whether he/she can only view this sheet or can Comment or can Edit if necessary.

ü  Then click on Send.


ü  You can also edit choice after adding E mail ID.

ü  Also you can copy link to share on various Social Platform.


Send E-Mail ID when you Comment

Google Sheets is great for collaborating with others –You can actually send an email to let them know when you’re adding a comment to Google Sheets.

Just add a plus sign (+) and then type their email address (or name) and then when you add your comment they’ll receive an email with your message automatically.

ü  Just add a Comment by right clicking mouse or use shortcut key Ctrl+Alt+M.

ü  You will get a new dialog box.

ü  You can add Email to notify the person to make Changes. It will directly send an Email to the person.

ü  Just put @ before adding Email, Click on assign & add Comment.

ü  You can Select Comment or Edit Option as per your requirement.

ü  Click Comment to add settings.

Protect Data in Cells

ü  If lots of people are working on a sheet, then you might want to lock down some of the data to prevent mistakes. You can lock sheets and even individual cells so that data isn’t accidentally changed.

ü  If you don’t want completely lock down cells, you also have the option to show a warning before they’re edited.

ü  Select row or Column or certain range you want to restrict.

ü  Right click on mouse.

ü  Then click on Protect Sheet as shown in Image.

ü  You will see a new dialog box will open at right side of the sheet.

ü  You can enter Description & set Permission as per your requirement.

ü  You can now set Warning before editing this range or you can also restrict editing in this range.

Sparkline Function

When you’re working with large amounts of data in a Google Sheets spreadsheet, it isn’t always convenient to drop a chart into the mix. To help you, you can create one-cell charts using the SPARKLINE function instead.

A sparkline chart is a very small line chart that allows you to quickly visualize your data. It’s useful if you want to quickly see if share price data in a spreadsheet was going up or down, for instance.

The SPARKLINE function in Google Sheets allows you to insert these types of charts into a single cell on your spreadsheet. While a sparkline is typically a line chart, the SPARKLINE function enables you to create alternatives, including single-cell bar and column charts.

Enter your Formula to blank cell

After you press enter you will get a chart

ü  You can change chart type also.

ü  You need to add chart type as column, bar etc  according to your preference.

ü  Here we have used column chart type.

If want more updates Follow my Page.

Wednesday, 8 September 2021

Communicate with us in English Part 4

                               NEW SENTENCE PART 4

Man sitting on window and working on laptop, freelance, quarantine, flat  illustration, eps. | Premium Vector

1.        शांत रहिये।
Be quiet.

2.    तुम्हारे पिताजी क्या काम करते हैं ?

What does your Father do?

3.    राम आज कल क्या कर रहा है ?
What is Ram doing these days?

4.    समझदार को इशारा ही काफी होता है 
A word to wise is enough.

5.    मैं एक इंजीनियर हूँ।
I am an engineer.

6.    वह एक लड़का है।
That is a boy.

7.    क्या तुमने कोशिश की ?
Did you try?

8.    तुमने अपने भविष्य के लिए क्या सोचा है ?
What have you planned for your career?

9.    इसमें खास बात क्या है ?
What’s so special in it? /
What’s so remarkable in it?

10. आपकी कृपा होगी 
It’s kind of you.

11. यह फर्नीचर पुराना है।
This Furniture is old.

12. हिमेश मेरा मित्र है।
Himesh is my friend.

13. डाँस किसने किया ?
Who danced?

14. बैंगलोर  कौन जाएगा ?
Who will go to Bangalore?

15. चार दिन की चाँदनी फिर अँधेरी रात 
It’s a nine days wonder.

16. आप तो बिल्कुल भोले हो।
You are so innocent.

17. आपको किससे मिलना है ?
Who do you want to meet?

18. मुझसे कौन मिलना चाहता है ?
Who wants to meet me?

19. वह बड़ा पत्थर दिल है 
He is a hard hearted person.

20. मामला बिगड़ गया है 
The matter has become serious.

21. वह मेरे पिता जी है।
He is my Father.

22. ये मेरी किताबें हैं।
These are my books.

23. तुम दफ्तर कैसे जाते हो ?
How do you go to office?

24. अब आपकी तबीयत कैसी है ?
How are you now?

25. यह काम करना कोई बच्चों का खेल नहीं है 
Doing this work is not a child’s play.

26. क्या ये है तुम्हारे बात करने का तरीका?
Is this the way you talk?

27. यह मेरी लैपटॉप  है।
This is my Laptop.

28. तुम एक लड़की हो।
You are a girl.

29. मनाली में मौसम कैसा है?
How is the weather in Manali?

30. तुम्हारे भाई की आयु कितनी है?
How old is your Brother?

31. मैंने यह बात नहीं कही 
I didn’t make this remark.

32. कोई भी ऐसा अपमान सहन नहीं कर सकता 
Nobody can bear such an insult.

33. वह सुन्दर लड़की थी।
She was a beautiful girl.

34. वह सोया हुआ था।
He was asleep.

35. करीब 150 किलोमीटर।
About 150 kilometers.

36. तुम्हें वहाँ पहुँचने में कितना वक्त लगेगा ?
How long will you take to reach there?

37. मैं आपसे बहुत खुश हूँ 
I am very happy with you.

38. मुझे तुम पर गर्व है 
I am proud of you.

39. अनीता  एक अच्छी लड़की थी।
Anita was a good girl.

40. मुझे दिल्ली जाना है।
I have to go to Delhi.

If you Like please follow the page & don't forget to Comment below.👇👇