Tambayoyi ne dabi'u da ke aiki da amfani don yin lissafi. A cikin shirye-shirye na ɗawainiya irin su Excel da Google Sheets, ayyuka suna ƙaddarawa ne kawai da suke aiwatar da ƙayyadaddun lissafin kuma yawancin waɗannan ayyuka suna buƙatar shigar da bayanai, ko ta mai amfani ko wata maɓalli, don sake dawowa sakamakon.
Haɗin aiki
Haɗin aikin aiki yana nufin layout na aikin kuma ya haɗa da sunan aikin, iyaye, haɓaka takaddama, da kuma muhawararsu.
Tambayoyin suna koyawa kewaye da iyaye da kuma jayayya ta mutum da rabuwa.
Misali mai sauƙi, wanda aka nuna a cikin hoton da ke sama, shine aikin SUM - wanda za'a iya amfani dashi a taƙaice ko jimlar ginshiƙai ko layuka na lambobi. Haɗin aikin don wannan aikin shine:
SUM (Lamba1, Number2, ... Number255)
Ƙididdigar wannan aikin shine: Number1, Number2, ... Number255
Yawan Magana
Yawan muhawara da aiki yana buƙatar ya bambanta da aikin. Ayyukan SUM na iya samun hargitsi 255, amma ana buƙatar guda daya - hujjar Number1 - saura saurayi ne.
Ayyukan OFFSET, a halin yanzu, yana da muhawara uku da aka buƙata da wasu masu zaɓi biyu.
Wasu ayyuka, kamar ayyukan NOW da yau , ba su da wata hujja, amma zana bayanan su - lambar serial ko kwanan wata - daga tsarin komfutar kwamfutar. Duk da cewa babu waɗannan muhawarar da waɗannan ayyuka suke bukata, dole ne a haɗa su tare da haɗin gwargwadon aikin, lokacin da za su shiga aikin.
Siffofin Data a cikin Magana
Kamar yawan muhawarar, nau'in bayanai da za a iya shigarwa don hujja zai bambanta dangane da aikin.
A cikin yanayin SUM, kamar yadda aka nuna a cikin hoton da ke sama, dole ne muhawara ya ƙunshi bayanai - amma wannan bayanan zai iya zama:
- ainihin bayanan da aka tara - lamarin Number1 a cikin hoto a sama;
- tantancewar tantancewar mutum game da wurin da aka adana bayanai a cikin takardun aiki - da hujjar Number2;
- wani tsararraki ko kewayon labaran tantance halitta - hujjar Number3;
Sauran nau'in bayanai da za a iya amfani dasu don muhawara sun hada da:
- bayanan rubutu;
- Boolean dabi'u ;
- kuskuren kuskure ;
- wasu ayyuka.
Ayyukan Nesting
Yana da amfani don aikin daya da za a shigar a matsayin hujja don wani aiki. Wannan aikin an san shi ne a matsayin ayyukan nesting kuma ana aikata shi don ƙaddamar da damar da wannan shirin yake wajen aiwatar da ƙididdigar ƙwayoyin.
Alal misali, ba abu ne wanda ba a sani ba ga ayyukan IF wanda za a gwada shi cikin ɗayan kamar yadda aka nuna a kasa.
= IF (A1> 50, IF (A2 <100, A1 * 10, A1 * 25)
A cikin wannan misalin, aikin na biyu ko aikin da aka kafa na IF yana amfani da shi a matsayin darajar Value_if_true na aikin IF na farko kuma ana amfani dasu don gwadawa na biyu - idan bayanan da ke cikin salula A2 ba kasa da 100 ba.
Tun da Excel 2007, 64 matakan nesting an halatta a cikin takaddun. Kafin wannan, kawai matakan bakwai na nesting sun goyi bayan.
Nemo Ayyukan Ayyuka & # 39; s Magana
Hanyoyi biyu na gano ka'idodin hujja ga kowane aiki shine:
- Bude akwatin maganganu a cikin Excel;
- Fayil na kayan aiki a cikin Excel da Google Lissafi.
Ayyuka Tattaunawa na Excel na Excel
Mafi yawan ayyuka a cikin Excel suna da akwatin maganganu - kamar yadda aka nuna don aikin SUM a cikin hoton da ke sama - wanda ya tsara abubuwan da ake buƙatar da zaɓin don aikin.
Za a iya buɗe akwatin maganganun aiki ta hanyar:
- ganowa da danna kan sunan aikin a karkashin Formula tab na ribbon ;
- danna kan Zaɓin Ƙungiyar Zaɓuɓɓuka da ke kusa da maɓallin tsari - kamar yadda aka nuna a cikin hoto a sama.
Tooltips: Rubutun Ayyuka & # 39; s
Wata hanya ta gano ƙididdigar aiki a Excel da a cikin Shafukan Rubutun Google shine:
- Danna kan tantanin halitta,
- Shigar da alamar daidai - don sanar da shirin da aka shigar da wani tsari;
- Shigar da sunan aikin - yayin da kake bugawa, sunayen duk ayyukan da suka fara tare da wasikar ta bayyana a cikin kayan kayan aiki a ƙasa da tantanin halitta;
- Shigar da bude openhesis - aikin da aka kayyade da kuma muhawarar an lissafa a cikin kayan aiki.
A cikin Excel, window kayan kayan aiki yana kewaye da muhawara na zaɓi tare da madaidaiciya madaidaici ([]). Duk wa] anda aka rubuta jayayya ake bukata.
A cikin Shirye-shiryen Shafukan Google, window na kayan aiki ba ya bambanta tsakanin abin da ake buƙata da zaɓin zaɓi. Maimakon haka, ya haɗa da misali da taƙaitaccen aikin da ake amfani da shi da kuma bayanin kowane jayayya.