👉3:01:46 IEEE: INSTITUTE OF ELECTRICAL AND ELECTRONICS ENGINEERS 👉3:53:38 MOD(12,4)=0 👉5:01:32 COUNTA() --->Counts Non Empty Cells 👉5:02:46 Count() ----> Counts Numeric Entries ➡️count() -only no. of numeric values return krwayega,alphabet ya symbol nhi ➡️CountA()--Eh empty cells nu counts nhi krda.baki no. of record return krwayega jisde andr koi v data ho skda like numeric, alphabetic, symbol.Means Non-empty cells nu count krega ➡️Countblank()--number of empty cells return krwayega ➡️Countif()-- jehre cell vichla data given criteria ya condition nu met krega sirf us nu hi return krwayega for eg in cell range select krke koi city da name v de skde a ki is range v is particular city da name kini war aea
ਸਤਿ ਸ਼੍ਰੀ ਅਕਾਲ ਪਿਆਰੇ ਵਿਦਿਆਰਥੀਓ, ਕ੍ਰਿਪਾ ਕਰਕੇ ਨੋਟ ਕਰੋ ਪ੍ਰਸ਼ਨ ਨੰਬਰ 28-Internet based applications were introduced during which generation? ਇਸਦਾ ਸਹੀ ਉੱਤਰ Fifth generation ਆਵੇਗਾ ਜੀ ਅਤੇ ਪ੍ਰਸ਼ਨ ਨੰਬਰ 99- Which of the following is NOT the characteristics of computer? ਇਸਦਾ ਉੱਤਰ - Inaccuracy ਆਵੇਗਾ ਜੀ .........ਅਤੇ ਪ੍ਰਸ਼ਨ ਨੰਬਰ 255: What is the default PowerPoint standard layout? ਇਸਦਾ ਸਹੀ ਉੱਤਰ Title slide ਆਵੇਗਾ ਜੀ , .......ਧੰਨਵਾਦ ਜੀ
@POLA8899 Жыл бұрын
Thanku sir ji 🙏🏻💫
@rupsbaidwan2714 Жыл бұрын
@jitsimran sandhu usi din hona jis din exam a 21 may
@ravradio1313 Жыл бұрын
sir paper A di marathon bna davo us naal hi sadi punjab gk + punjabi grammar hoju ,pls ek marathon bna davo , tusi sarey bacheya de comments pad ke dekhlo sab ne ehi demand kiti hai
@ravradio1313 Жыл бұрын
Ok sir tuhadi class hi lga rhe haa ji aj complete kar leni 😊
Sir ji raat de 2 vjj ge c ji Mai son hi lggi c ji But jdo thodi class dekhi ta automatic hi mere vich josh aa gea 🙏🙏🙏🙏....... Thank you guru ji 🙏🙏🙏 Ena motivate krn li te Mehnat krn li ji 🙏🙏 Hun ta mai subha tkk laugi ji class 😅😅🙏🙏
1. Count a non empty cells 2. Count Thanku soo much respected sir jii...for this amazing video...waheguru jii tuhanu chardikala bakshan ....baba jii kirpa bnayi rakhan...😍
Answer 1 (d) count non empty cell Answer 2 (b) count function ਧੰਨਵਾਦ ਮਾਸਟਰ ਜੀ 🙏
@ZAIRA_ZR Жыл бұрын
Very great session really appreciate really hard work of urs 5 hr live session not so easy 🙏 Respect sir thanks a lot Hope so all students saw this live session it will very helpful for all students ...........free 🆓 of cost Sir really have no words to describe .............hope so question cm in exam all ☺️ of ur session ........ ☺️☺️ this video 📸 remarks fruitful 🌺 Results ....... Thanks Positive Punjab
@Amandeepsingh4699 күн бұрын
Very excellent💯💯 class mere friend ne class attend half kiti 5 question pp ch aye us de kehn te eh class join kiti bhtt kush sikhn nu milya jug jug jio sir ji always wmk ❤
@simranpalaulakh1008 Жыл бұрын
Tuhadi mehnat nu slaam sir🙌🙌raat nu jaag k Sade lyi marathon bnayi tusi 5 hours di🙌thank u so much sir. Parmatma tuhanu bohta bohta deve🙏
@jyoti3691 Жыл бұрын
Count() count numeric entries..countA() count non empty cells...count blank() count empty cells..count if () conditions criteria
waheguru ji ka khalsa waheguru ji ki fateh 🙏🙏🙏🙏 bujhe paye logha di aas ho ji.. kuj kar dikhon alleya le sahaas ho.. assa ta nimane je na jande ki changa ki madda... tuci chaddhii saver di umid varge jo sadi mehnat layi khass ho.. waheguru ji tuhanu hmesha khush rakhe te tuci khushiya mano
@priyanka92939 Жыл бұрын
Super session 👌👌 Thank you so much Sir 🙏 ਵਾਹਿਗੁਰੂ ਜੀ ਸਭ ਦੇ ਸਿਰ ਤੇ ਮੇਹਰ ਭਰਿਅਾ ਹੱਥ ਰੱਖਣਾ !! 🙏🙏
@devilshorts4063 Жыл бұрын
thank you sir for this best class WAHEGURU thonu te thodi family nu khushiya bkshay
@POLA8899 Жыл бұрын
IBM - 1911,NEW YORK NICKNAME - big blue 🔵
@_________SATINDERJIT___SINGH Жыл бұрын
Count () numerical value COUNTA () empty cell Count if() number of cells in criterion (exmpl.. Jive kise given data vch jiv games lgalo k ਉਲੰਪਿਕ games vch 2008 ਨੀਰਜ ਚੋਪੜਾ 2012 vch ਨੀਰਜ chopra etc. Eh function lon nl sara data ਨੀਰਜ ਚੋਪੜਾ ਦਾ sahmne aju)
This is the Greatest Divine service in the welfare of Students you are giving sir. Absolutely the Best . Rabb tuhaanu Duniya di har khushi deve ❤❤❤❤❤
@pavittarsingh3215 Жыл бұрын
Bhut dhanwad sir ji for the marathon - bhut hi wadhia content - bhut mehnat naal bnaya hoya hai+ 1 quotation te 5-6 minimum doubts clear hoye ne - 0 second wastage of precious time 🙏
@parmjeetsingh2873 Жыл бұрын
Count= number Counta = non empty cell Countif= one condition Countifs= jade conditions Count blank= ਖਾਲੀ🙏🏽🙏🏽🙏🏽
No words for your hard work & dedication...Thanku so much sir for such a great class...The answers of last 2 questions are D & B
@ajayravish2627 Жыл бұрын
Que 192 excise me aaya h sir ,,,, kamaal ki prediction ki h sir aapne ,,
@PreetPreeet1176 Жыл бұрын
Waheguru ji aap nu hamesha chardikala ch rakhan god bless you sirrr👍
@navjotkaur5868 Жыл бұрын
Thanku so much for this session.tusi bht jada chnge person ho.tusi mere inspiration ho.jdo v parmatma ne job bkshi mei jrur augi tohnu miln.
@sandeepbrar7747 Жыл бұрын
Kehre patwari wale Legend hun dekh rahe aw video
@Mathsstation2234 Жыл бұрын
Dhanbad sir g....tuhadi 5 hour di video nal mera sara computer fa paper clear ho gya......great sir g 👍
@POLA8899 Жыл бұрын
⭐COUNTA() - COUNT NON EMPTY CELLS ⭐COUNT() - NUMBERS ONLY ⭐COUNTBLANK - EMPTY CELLS
@panku4682 Жыл бұрын
use the COUNT function to get the number of entries in a number field that is in a range or array of numbers. For example, you can enter the following formula to count the numbers in the range A1:A20: =COUNT(A1:A20).
@harishmahar5248 Жыл бұрын
bhot wdia helpful video h sir ...... tohdi koshish sadi jaror help krugi bhot wdia tyq sir tohde efforts sade lai bhot ਮਦਦਗਾਰ ਹੋਣ ge
@jassi.jaskaran7 Жыл бұрын
Full form of IEEE:- Institute of Electrical and Electronics Engineers 🙏🙏❤
@arshpreet8649 Жыл бұрын
tuc sir jina krde o koi ni kr sakda thonu waheguru ji ne hi bhijiya sade lai pta ni o app hi a k sanu thode roop ch pda rahe ne thku so much sir
Thanku so much sir jii.......Sir thuhnu kuj kehn layii Iss diya te koi ਸ਼ਬਦ hii nye bna jii❣️......tusi te rabb duja roop oo jii.....Jo sada paper clear krvon ayia oo ji.....🙏🙏
@nirmalkaur2394 Жыл бұрын
ਬਹੁਤ ਵਧੀਆ sir ji, me new ਜੁੜੀ ਆ ਜੀ ਤੁਹਾਡੇ ਨਾਲ 🙏🙏 ਬਹੁਤ ਹੈ ਵਧੀਆ ਇਨਸਾਨ ਹੋ ਤੁਸੀ ਜੀ ਵਾਹਿਗੁਰੂ ਤੁਹਾਨੂੰ ਬਹੁਤ ਬਹੁਤ ਤਰੱਕੀ ਬਖਸ਼ੇ❤❤
Bhutt vdya smjaya guru ji dhanwand rabb traki bakshe thonu
@ginnycheema6867 Жыл бұрын
Qus.256). 12%3 = 0 1)counts non empty cells 2.Num
@anmol5091 Жыл бұрын
Sir mein thode padhaan da tarika bht zyada vdiya e 👌🏻 tu c bht pyar nal te sche dil nal pdane ho 👌🏻 Rabb thoda bht bht bhala kre ; thonu bht punn lge !!
@priyakamboj2359 Жыл бұрын
Sir bhut helpful class c tuahdi mehnt nal kine hi students da future bn ju
ਕੰਪਿਊਟਰ ਬਹੁਤ ਪੜਿਆ ਪਰ ਕਦੇ ਏਨਾ ਕਲੀਅਰ ਨਹੀਂ ਹੋਇਆ ਬਹੁਤ ਬਹੁਤ ਧੰਨਵਾਦ sir ji 🙏
@manjinderkaur3602 Жыл бұрын
COUNTA-count non empty cell COUNT- Count numeric value thnkyu sir
@jauraattires9542 Жыл бұрын
Schi bhut khushi hoi v avdi language quality content milya Bhut bhut shukriya guru ji 🙌 jeonde vsde rho guru ji Ik marathon de handwritten notes bna lye ne ji , 425 swaal hoge ji Hun ehnu e hr var revise krna ji Rbb tuhanu hor v trkkian bkhshe master ji ਸਰਬੱਤ ਦਾ ਭਲਾ 🙌
@singhkuldeep6177 Жыл бұрын
Thanks sir ji bht kush sikhn nu mileya ..god bless you always
@Harpreetsingh-zq2nt Жыл бұрын
Thanks sir ji gbu ji sir mre kol shabad ni hege k ma thoda thanks kida kara ena vadia session lagaya tusi mera mann sachio positive hogya ji so ❤️ thanks ji🙏🙏🙏🙏🙏🙏👍🙏🙏👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍 COUNTA( ):To count cell that are not empty. COUNT:To count cells that contain number. COUNT Blank: To count cell that are blank.
@rohitjindal7040 Жыл бұрын
Bahut vadiya class rab chad diya kla h rekha sir nu .............
@davindersingh3782 Жыл бұрын
❤❤❤❤❤❤❤❤bhut bhut dhanyawad master ji dharam nal rooh nu hi sakoon mil giya poore da pora computer kra ta
@veerpalmanne149211 күн бұрын
sir bhut vidya clas hai ❤🙏🙏
@khushpreetjoshi7924 Жыл бұрын
ਧੰਨਵਾਦ ਸਰ ਜੀ 🙏 ਪ੍ਰਮਾਤਮਾ ਤੰਦਰੁਸਤੀ ਬਖਸ਼ੇ ਤੁਹਾਨੂੰ
@PreetSingh-zy2xk Жыл бұрын
Very nice session sir bhut hi vadhiya ma pichle patwari ch tohdi class lgvai c te forest guard ch gk v sari todhi krayi ayi todhe harek class ch Bani nal Judde a Baba ji 🙏 trakiya baakshan tohnu
@manpreetsingh-fx3jf Жыл бұрын
Excellent sir j tusi bhout vdia tarike nal exam di tyrai kra reheoo j m firemen di tyari kar reha
@suman-mb5qr Жыл бұрын
Esto vdhiya class ho ee skdi koi...bht bht dhanwaad sir...
@Maniivlogs-we1xr Жыл бұрын
Thank u so much sir ji for marathon lyi thoda jina v dhanwad kita jye ghat a sir tusi nal practical v krya sari marathon de vich sir thank u so much sir main computer bilkul nai pdhya c marathon laga k lgya v mera sara computer da subject ho gya patwari lyi.. dhanwad sir ji..
@neetusandhu8427 Жыл бұрын
Bout bout bout bout sukariya dear Respected sir 🙏🙏🙏🙏🙏.. tuc bout vadiya smjiya ji 🙏🙏.. weheguruji 🙏 aap nu hemessa slamaat rakhe ji...... Aap labi Umer Hove 🙏🙏
Q.1. Da ans-option(a) Q.2.ans. is-(count) Bht Bht dhanwaad guru ji Bht Achaa content uh r always great sir I have no words to praise ur efforts... Thanku Thanku Thanku so much sir ji.... 🙏🙏Rbb ji thnu te thde nl jude Hr Ik insaan Nu tandrusti Nd trakki Bkshn.. ❤️❤️
@nehaamroya2807 Жыл бұрын
Bhot vdia lgya sir ji pd ke ..sab yaad hogya ..hope tuhdi duava te ehni mehnt nl kl paper v clear hoje🙏🏻
@namanpreet1950 Жыл бұрын
Thx sir ji rb sodi omr lmbi krye tusi sanu aapne bache smj kye ena kita sade lyi rb sonu hr khusi deve sir ji
@reetinsan8127 Жыл бұрын
Sat Sri Akal Sir g, Sir me MSc(IT) kiti hoi hai bt ena vdia explain ajj takk kise ne nhi kita. Jere topic kde clear nhi hoe c oh v clear ho gye. Thanks a lot Sir g
Great session sir..rabb tarikiya bakshe thonu...bhut bhut dhanwad thoda.😊
@harshitmahajan8013 Жыл бұрын
Q1) COUNTA() function :- D option Q2) B option. Thank you so much sir ji🙏🙏
@gsk9695 Жыл бұрын
Thank you sir... 🎉❤ First question answer is D 2nd answer is B
@parminderaulakh5138 Жыл бұрын
Answers Ans.1 count non empty cells Ans.2 count Thank you so much sir 🙏
@monikagupta9442Ай бұрын
Thanks sir Tusi bahut vadia computer padhaunde ho God bless u sir sachi dilon respect kardi haan te tusi motivate karde ho taan lagda aw ki job hun le ke hi saah lena hai so much thank you sir 🎉🎉
@S.k..boutiques Жыл бұрын
V nic class sir ji Parmatma tuhanu tarkia bakhsha Wahaguru ji 🙏 wmk❤🎉
@___-xb5hd Жыл бұрын
Thanks sir 🙏🏻....patwari 2023 vich Sara computer tuhade krwe hoe vicho hi ayia.....tuhadi marathon lgai si mai❤
@dilpreetwaraich4887 Жыл бұрын
BHT BHT DHANWAD JI TUHDI KITI MEHNAT ZROR RANG LEA K AYEGI ....CALSSS LGA K MN DA ADDA BOOZ GHT HO GYA JI .......SUKRIYA G...DIL TO RESPECT MERE VDE VEER LYI
@RanjeetSingh-on5eq Жыл бұрын
thanku so much sir.... bohut vadia rhi class .. schi swad agya