SEC | S20W5 | Google Sheets (Creating Sheets & Form Part 2)

in #spreadsheet-s20w518 hours ago

Assalam-o-Alaikum!!!

Greetings to my all STEEMIT members. Hopefully you are fine and doing very well done on STEEMIT. I am also fine ALHAMDULILLAH. And today I am also fine ALHAMDULILLAH

image.png
Made in poster my wall

Today I am going to share an engagement contest. And I will try my best to work properly.

So Lets Started!!!

Still on the Google Sheets created in our previous class, which we titled SEC-S20W4, add another sheet (page) call summary and let the summary have Author & Author Count, Country & Country Count, Club & Club Count, and lastly, Tags & Tags Count. Also, add a column in the Steemian Details that carries Tags. Here you should insert the main hash tag of the link you have copied. Your tags can be kept below in your sheet on the same column and row as seen in the example above.

First if all We will add an other sheet and then I, that we prepared previous week. And will rename that I will will give SUMMARY. Now I will add columns and I will add Author & Author Account, Country & Country Account, Club & Club Account, Tags & tags Account

image.pngimage.png
  • Author Count:

Now we will apply the formula to calculate the AUTHOR COUNT. And by using Formula we can calculate tha Author count column very easily

image.png

Now by dragging we can calculate the complete result of this column

image.pngimage.png
  • Country Count:. Now again we will use the formula to calculate the Country Count

image.png

  • CLUB COUNT: Like Previous method, we will definitely find the CLUB Count by using the fomula

image.png

Tag Count: Like all Formulaes, we will again use formula to calculate the Tag Count

image.png

Using the previous knowledge from our previous class please create a Google form with the title My Steemit Resume. In this form, we want you to tell us about your journey on Steemit using all the question types such as (Multiple choice, Short answer, Paragraph, Checkbox, Dropdown, Date, Time, File upload, etc). This means that your form should carry the registration date, your gender, amount of SP, communities you are working with, country of residence, Followers, Following, etc. Just use the form to create a resume for yourself based on the Steemit platform.

No we will create a GOOGLE FORM. As previous time, we will simply go to the GOOGLE and then we will click on the right side. Where we click and then we will Open SHEET option. Where we will firstly select the sheet that is we prepared in the previous week. Or if we have not, then we will create new blank sheet

GOOGLE FORM

image.png

  • TITLE: Now we will choose our title. We will give it according to our own choice. that is why here we will follow the title according to the guidelines if the contest

image.png

SHORT QUESTION: first of all in this form, I would like to ask the short answer. And user have to give very short answer according to the question

image.png

MCQ

image.png

  • Paragraph: Now I will add the paragraph question to make it little changes

image.png

Check box

image.png

  • Drop Down: Now we will add the other option that is Drop Down to make it more attractive

image.png

  • Upload File: you can also upload file that you want to upload

image.png

Required Option Sart

image.png

  • THEME: Now we will make changes according to our theme. And I think it will look beautiful If we will add image on the top. And if we change color to make ot more attractive. And we can also change the font style and size

image.png

image.png

So Finally the Task is completed . And I want to give access to those users who are mentioned in This engagment Post

Special thanks to @simonnwigwe , @josepha

Invite friends: @abdullahw2 , @khursheedanwar , @alee75

Regards:@arinaz08

Sort:  

Thank you so much @ruthjoe for your appreciation and support

Coin Marketplace

STEEM 0.18
TRX 0.16
JST 0.029
BTC 62555.95
ETH 2435.55
USDT 1.00
SBD 2.64