"SEC | S20W4 | Google Sheets features and functionality (Creating Forms & Sheets)

arinaz08 (71)in #spreadsheet-s20w4 • 3 months ago (edited)

Assalam-o-Alaikum!!!

_{Made in poster my wall}

Greetings to my all STEEMIT members . hopefully you all are great and enjoying your best life on STEEMIT. So today After hard work, I ma going to take part in this engagement contest. I found this task little bit difficult. Because I never do it before this task. So I tried my best to sort out all questions

Explain your understanding of Google Sheets and then describe in detail the various features of a Google Sheets, a pictorial representation of these features is necessary so ensure you have clear screenshots.

Google Sheets is a cloud-based spreadsheet application offered by Google as part of the Google Workspace suite that allows users to create and edit spreadsheets in-line with real-time spreadsheet features. and allows them to do so even though the data from the sheet is styled for personal educational and business purposes when the scholarship dies.

Key Features of Google Sheets

1.Cells, Rows, and Columns:

At its core, worksheets are a grid made up of cells arranged in rows and columns. Each cell can hold text, numbers, or formulas

2.Formulas and Functions:
Yes, Google supports a variety of mathematical functions such as count average sum and random operations. Users can enter custom inputs to perform complex calculations.

3.Real-time Collaboration:

Multiple users can simultaneously work on a document with Google Lion Changes are displayed in real-time and highlighted with color on each side More users can leave comments for others to review

4.Data Formatting:
Cells can be formatted with RingoTextiles number formatting such as dates and currency and conditional formatting that changes the appearance of cells based on their values.

5.Charts and Graphs:
Google Sheets has many chart types provided outside line pies etc. which can be created from selected data. They are automatically updated if the data changes

6.Data Filtering and Sorting:
Sheets allows filtering data to focus on specific key strings that meet a set of criteria. Sorting features allow users to sort data alphabetically.

7.Add-ons and Integrations:
Google Sheets supports third-party end-ones that add functionality such as data connectors to databases and advanced charting tools It integrates well with other Google services such as Google Drive, Google Forms, Google Calendar

8.Data Validation:

Apps help ensure data accuracy and consistency by using data validation rules to control what type of data can be entered into specific cells.

Create a simple Google form with the title Google Sheets 101 and use all the question types such as (Multiple choice, Short answer, Paragraph, Checkbox, Dropdown, etc) format to create your desired questions in the form. Customize all questions to be required and add a banner at the heading of your form. Clear screenshots are needed for this task.

First of all, we will go to Google, it is simple, open Google and we will click on the point where there are some points on the right corner, then below we will find many options, out of which we have entered the form in one of the options. Click and after clicking there we will see that a screen will appear where we will click on Blank Home and open it and we will rename it and rename it. Will do the custom one that we were told is in the contest, I've used the one renamed which is Google sheet 101.

Now I have added the image inside it actually I have not done this before so I don't understand the layout so I will try my best to make it work well I have added the image And first of all, it is written in the walking passage so that whenever you fill this nation, enter your username first.

And now we will add our custom question in which we will have different options, we can also do multiple questions and in the options we can also apply from the check box, in addition to this, we can enter the short enter. We can also do this is our own choice so I have tried to solve all so that when an open section is cleared within it, it also picks the next one and then goes to the next section.

After that we will have an option which we have to click on the required option if the user has any question which he will not fill then he will not be able to go to the reception. has an option and it means that this question is mandatory and you cannot go to your section without answering this question.

Now we have to customize it and for that we will see an option where it will say theme as I have shown in the screenshot we will click on it so it will do the formatting for us. There will be a lot of options in which we can change the language of our leaked data and quotes to Goldry Telly or whatever formatting we want, change the font size and so on. Apart from this, we can put the image as we want, the image I put earlier was not suitable for me, so I want to change it here, so it will be changed from this option, so I The image has been changed and

Now after filling it home I want to add screenshot with you guys in which I have failed this phone once and tested it whether it is running right form or not my perform. has been completed and I have completed it till the end which I want to show you my confirmation is also complete and I have also used it

COMPLETE FORM

AFTER SUBMIT

Create a Google sheet titled SEC-S20W4 with two pages, the first page will be called Steemian Details and it should include the date of post, community posted, country, club, author, and Post link and the next page should be called Database. Your database should have author, country, and club so that when a post link is dropped in the Steemian details it can fetch the details automatically. (Ensure that your database has at least 30 Steemians and the same goes with the post link). Clear screenshots are needed for this task.

GOOGLE SHEET

Just like we people made google phone, same way we people made google sheets and that's why we people will click option and then when open blank sheet when open. So we're going to rename it and we're going to make people with two sheets of data.

We are going to create two sheets, one of which is named as Stamens Details and the other one is named as Database and now we will add their data in both of them, in which we have Steemians name and database name. We are going to create some columns in which we will write username, create a column for country and create a column for post links and similarly we will create a column for other country and club in the database sheet

|

---|----

Data for SHEET STEEMIANS

DATA FOR SHEET DATABASE

Formula Apply

And now we have to apply the formula on it to search the data and for that we have entered the formula to fetch the data in row two in the Athar column and after entering that formula We can see that whenever we click on it, its username is showing which is fetching data automatically.

Formula for COUNTRY and CLUB:

VLOOK UP FORMULA TO FETH THE DATA OF POST LINK TO THE SHEET DATA BASE

Using atleast pie chart & bar chart, show us the relationship between author and country as contained in the above question.

And now our task is that we have to add relationship between the author and the country data to each other and for that we have used pivot table I have selected the table of country and author which first I have added these The data has been shown in the Pivot table and after that I have applied this.

Now I will apply Bar Chart by going to Insert tab. and then I will click on the Bar Chart option. After that the bar chart will be shown on to the screen.