Mutsara wechinyorwa, unozivikanwa seyetani kana kungoita semashoko ndeye boka revarairi rinoshandiswa se data mumushandi wepasheetet.
Kunyange zvazvo zvinyorwa zvemashoko zvinowanzowanikwa nemashoko, zvinogonawo kusanganisira vanhu vakadai sa:
- tsamba
- nhamba
- nhamba dzakasiyana-siyana dzakadai sezviitiko (.), chiratidzo chechidha ( - ), kana kuti chiratidzo chehamba ( # )
Nokusingaperi, zvigwaro zvemashoko zvakasara zvakaronganiswa mune imwe kero apo nhamba ye data inowirirana kurudyi.
Kugadzirisa Data seMagwaro
Kunyange zvazvo zvinyorwa zvemashoko zvinowanzotanga netsamba yeramabhaibheri, chero upi hwekutsvaga kwezvinyorwa zvakagadziridzwa sezvinyorwa zvichishandurwa sechitambo.
Kuchinja Numeri neMafomu KuNyorera neApostrophe
Mutsara unogonawo kugadzirwa mune zvose Excel neGoogle Spreadsheets kuburikidza kupinda mu apostrophe ( ' ) seyekutanga tsika ye data.
Iyo apostrophe haisi kuonekwa muchitokisi asi inoshandisa purogiramu kududzira chero nhamba kana zviratidzo zvakapinda mushure me apostrophe semashoko.
Semuenzaniso, kuisa shanduro yakadai se = A1 + B2 sechinyorwa chinyorwa, chinyorwa:
'= A1 + B2
Iyo apostrophe, iyo isingaoneki, inodzivisa purogiramu yepaspiritsi kubva mukududzira chikwangwani senzira.
Kugadzirisa Matanho Emunyore kuNhamba Dhamba muExpcel
Dzimwe nguva, nhamba dzakakopizwa kana kutumirwa mune pepadheetti dzinoshandurwa kuva dhiyabhorosi data. Izvi zvinogona kukonzera matambudziko kana data iri kushandiswa senharo yeimwe yezvirongwa zvakagadzirirwa mumabasa akaita SUM kana AVERAGE .
Sarudzo dzekugadzirisa dambudziko iri dzinosanganisira:
Chokusarudza 1: Nyora Special in Excel
Kushandisa peta yakakosha yekushandura mashoko ekunyorwa kune nhamba zviri nyore uye sekuti inobatsira kuti data yakashandurwa inoramba iri munzvimbo yayo yepakutanga - kusiyana ne VALUE basa iro rinoda kuti dhindedzero yedunhu igare kune imwe nzvimbo kubva kune dhembedzero yepakutanga.
Sarudzo 2: Shandisa Bhoora Rokukanganisa mu Excel
Sezvinoratidzwa mumufananidzo wepamusoro, Bhuku Rokukanganisa kana Rakanganisa Checking Button muEccel rutsanga ruduku ruchizha runowanikwa pedyo nemasero ane zvinyorwa zvepa data - sekuti kana nhamba ye data yakagadzirirwa semashoko inoshandiswa mumutambo. Kushandisa Bhodhi Rokukanganisa kuti uchinje ruzivo rwemashoko kune nhamba:
- Sarudza sero (s) rine data yakaipa
- Dzvanya bhatani rekanganisa pedyo nesero kuti uzarure mhando yemamiriro ezvinhu ezvakasarudzwa
- Dzvanya pakutendeukira kuNhamba mumenyu
Nhamba iri mumasero akasarudzwa inofanira kushandurwa kuva nhamba.
Kugadzirisa Matongero Emagwaro muExcel neGoogle Spreadsheets
MuExcel neGoogle Spreadsheets, chimiro che ampersand (&) chinogona kushandiswa kubatana pamwe chete kana kubatanidza zvigwaro zvemagwaro zviri mumasero akasiyana munzvimbo itsva. Somuenzaniso, kana chinyorwa A chine mazita okutanga uye chinyorwa B mazita ekupedzisira evanhu, masero maviri e data anogona kusanganiswa pamwe muhurukuro C.
Nzira iyo ichaita izvi = = (A1 & "" & B1).
Cherechedzai: mutenzi wemapurisa haaiti kuisa nzvimbo pakati pezvinyorwa zvemashoko zvakanyorwa kuitira kuti vawedzere kuwedzerwa kumushandisi wega. Izvi zvinoitwa nekukomberedza nzvimbo yemunhu (yakashandisa uchishandisa bhora yepakati pabhokisi) nemashoko ekudzokorora sezvakaratidzwa murairi yepamusoro.
Imwe nzira yekubatanidza zvinyorwa zvemashoko ndeyokushandisa CONCATENATE basa .
Kusvetura Nyaya Dhamba muMatare Akawanda ane Text kuColumns
Kuita zvinopesana nekubvumirana - kuparadzanisa rimwe sero re data mumasero maviri kana akawanda akaparadzana - Excel ine Text to Columns inoshandiswa. Matanho ekuita basa iri ndeokuti:
- Sarudza chinyorwa chemasero ane data yakabatana yenyaya.
- Dzvanya pane Data Data ye menu yebhoni .
- Dzvanya paMagwaro kuColumns kuti uzarurire Convert Text kuColumns wizard.
- Pasi Pakati pekutanga dhiyabhorosi yemhando yekutanga danho, chengetedza Delimited , uye ipapo chokutevera .
- Pasi Pechipiri 2, sarudza gwaro rakagadzikana rakagadziriswa kana sarimita ye data yako, yakadai seTab kana Space, uye bhura Next.
- Pasi Pakati pechitatu, sarudza maitiro akafanirwa pasi peChongwe data format , seGeneral.
- Pasi pa Advanced Advanced button, sarudza mamwe maitiro ekuparadzanisa Decimal uye Zviuru zvekuparadzanisa , kana zvakashata - nguva uye comma zvakatarisana - hazvina kukodzera.
- Dhorira Finish kuti uvhare wizard uye udzoke kushizha remabasa.
- Mutsara muhurukuro yakasarudzwa zvino inofanira kuparadzaniswa kuva maviri kana kupfuura.