Masamba ndi Mabuku Ogwira Ntchito ku Excel

Pepala lolemba kapena pepala ndi tsamba limodzi mu fayilo yokhala ndi pulogalamu yamakono yofalitsa monga Excel kapena Google Sheets. Bukhu la ntchito ndi dzina lopatsidwa pa fayilo ya Excel ndipo liri ndi timapepala limodzi kapena ambiri. Mawu akuti spreadsheet amagwiritsidwa ntchito poyang'ana ku bukhuli, pamene, monga tanenera, limatanthauzira molondola pulogalamu ya pakompyuta.

Choncho, poyankhula, mutatsegula pulogalamu ya pulogalamu yamakono yowonjezera bukulo lopanda ntchito lopanda mafayilo omwe ali ndi limodzi kapena angapo osalembapo masamba omwe mungagwiritse ntchito.

Dongosolo la Zolemba

Tsamba lamasewera limagwiritsidwa ntchito kusunga, kugwiritsira ntchito, ndi kusonyeza deta .

Chigawo chosungirako chosungiramo deta muzomwe zili pa tsamba ndi maselo opangidwa ndi mawonekedwe ang'onoting'ono omwe amasungidwa mu gridiyi mu tsamba lililonse.

Selo limodzi la deta limazindikiritsidwa ndipo limagwiritsidwa ntchito pogwiritsa ntchito makalata owongolera ndi mazere ofanana a mzere wa tsamba lomwe limapanga selolo - monga A1, D15, kapena Z467.

Mafotokozedwe apamanja a zowonjezera za Excel ndi awa:

• Mzere 1,048,576 pa tsamba la ntchito;
• Masamba 16,384 pa tsamba;
• 17,179,869,184 maselo pa tsamba;
• pepala limodzi la mafayilo atsopano (osasintha);
• Malire pa chiwerengero cha mapepala pa fayilo. Izi ndi zochepa chabe ndi kuchuluka kwa kukumbukira kupezeka pa kompyuta.

Kwa Google Mapepala:

• Pali maulendo angapo 256 pa pepala.
• Maselo ochuluka a maselo onse ogwira ntchito mu fayilo ndi 400,000.
• Nambala yosasinthika ya maofesi a mafayilo atsopano ndi amodzi.
• Pali maofesi angapo okwana 200 pa fayilo lasepirititi.

Mayina a Zopangira

Mu Excel ndi Google Spreadsheets, tsamba lililonse lili ndi dzina. Mwachinsinsi, masambawa amatchedwa Sheet1, Sheet2, Sheet3 ndi zina zotero, koma izi zingasinthe mosavuta.

Numeri Zopangira Ntchito

Mwachinsinsi, kuchokera ku Excel 2013, pali tsamba lokha la ntchito pa bukhu latsopano la Excel, koma mtengo wosasinthika ukhoza kusinthidwa. Kuchita izi:

1. Dinani pa Fayilo menyu.
2. Dinani pa Zosankha mu menyu kuti mutsegule Zokambirana za Excel Options.
3. Mukamapanga kachigawo ka mabuku atsopano m'malo oyenera pa bokosi, kambitsani mtengo pambali Phatikizani mapepala ambiri.
4. Dinani ku OK kuti mutsirize kusintha ndikutseketsa bokosi.

Dziwani : Nambala yosasinthika yamapepala mu fayilo ya Google Spreadsheets ndi imodzi, ndipo izi sizingasinthe.

Zolemba za Ntchito

• Zowonjezereka zamagetsi zingathe kuwonjezeredwa ku bukhu la ntchito pogwiritsira ntchito mndandanda wamakono kapena chojambula Chakuwonjezera (kuphatikizapo chizindikiro) pambali pazithunzi zamakono zomwe zikuwonetsedwa pa chithunzi pamwambapa.
• N'zotheka kuchotsa kapena kubisa mapepala ogwiritsira ntchito.
• N'zotheka kutchulidwanso mapepala ogwiritsira ntchito ndikusintha mitundu ya ma tepi yapamwamba kuti zikhale zosavuta kuzindikira mapepala omwe ali m'bukulo pogwiritsira ntchito mndandanda wa masewera.
• Kusintha kuchokera pa tsamba limodzi kupita ku bukhu la buku lingathe kuchitidwa podutsa pa pepala pepala pansi pazenera.
• Mu Excel, njira zotsatilazi zazikuluzikulu zingagwiritsidwe ntchito kusinthana pakati pa mapepala :
  • Ctrl + PgUp (tsamba pamwamba) - yendani kumanja
  • Ctrl + PgDn (tsamba pansi) - yendani kumanzere
• Kwa Google Spreadsheets, kusakanikirana kwakukulu kwasinthidwe kusinthasintha pakati pa mapepala ndi:
  • Ctrl + Shift + PgUp - pita kumanja
  • Ctrl + Shift + PgDn - pita kumanzere