Google Mafomu Ndi chida chothandiza kwambiri kusonkhanitsa zidziwitso moyenera komanso mwadongosolo. Komabe, nthawi zina timafunikira onjezani spreadsheet ku fomu yathu kutsata tsatanetsatane ya zambiri zomwe zasonkhanitsidwa. Mwamwayi, Google Forms imapereka mwayi wochita izi mosavuta komanso popanda zovuta. M'nkhani ino, tikuwonetsani pang'onopang'ono momwe mungawonjezere a spreadsheet ku fomu Mafomu a Google, kotero mutha kugwiritsa ntchito bwino izi mwaukadaulo.
- Momwe mungagwiritsire ntchito Mafomu a Google kupanga mafomu okhala ndi maspredishiti
Mafomu a Google ndi chida chothandiza kwambiri kupanga mafomu achizolowezi ndi kusonkhanitsa deta kuchokera njira yothandiza. Chimodzi mwazinthu zodziwika bwino za Google Mafomu ndi kuthekera kuwonjezera a spreadsheet zomwe zimasinthidwa zokha ndi mayankho amtundu. Izi zimathandizira kusanthula ndi kukonza zomwe zasonkhanitsidwa.
Kuti mugwiritse ntchito izi, muyenera choyamba crear un formulario pa Google Mafomu. Kenako, muyenera kulowa menyu kasinthidwe ka mawonekedwe podina chizindikiro cha madontho atatu pakona yakumanja yakumanja ndikusankha "Mayankho". Kenako, dinani pa "Spreadsheets" ndikusankha "Pangani tsamba latsopano". Izi zipanga spreadsheet yolumikizidwa ndi fomu, pomwe mayankho onse omwe alandilidwa adzalembedwa.
Mukapanga spreadsheet yolumikizidwa ndi fomuyo, mukhoza kusintha mizati ndi mizere mwamakonda kupanga zidziwitso malinga ndi zosowa zanu. Mutha kuwonjezera mitu, masanjidwe okhazikika, ndi mafomu kuti musanthule ndikuwona deta moyenera. Kuphatikiza apo, mayankho aliwonse atsopano omwe alandilidwa adzangowonjezedwa pa spreadsheet, ndikukupulumutsirani nthawi komanso kupewa zolakwika zokopera pamanja.
- Kuphatikiza kwa Google Mapepala mu Mafomu a Google: Pang'onopang'ono
Google Forms ndi chida chothandiza kwambiri popanga kafukufuku ndi kusonkhanitsa deta mwachangu komanso mosavuta. Komabe, nthawi zina kungakhale kofunikira kukonza bwino zomwe mwapeza ndikusanthula mwatsatanetsatane. Apa ndi pamene kuphatikiza kwa Mapepala a Google mu Google Forms zimakhala zofunikira. M'munsimu, tikufotokozera sitepe ndi sitepe momwe mungawonjezere spreadsheet ku fomu. mu Google Forms.
Gawo 1: Choyambirira chomwe muyenera kuchita ndikupanga fomu mu Google Forms. Mukhoza kuwonjezera mafunso ndi mayankho omwe mukufuna pa kafukufuku wanu. Mukamaliza kupanga fomu, dinani "Mayankho" pamwamba pa tsambalo.
Gawo 2: Mu tabu ya "Mayankho", muwona zosankha zingapo. Dinani pa "Pangani spreadsheet" kuti kupanga Google Sheetsspreadsheet yolumikizidwa ndi fomu yanu.
Gawo 3: Mukapanga spreadsheet, mayankho onse omwe atumizidwa kudzera mu fomuyo adzajambulidwa mmenemo. Izi zikuthandizani kuti mukonzekere ndikusanthula deta moyenera. Mutha kugwiritsa ntchito Google Sheets kuwerengera, kupanga ma chart, ndi kupanga malipoti okhazikika malinga ndi zomwe zasonkhanitsidwa.
Mwachidule, kuphatikiza kwa Google Sheets mu Google Forms ndi chinthu chothandiza kwambiri pakukonza ndi kusanthula deta yomwe yasonkhanitsidwa kudzera m'mafomu. Tsatirani njira zomwe tazitchula pamwambapa ndipo mutha kuwonjezera spreadsheet ku fomu yanu mosavuta. Gwiritsani ntchito bwino zida izi ndikupeza chidziwitso chofunikira kuchokera muzofufuza zanu ndi mafunso!
- Ubwino wowonjezera spreadsheet pa fomu ya Google Forms
Una de las ventajas clave kuwonjezera spreadsheet ku fomu mu Google Forms chinthucho ndi amakulolani kuti mutolere ndikukonzekera zambiri. Wogwiritsa ntchito akamaliza fomuyo, zomwe zalowetsedwa zimasungidwa mwachindunji mu spreadsheet yolumikizidwa, kupangitsa kukhala kosavuta kutsatira ndi kusanthula zomwe zasonkhanitsidwa. Kuphatikiza apo, kuphatikiza uku kumapereka kuthekera kwa kuwerengera ndi kusanthula deta bwino kwambiri, popeza deta imasungidwa mumtundu wa tabular ndipo mafomu ndi ntchito zingagwiritsidwe ntchito kuchotsa zidziwitso zenizeni.
Zina mwayi wofunikira ndikuti pokhala ndi chidziwitso mu spreadsheet, mutha pangani ma chart ndi zowonera zomwe zimathandiza kumvetsetsa bwino zomwe zasonkhanitsidwa. Izi ndizofunikira makamaka mukafuna kupereka zotsatira ku gulu kapena kupanga malipoti owoneka. Ma chart amatha kuwunikira zomwe zikuchitika, kufananitsa, ndi mawonekedwe omwe mwina sangadziwike Kuonjezera apo, spreadsheet imalolanso sefa ndi kusanja deta malinga ndi ndondomeko yeniyeni, yomwe imathandizira kusanthula ndi kuchotsa zidziwitso zoyenera.
Pomaliza, onjezani spreadsheet ku fomu ya Google Forms amapereka mwayi wochita nawo mpikisano pompopompo. Ogwiritsa ntchito angapo amatha kugwiritsa ntchito spreadsheet nthawi imodzi ndikusintha kapena kuwonjezera. Kugwirizana kwanthawi yeniyeni kumathetsa kufunika kotumiza ndikusunga zosinthidwa zosinthidwa za spreadsheet, kusunga nthawi ndikupewa zolakwika.
- Kukhazikitsa ndikusintha tsamba lolumikizidwa mu Google Fomu
Kukhazikitsa ndikusintha spreadsheet yolumikizidwa mu Google Forms ndi chinthu chothandiza chomwe chimakulolani kukonza ndikusanthula zomwe zasonkhanitsidwa kudzera m'mafomu. Ndi chida ichi, ndizotheka kuwonjezera spreadsheet ku mawonekedwe omwe alipo kale kapena kupanga yatsopano ndi spreadsheet yolumikizidwa kale. Kuphatikizikaku kumathandizira kusonkhanitsa ndi kusanthula deta pa intaneti.
Kuti mukhazikitse spreadsheet yolumikizidwa, muyenera choyamba kutsegula fomuyo mu Google Forms ndikuyenda kupita ku tabu ya "Mayankho". Kuchokera pamenepo, sankhani chizindikiro cha spreadsheet pakona yakumanja yakumanja ndikudina "Pangani spreadsheet yatsopano." Spreadsheet idzapangidwa yokha ndikulumikizidwa ku fomuyo. Mukhoza kusintha spreadsheet mwa kusintha mizati ndi mizere malinga ndi zosowa zanu..
Mukakhazikitsa ndikusintha spreadsheet yolumikizidwa ndi fomu yanu mu Google Forms, mutha kuyipeza ndikuigwiritsa ntchito kusanthula zomwe mwasonkhanitsa. Spreadsheet imapereka chithunzithunzi chomveka bwino komanso chatsatanetsatane cha mayankho omwe apezedwaMutha kugwiritsa ntchito ntchito zosiyanasiyana za Google Sheets ndi mafomula kuti muwerenge maavareji, kupanga ma grafu ndi ma chart, ndikusefa ndikusankha deta yanu. Kuphatikiza apo, mutha kugawana spreadsheet ndi ena ogwira nawo ntchito kuti mugwire ntchito limodzi pakuwunika zomwe zapezedwa kudzera mufomu.
- Momwe mungalumikizire ndi kulunzanitsa mayankho a fomu ku spreadsheet mu Google Sheets
Chimodzi mwazinthu zothandiza kwambiri za Google Forms ndikutha kulumikiza ndi kulunzanitsa mayankho amafomu ku spreadsheet. mu Google Sheets.Ntchitoyi ndi yofunika kwambiri kwa iwo amene akufuna kukonza ndikusanthula deta yomwe yasonkhanitsidwa m'njira yabwino kwambiri. Kuti muyambe, chochita choyamba ndicho kupanga mawonekedwe onse mu Google Forms ndi spreadsheet mu Google Sheets. Mukapanga fomu, muyenera kupeza njira ya "Mayankho" ndikusankha "Pangani spreadsheet". Izi zidzangolumikiza fomu ku spreadsheet ndipo mayankho onse otsatira adzasungidwa ku spreadsheet.
Fomu ndi spreadsheet zikalumikizidwa, mutha kusintha ma spreadsheet kuti agwirizane ndi zosowa zanu. Mutha kutchanso ma sipuredishiti ndikusintha magawo a data m'njira yopangitsa kuti ikhale yosavuta kuwerenga ndi kusanthula. Kuphatikiza apo, ngati mukufuna kuchotsakapena kuwonjezera zigawo zina pa spreadsheet, izi zitha kuchitikanso mosavuta osakhudza zomwe zasonkhanitsidwa.
Ubwino winanso wolumikiza mayankho a fomu ku spreadsheet mu Google Sheets ndikutha kugwiritsa ntchito mafomu ndi ntchito kuti mufufuze mwachangu zomwe zasonkhanitsidwa. Mutha kugwiritsa ntchito mafomuwa kuti muwerenge ziwerengero, ma avareji, kuwerengera zikhalidwe zenizeni, pakati pa ena. Mutha kugwiritsanso ntchito ma chart a Google Sheets kuti mupange zithunzi zomveka bwino za data yanu. Izi zimakupatsani kusinthasintha kwakukulu kuti mumasulire ndikuwonetsa zotsatira za fomu yanu m'njira yothandiza kwambiri. Ndi kuphatikiza uku pakati pa Mafomu a Google ndi Mapepala a Google, kusanthula deta kumakhala kothandiza kwambiri ndipo mayendedwe onse amawongoleredwa.
- Kugwiritsa ntchito mafomu ndi ntchito mu spreadsheet yolumikizidwamu Google Mafomu
Kugwiritsa ntchito mafomu ndi ntchito mu spreadsheet yolumikizidwa mu Google Forms
Kutha kugwiritsa ntchito mafomu ndi ntchito mu spreadsheet yolumikizidwa mu Google Forms ndi chinthu champhamvu chomwe chimalola kuwerengera mokhazikika ndi kusanthula deta munthawi yeniyeni kuonjezera luso ndi kulondola pokonza zomwe zasonkhanitsidwa kudzera mu fomu.
Imodzi mwa njira zothandiza kwambiri ndi =SUMA(), zomwe zimakupatsani mwayi wowonjezera ma cell amtundu winawake. Mwachitsanzo, ngati muli ndi spreadsheet yokhala ndi gawo lomwe limalemba malonda atsiku ndi tsiku a chinthu, mutha kugwiritsa ntchito fomulayi kuti muwerengere kuchuluka kwa malonda mu nthawi yoperekedwa. Mwachidule kusankha gulu la maselo yomwe ili ndi zofunikira ndikugwiritsa ntchito ntchitoyi =SUMA() kutsatiridwa ndi mndandanda wosankhidwa.
Kuphatikiza apo, Google Forms imaperekanso zinthu zina zodziwika bwino monga = AVERAGE(), yomwe imawerengera pafupifupi ma cell osiyanasiyanandi =COUNT(), yomwe imawerengera kuchuluka kwa maselo okhala ndi milingo mkati mwa mulingo. Zochita izi ndizothandiza makamaka posanthula ziwerengero ndikupeza mfundo zothandiza pakupanga zisankho. Kupatula pazoyambira, Google Forms imathandiziranso zida zapamwamba, monga =VLOOKUP(), yomwe imafufuza mtengo wake patebulo ndikubweretsanso zotsatira zofananira, kapena =IF(), zomwe zimalola—kupanga zinthu zomveka kuchita zinthu zosiyanasiyana kutengera zotsatira zomwe zapezedwa.
Mwachidule, kugwiritsa ntchito mafomu ndi ntchito mu spreadsheet yolumikizidwa mu Google Forms kumapereka a njira yothandiza ndi automated processing ndi santhulani deta mu nthawi yeniyeni ntchito izi zimalola masamu, ziwerengero ndi kusintha malemba, kupereka mfundo zofunika popanga zisankho. Kuchokera pakuwonjezera ma values mpaka kufunafuna zotsatira patebulo, mwayi ndiwosatha. Gwiritsani ntchito izi ndikusintha kusanthula kwa data mu Google Forms.
-Malangizo kulinganiza ndi kusamalira deta mu spreadsheet
Njira yothandiza yosonkhanitsira ndikusintha deta mu fomu kuchokera ku Google Forms Ndi powonjezera spreadsheet. Kuti muwonjezere spreadsheet ku fomu, tsatirani izi:
1. Tsegulani mawonekedwe mu Google Forms ndikudina "Mayankho" tabu.
2. Pamwamba kumanja, dinani chizindikiro cha spreadsheet kuti mupange spreadsheet yatsopano yolumikizidwa ndi fomuyo.
3. Tsambali litapangidwa, mutha kuligwiritsa ntchito kukonza ndi kukonza zomwe zasonkhanitsidwa pafomu yanu. Mutha kuwonjezera mitu yazagawo kuti mulembe mitundu yosiyanasiyana ya data, gwiritsani ntchito ma fomula kuti muwerengere, ndikugwiritsa ntchito zosefera kusanja ndikusefa zomwe mukufuna.
Kukhala ndi spreadsheet yolumikizidwa ndi fomu yanu kungakhale kothandiza makamaka mukamalandira mayankho ambiri. Mutha kugwiritsa ntchito zida za spreadsheet posanthula, monga ma graph ndi ma pivot tables, kuti muwonetsetse zomwe zasonkhanitsidwa momveka bwino komanso momveka bwino. Kuphatikiza apo, mutha kugawana ndikuthandizana nawo pa spreadsheet ndi ogwiritsa ntchito ena, kupangitsa kuti zikhale zosavuta kuyang'anira pamodzi zomwe zasonkhanitsidwa.
Mwachidule, kuwonjezera spreadsheet ku fomu mu Google Forms kumakupatsani mwayi wokonza ndikuwongolera zomwe zasonkhanitsidwa m'njira yothandiza komanso yowoneka bwino. Ndi luso lolemba ma tagi, kuwerengera, ndi kugwiritsa ntchito zosefera, mutha kudziwa zambiri kuchokera pamayankho anu ndikugwirizana ndi ena kuti mupindule ndi zomwe mwasonkhanitsa. Musazengereze kuyesa pa fomu yanu yotsatira!
-Kusanthula kwa data ndi kupanga kwa malipoti pogwiritsa ntchito Google Sheets ndi Google Fomu
Mapepala a Google ndi Mafomu a Google ndi zida ziwiri zamphamvu zomwe zimakulolani kusonkhanitsa deta ndikupanga malipoti moyenera komanso moyenera. Mu positi iyi, tifotokoza pang'onopang'ono momwe tingachitire.
Gawo 1: Tsegulani Mafomu a Google ndikupanga fomu yatsopano Mutha kuwonjezera mafunso amitundu yosiyanasiyana, monga zolemba, zosankha zingapo, kapena mabokosi, kutengera zosowa zanu. Mukawonjezera mafunso onse, dinani chizindikiro cha "Submit" pakona yakumanja kuti mupeze ulalo wa fomu.
Gawo 2: Tsegulani Mapepala a Google ndikupanga spreadsheet yatsopano. Apa ndipamene mayankho a fomu adzasungidwa. Mu menyu kapamwamba, dinani "Add-ins" ndiyeno kusankha "Mafomu." Kenako, sankhani "Pangani fomu yatsopano" ndikusankha fomu yomwe mudapanga m'mbuyomu.
Gawo 3: Mukalumikiza fomu ku spreadsheet, mayankho onse adzalembedwa mu spreadsheet m'magawo osiyana. Mutha kugwiritsa ntchito mayankhowa kusanthula deta kapena kupanga malipoti omwe mwamakonda pogwiritsa ntchito zida ndi zida za Google Sheets.
- Chitetezo ndi zinsinsi zomwe zasonkhanitsidwa mu Google Mafomu ndi Mapepala a Google
Chitetezo ndi zinsinsi za data yosonkhanitsidwa mu Google Forms ndi Google Sheets
M'zaka za digito zomwe tikukhalamo, kutetezedwa kwazinthu zaumwini ndi zinsinsi zakhala zofunika kwambiri. Mafomu a Google ndi Mapepala a Google Ndizida ziwiri zomwe zimagwiritsidwa ntchito kwambiri zomwe zimatilola kusonkhanitsa ndi kusunga zambiri bwino. Komabe, njira zowonjezera ziyenera kuchitidwa kuti zitsimikizire chitetezo cha deta yomwe yasonkhanitsidwa ndikusunga zinsinsi za otenga nawo mbali.
Imodzi mwa njira zothandiza kwambiri zopititsira patsogolo chitetezo cha deta yomwe yasonkhanitsidwa Mafomu a Google ndikuwonjezera spreadsheet ku fomu yathu. Izi zimatheka polumikiza fomu ku spreadsheet Mapepala a Google. Potero, deta yosonkhanitsidwa idzasungidwa mu spreadsheet, kulepheretsa kutheka kuti itayika kapena kupezedwa munjira yosaloleka. Kuphatikiza apo, kulumikizanaku kumakupatsani mwayi wolondolera mayankho mwatsatanetsatane, kusefa ndi kukonza data bwino kwambiri.
Ndikofunika kuganizira powonjezera spreadsheet ku fomu mu Mafomu a Google, tiyenera kukhazikitsa zilolezo zoyenera kuonetsetsa zachinsinsi Tikhoza kuchepetsa mwayi wopezeka pa spreadsheet kwa anthu okhawo omwe akufunika kuwona kapena kusintha zambiri, potero kupewa chiopsezo chilichonse chowululidwa. Kuphatikiza apo, titha kugwiritsa ntchito zinthu monga ma cell kapena chitetezo chamitundu yosiyanasiyana kuti tipewe kusinthidwa kosafunika kwa data yomwe yasonkhanitsidwa. Njira zowonjezerazi zithandiza kusunga zinsinsi ndi chinsinsi cha zomwe zasonkhanitsidwa, kupereka mtendere wamumtima kwa onse otenga nawo mbali ndi omwe amayang'anira kasamalidwe ka fomuyo.
Ndine Sebastián Vidal, mainjiniya apakompyuta omwe amakonda ukadaulo komanso DIY. Komanso, ine ndine mlengi wa tecnobits.com, komwe ndimagawana nawo maphunziro kuti ukadaulo ukhale wofikirika komanso womveka kwa aliyense.