01 ya 01
Tanthauzo la Cell ndi Ntchito zake ku Excel ndi Google Spreadsheets
Tanthauzo
Selo ndichinthu chofunikira kwambiri chosungirako chopezeka pa pulogalamu ya spreadsheet monga Excel kapena Google Spreadsheet. Deta yomwe inalowa mu pulogalamu ya spreadsheet nthawi zonse imasungidwa mu selo.
Pawindo, selo likuwoneka ngati kapangidwe ka bokosi ndipo lirilonse liri pamsewu wopingasa wa pamzere wokhoma ndi mzere wosakanizika pa tsamba.
Ndi mitu yoposa 16,000 ndi mizere yoposa 1 miliyoni pa tsamba , pali ma 177 billion maselo pa tsamba la Excel. Google Spreadsheets ndi yaying'ono kwambiri ndi maselo pafupifupi 400,000 pa tsamba.
Ntchito
- Monga tanenera, maselo amagwiritsidwa ntchito kusunga deta ndipo amagwiritsidwanso ntchito kusonyeza deta - kawirikawiri ndi mizere ndi mizera ya deta yokhudzana yomwe yasonkhana palimodzi kupanga matebulo.
- Maselo angagwiritse ntchito mitundu iwiri yofunikira (deta mitundu):
- Numeri - yomwe ili ndi maonekedwe, masiku, ndi nthawi;
- Deta pamanja - kawirikawiri amatchulidwa ngati zingwe zolemba kapena zingwe;
- Ziyeso za Boolean (nthawi zina zimatchedwa mfundo zabwino ) - ZOONA kapena ZOMWE zokha;
- Zolakwitsa zamtengo - monga #NULL !, #REF !, ndi # DIV / 0! - zomwe zimapangidwa ndi pulogalamuyi pamene ikukumana ndi vuto ndi deta mu selo.
- Maselo okhala ndi mayendedwe ndi mtima wa mapulogalamu a spreadsheet popeza ndiziwerengero zomwe zimakhala zosavuta kugwira ntchito ndi deta yambiri. Kawirikawiri, maselo amasonyeza zotsatira za mayendedwe, koma mawonetsedwe a Excel a mawonekedwe angasinthidwe ndi kutsekedwa ngati pakufunikira kuti awone mawonekedwe m'malo mwa yankho mu selo.
Mafotokozedwe a Magulu
Chifukwa cha chiwerengero cha maselo pa tsamba, tsamba lodziwika kapena loyitanitsa likufunika kotero kuti deta ikhoza kufulumira komanso mosavuta ngati pakufunika.
Njira yomwe ikugwiritsidwa ntchito m'mapiritsiti amasiku ano ndi mafotokozedwe a selo, omwe ndi ophatikizana ndi kalata ya mzere ndi mzere wa selo. Mu maumboni awa, kalata yam'mbali nthawi zonse imatchulidwa poyamba monga A1, B12, kapena AA2345.
Zolemba za magulu zimakhala ngati malo pomwe zimagwiritsidwa ntchito pazinthu monga malemba ndi malemba ndi kupezeka kwawo zimapangitsa kuti zikhale zosavuta kusinthira malemba ndi masatidwe awa, popeza kuti deta iliyonse yomwe ilipo mu selo imalowetsedwa pamalo oyenera muzithunzi kapena tchati .
Kupanga Mafoni
- Maselo onse omwe ali pa pepala amapanga zofanana zomwe zimapangidwira mwachisawawa, zomwe zimapanga masamba akuluakulu omwe ali ndi deta yambiri yovuta kuwerenga. Kuwonjezera kuyika maonekedwe kumadera osiyanasiyana a tsambali kumatha kufotokozera magawo ena ndikuwathandiza kuti awerenge komanso kumvetsetsa mosavuta.
- Kupanga ma selo kumasiyana ndi kuwerengera kwa Namba . Kupanga ma selo kumaphatikiza kusintha kwa selo lokha - monga kusintha mtundu wa chigawo, kuwonjezera malire, kapena kusintha kusintha kwa deta. Mapangidwe a chiwerengero amachitika ndi momwe mawerengero m'maselo amawonetsedwa - monga ndalama, peresenti, kapena kuwonetsa manambala osayera ofiira.
Kuwonetsedwa ndi Mawerengedwe Osungidwa
Mu Excel onse ndi Google Spreadsheets, pamene mawonekedwe a chiwerengero akugwiritsidwa ntchito, chiwerengero chomwe chikuwonetsedwa mu selo chikhoza kusiyana ndi chiwerengero chomwe chimasungidwa mu selo ndikugwiritsidwa ntchito powerengera.
Pamene kusintha maonekedwe kumapangidwira ku nambala mu selo kusintha kumene kumakhudza maonekedwe a nambala osati nambala yokha. Mwachitsanzo, ngati chiwerengero cha 5.6789 mu selo chinapangidwira kuti chiwonetsedwe malo awiri okha (ziwerengero ziwiri ndi ufulu wa decimal), selo likhoza kusonyeza chiwerengero monga 5.68 chifukwa chozungulira digiti yachitatu.
Mawerengedwe ndi Mawerengedwe Owerengedwa
Pankhani yogwiritsira ntchito maselo oterewa a deta muzowerengera, komabe nambala yonse - pakali pano 5.6789 - idzagwiritsidwa ntchito pazowerengera zonse osati nambala yozungulira yomwe ikuwonekera mu selo.
Kuwonjezera Maselo ku Tsamba Labwino mu Excel
Zindikirani: Google Spreadsheets salola kuti kuwonjezera kapena kuchotsedwa kwa maselo amodzi - kokha kuwonjezera kapena kuchotsa mzere kapena mizere yonse.
Maselo apamodzi akawonjezeredwa pa tsamba, ma selo omwe alipo ndi deta zawo amasunthidwa pansi kapena kuti ali ndi ufulu wopezera chipinda chatsopanocho.
Maselo akhoza kuwonjezedwa
- Ndi makina ochezera makanema;
- Ndikulumikiza molondola ndi mbewa
- Pogwiritsira ntchito ndondomeko yowonjezera pa tsamba la Pakiti la Ribbon;
Kuti muwonjezere selo limodzi pa nthawi, sankhani maselo ambiri ngati njira yoyamba pa njira zotsatirazi.
Kuika Makilogalamu ndi Shortcut Keys
Kuphatikizira kwa makiyi a makiyi a kuyika maselo muwomaliza ndi:
Ctrl + Shift + "+" (kuphatikizapo chizindikiro)Zindikirani : Ngati muli ndi kibokosi ndi Number Pad kumanja kwa makina okhazikika, mungagwiritse ntchito chizindikiro + kumeneko popanda chinsinsi cha Shift . Mgwirizano wachinsinsi umangokhala:
Ctrl + "+" (kuphatikizapo chizindikiro)Dinani Pamanja ndi Mouse
Kuwonjezera selo:
- Dinani pa selo pomwe selo yatsopano iyenera kuwonjezeredwa kuti mutsegule mitu yotsatira;
- Mu menyu, dinani pa Insert kuti mutsegule Insert dialog box ;
- Mu bokosi la zokambirana, sankhani kukhala ndi maselo oyandikana nawo kapena kusinthana kuti apange malo a selo yatsopano;
- Dinani OK kuti muike selo ndi kutseka bokosi lazokambirana.
Mwinanso, Insert dialog box ikhoza kutsegulidwa kudzera pa chithunzi cha Insert pa Tsamba la Home la Riboni monga momwe tawonetsera pa chithunzi pamwambapa.
Mukatseguka, tsatirani masitepe 3 ndi 4 pamwamba pa kuwonjezera maselo.
Kuchotsa Maselo ndi Mkati Mwali
Selo laumwini ndi zomwe zili mkatimo zingathetsedwenso kuchoka pa tsamba. Izi zikachitika, maselo ndi deta yawo kuchokera pansipa kapena kumanja kwa selo lochotsedwa lidzasunthira kusiyana.
Kuchotsa maselo:
- Onetsetsani maselo amodzi kapena angapo kuti achotsedwe;
- Dinani pa maselo osankhidwa kuti mutsegule mndandanda wamakono;
- Mu menyu, dinani pa Chotsani kuti mutsegule Chotsani bokosi la dialog;
- Mu bokosi la bokosi, sankhani kuti maselo amasunthike mmwamba kapena kuchokera kumanzere kuti alowe m'malo omwe achotsedwa;
- Dinani OK kuti muchotse maselo ndi kutseka bokosi.
Kuchotsa zomwe zili m'maselo amodzi kapena angapo, popanda kuchotsa selo lokha:
- Onetsetsani maselo okhala ndi zinthu zoti zisinthidwe;
- Dinani makani ochotsera pa makiyi.
Dziwani: Chinsinsi cha Backspace chingagwiritsidwe ntchito kuchotsa zomwe zili m'selo imodzi yokha panthawi imodzi. Mukamachita zimenezi, imapereka Excel mu Edit mode. Chotsani Chotsitsa ndicho njira yabwino yochotsera zomwe zili m'maselo angapo.