Shafin aiki ko takarda yana ɗaya shafi a cikin fayil da aka kirkiro tare da shirin kayan shafukan lantarki irin su Excel ko Google Sheets. Littafin littafi ne sunan da aka ba da takardar Excel kuma ya ƙunshi ɗaya ko fiye da ɗawainiya. Kalmar ana yin amfani da maƙallan rubutu don amfani da littafin littafi, lokacin da, kamar yadda aka ambata, shi ya fi dacewa da tsarin kwamfuta kanta.
Sabili da haka, mai magana sosai, lokacin da ka buɗe shirin shafukan yanar gizo na lantarki yana ɗauka wani fayil ɗin ɗakunan ajiya wanda ya kunshi takardun aiki guda ɗaya ko fiye don amfani da kai.
Bayanin aikin aiki
Ana amfani da takardun aiki don adanawa, sarrafawa, da nuna bayanai .
Gidan ɗakin ajiya na asali don bayanai a cikin takardun aiki shine ɗakunan gwanon rectangular da aka shirya a cikin wani tsarin grid a kowace takarda.
Ana gano kwayoyin halitta guda ɗaya da kuma yin amfani da su ta hanyar amfani da haruffan haruffan haruffa da jerin jeri na kwance na takardun aiki waɗanda suke ƙirƙirar ƙirar salula - irin su A1, D15, ko Z467.
Ƙayyadaddun takardun aiki na sassan Excel na yanzu sun haɗa da:
- 1,048,576 layuka da takardun aiki;
- 16,384 ginshiƙai da takardun aiki;
- Kwayoyin sel 17,179,869,184;
- kawai takaddun aiki don sababbin fayiloli (tsoho);
- iyaka akan yawan takardun shaida ta fayil. Wannan ƙayyade ne kawai ta ƙimar ƙwaƙwalwar ajiyar da take samuwa a kwamfuta.
Don Google Sheets:
- Akwai iyakar 256 ginshiƙai da takarda.
- Matsakaicin adadin yawan kwayoyin halitta ga duk takardun aiki a cikin fayil shine 400,000.
- Yawan halin yanzu tsoho na takardun aiki don sababbin fayiloli ɗaya ne.
- Akwai iyakacin takardun aiki na 200 na fayilolin rubutu.
Sunaye Ayyukan aiki
A cikin takardun Excel da na Google, kowanne takardun aiki yana da suna. Ta hanyar tsoho, ana kiran takardun aiki Sheet1, Sheet2, Sheet3 da dai sauransu, amma waɗannan za a sauya sauƙi.
Lissafi na Ayyuka
Ta hanyar tsoho, tun da Excel 2013, akwai takardar aiki kawai ta sabon littafi na Excel, amma ana iya canza wannan darajar ta asali. Don yin haka:
- Danna kan menu na Fayil .
- Danna Zaɓuɓɓuka a cikin menu don buɗe akwatin maganganu na Excel Zabuka.
- A yayin da kake ƙirƙira sabbin littattafan littattafai a cikin matakan dama na akwatin maganganu, ƙãra darajar kusa da Ƙara wannan ɗigon yawa.
- Danna OK don kammala canjin kuma rufe akwatin maganganu.
Lura : Ƙididdigar takardun da aka samo a cikin fayil ɗin Fassara na Google ɗaya ne, kuma wannan baza'a canza ba.
Littafin Ayyuka
- Ana iya ƙara waƙaƙƙun ayyuka ga ɗawainiya ta amfani da yin amfani da menu na mahallin ko Ƙarin Ƙarin Ƙara (ƙarin alama) kusa da shafukan takardun yanzu kamar yadda aka gani a cikin hoto a sama.
- Zai yiwu don sharewa ko don ɓoye takardun aikin takarda a cikin takarda.
- Haka kuma yana yiwuwa a sake suna da takardun aiki takardun aiki kuma ya canza saɓin aiki da launuka don yin sauki don gano takardun mutum a cikin takarda ta amfani da menu na mahallin.
- Canja daga ɗayan aikin ɗayan aiki zuwa wani a cikin littafi mai aiki za a iya yi ta danna kan takardar shafi a kasa na allon.
- A cikin Excel, za a iya amfani da haɗin maɓallin gajeren hanya na baya don canzawa tsakanin shafukan aiki :
- Ctrl + PgUp (shafi na sama) - matsa zuwa dama
- Ctrl + PgDn (shafi na ƙasa) - matsa zuwa hagu
- Don Shafukan Lissafin Google, maɗallan hanyoyin gajeren gajeren haɗi don canzawa tsakanin shafukan aiki shine:
- Ctrl + Shift + PgUp - matsa zuwa dama
- Ctrl + Shift + PgDn - matsa zuwa hagu