Naomba msaada kutoka kwa wataalamu wa Microsoft Excel

Naomba msaada kutoka kwa wataalamu wa Microsoft Excel

gobraco

Member
Joined
Jul 2, 2014
Posts
54
Reaction score
22
guys natakiwa kwenye final interviews its all about excel , i will be given computer and excel sheet with questions , pls nipen ma formula na techniques wadau, nimetumia excel ofcn for more thn 3years bt i still believe kuna vitu cvijui so pls seriously comments will b highly apreciated

thanks
 
EXCEL INA FORMULA NYINGI SANA. Hapo inategemea una-deal na kitu gani.
 
Kwa kuanzia ni ;
SUM,AVERAGE,MAX,MIN,COUNT,DSUM,DAVERAGE,DMAX,DMIN,DCOUNT,VLOOKUP,ISNUMBER,ISTEXT,FIND,SUBSTITUTE,LEFT,RIGHT,CONCATENATE,IFERROR,ISBLANK. Pia Arithmetic Operations, Conditional Formatting na Absolute Reference. Ukiadvance kuna Macro zinakusubiri. Kila la kheri.
 
Excel is very broad in terms of formulas and calculations. But interview inategemea na level yako ya education. Kama una level ya degree and above utaulizwa kivyovyote, so kuwa tayari kwa lolote guy
 
Kwa kuanzia ni ;
SUM,AVERAGE,MAX,MIN,COUNT,DSUM,DAVERAGE,DMAX,DMIN,DCOUNT,VLOOKUP,ISNUMBER,ISTEXT,FIND,SUBSTITUTE,LEFT,RIGHT,CONCATENATE,IFERROR,ISBLANK. Pia Arithmetic Operations, Conditional Formatting na Absolute Reference. Ukiadvance kuna Macro zinakusubiri. Kila la kheri.

duh! balaaa , cn u tl me more, aplication ya iziVLOOKUP,ISNUMBER,ISTEXT,FI ND,SUBSTITUTE,LEFT,RIGHT,CONCATENATE,IFERROR,ISBLANK
 
Je mtu akitaka tengeneza sheets ambazo moja inakuwa ni ya kuweka hesabu ya mizigo, nyingine ya mauzo. Ukiuza kitu kule kwenye store inajibadilisha yenyewe
 
Je mtu akitaka tengeneza sheets ambazo moja inakuwa ni ya kuweka hesabu ya mizigo, nyingine ya mauzo. Ukiuza kitu kule kwenye store inajibadilisha yenyewe

Kioñgozi hapo itategemea unaulizwa kitu gani mambo Ni mengi sana!
 
Mimi naomba msaada kwenye formula ya kuzidisha na jins ya kupanga ranks kutoka the highest average to the lowest
 
Mimi naomba msaada kwenye formula ya kuzidisha na jins ya kupanga ranks kutoka the highest average to the lowest

Kuzidisha tunatumia '*' operator, kupanga grade mfano A(81-100), B(61-80), n.k Google how to use IF( ) function. Kupanga highest to lowest tumia SORT button
 
Excel si mchezo. Waweza kujiona umeijua siku ukamkuta mtu anafanya vitu vya ajabu ukajiona hujui kitu.

Ila nadhani kwa jinsi ulivyouliza swali lako.. utapata majibu mengi sn na mengine hayatakusaidia zaidi ya kukuchanganya.

Ingekuwa poa ukasema
nature ya kazi unayokwenda kufanya. Hiyo kitu ni pana sana utapata kizunguzungu bure
 
Kuzidisha tunatumia '*' operator, kupanga grade mfano A(81-100), B(61-80), n.k Google how to use IF( ) function. Kupanga highest to lowest tumia SORT button

Mkuu nashukuru sana hiyo if nested naipata shida ilikuwa hyo ya kuzidisha na hiyo ya sort
 
Nawapongeza wote waliochangia uzi huu bila kejeli wala mizaha .....nimefurahi kusoma comment zinazoonesha watu kuwa tayari kusaidia. Hii ndio faida ya mitandao .....mtu usichojua anajua mwingine hivyo hakuna mjuzi wa kila kitu......safi sana .......
 
kama ni sehemu bado nipo shallow basi ni excel,ina vikororo vingi sana yani.
 
Back
Top Bottom