tikugwira ntchito ku Mapepala a Google Mutha kukumana ndi ma spreadsheet akulu pomwe muyenera kuthana ndi zolemba zambiri.
Timamvetsetsa kuvuta kothana ndi zobwereza komanso momwe zingakhalire zovuta ngati muwonetsa ndikuchotsa zolembedwazo.
Komabe, mothandizidwa Kupanga Makonda Chodetsa ndi kuchotsa Zobwerezedwa kumakhala kosavuta.
Pomwe mawonekedwe apangidwe amathandizira kusiyanitsa zowerengera mu Mapepala a Google.
Tsatirani ndondomekoyi pamene tikukuwuzani momwe mungapezere ndi kuchotsa zolembedwera mu Google Sheets.
Zomwe zimatengera ndikudina pang'ono kuti muchotse zobwereza mu Google Sheets ndipo tiziwadziwe.
Google Mapepala: Momwe mungapangire zowerengera pamndandanda umodzi
musanadziwe Momwe mungachotsere zolembedwera من masamba Google Tiyeni tiphunzire kusiyanitsa zowerengera mu gawo limodzi. Tsatirani izi.
- Tsegulani tsamba lamasamba mu Google Sheets ndikusankha danga.
- Mwachitsanzo, sankhani Mzere A. > Gwirizanitsani > Gwirizanitsani Wapolisi .
- Pansi pa Kupanga malamulo, tsegulani menyu yotsitsa ndikusankha Njira yoyenera ndiyo .
- Lowetsani mtengo wamtundu wachikhalidwe, = chiwerengero (A1: A, A1)> 1 .
- Pansi pa Malamulo a Fomati, mutha kupeza Masitayilo a Fomati, omwe amakulolani kuti mupereke utoto wosiyana pamitundu yomwe yawonetsedwa. Kuti muchite izi, dinani pazithunzi Dzazani mtundu Ndipo sankhani mthunzi womwe mumakonda.
- Mukamaliza, pezani Zatheka أو Idamalizidwa Kuwonetsa zowerengera pamndandanda umodzi.
- Momwemonso, ngati mukuyenera kuchita izi pagawo C, chilinganizo chimakhala, = countif (C1: C, C1)> 1 ndipo chifuniro Momwemonso ndi mizati ina.
Kuphatikiza apo, pali njira yopezera zowerengera pakati pazipilala. Kuti muphunzire, tsatirani izi.
- Tiyerekeze kuti mukufuna kufotokoza zowerengeka pakati pa maselo C5 mpaka C14.
- Poterepa, pitani ku Gwirizanitsani ndi kusankha Kukonzekera mwatsatanetsatane .
- Pansi Pemphani kukulitsa, lowetsani mndandanda wa deta, c5: c14 .
- Kenako, pansi pa Kupanga malamulo, tsegulani menyu yotsitsa ndikusankha Njira yoyenera ndiyo .
- Lowetsani mtengo wamtundu wachikhalidwe, = chiwerengero (C5: C, C5)> 1 .
- Ngati mukufuna, perekani mtundu wosiyana m'mabuku omwe awonetsedwa potsatira njira zapitazo. Mukamaliza, pezani Idamalizidwa .
- Ngati mukufuna, perekani mtundu wosiyana m'mabuku omwe awonetsedwa potsatira njira zapitazo. Mukamaliza, pezani Idamalizidwa .
Google Mapepala: Momwe mungayang'anire zibwereza pamakondomu angapo
Ngati mungafune kulemba zolemba pamizere ndi mizere ingapo, tsatirani izi.
- Tsegulani tsamba lamasamba mu Google Sheets ndikusankha ma column angapo.
- Mwachitsanzo, sankhani mizati B kudzera E> dinani mtundu > Dinani Kukonzekera mwatsatanetsatane .
- Pansi pa Kupanga malamulo, tsegulani menyu yotsitsa ndikusankha Njira yoyenera ndiyo .
- Lowetsani mtengo wamtundu wachikhalidwe, = chiwerengero (B1: E, B1)> 1 .
- Ngati mukufuna, perekani mtundu wosiyana m'mabuku omwe awonetsedwa potsatira njira zapitazo. Mukamaliza, pezani Idamalizidwa .
- Momwemonso, ngati mukufuna kufotokozera zomwe zachitika mu danga M mpaka P, mumalowetsa B1 ndi M1 ndi E ndi P. Njira yatsopanoyo imakhala, = chiwerengero (M1: P, M1)> 1 .
- Kuphatikiza apo, ngati mukufuna kulemba zomwe zidachitika kuchokera ku A mpaka Z, ingobwereza zomwe zachitika kale ndikulowetsa mtengo wamachitidwe, = chiwerengero (A1: Z, A1)> 1 .
Google Mapepala: Chotsani zobwerezedwa patsamba lanu
Mukamaliza kuwonetsa zolemba zomwe zili mkabukuka, sitepe yotsatira ndikuzichotsa. Tsatirani izi.
- Sankhani gawo lomwe mukufuna kuchotsa zowerengera.
- Dinani Zoyipa > chotsani zowerengeka .
- Mudzawona mphukira. ikani chizindikiro Mubokosi pafupi ndi deta muli mutu tsopano> dinani chotsani chotsani > Dinani Idamalizidwa .
- Muthanso kubwereza masitepe ena am'mbali.
Umu ndi momwe mungalembetsere ndikuchotsa zofananira mu Mapepala a Google.
