Punjab & Haryana High Court Steno CPT | Excel Spreadsheet Practice Test | Part-7

[@nikiverma3140]

Sir kya male female ki salary fill krte time IF condition apply nhi ho skti

[@PalwinderSingh-lt4vw]

Sir serial no naal dot lgya c oh kiven lgana....lgg ni riha ji kindly dsyo jiii 🙏🙏🙏

[@ShivamKumar-fb3nv]

3rd qn. Glat btae Rule is....=if(c2="male",16000,if(c2="female",15000))

[@OfficeGuruji]

Bro simple tarika bataya hai. Formula ke saath bhi video aayega.

[@AmandeepSingh-vl1vo]

Bro mere pc pe ye apply nhi ho raha

[@donttellmejustlisten4598]

simple method nahi chalta , formula lagana padega ,yeh bhe likh sakte =if(c2="male",16000,17000)

[@donttellmejustlisten4598]

bina formula layage simple sum minus etc se he sab kuch ho jayega norma(advance chodkar)l. yese if ka formula mat llagao bus data dekh kar he fill kardo

[@Youtub60662592]

Moye moye

[@sumanbeniwal4892]

Sr. No. Me 1. One ko dot k sth kese ਲਿਖੇ

[@OfficeGuruji]

Excel me 1 ke saath dot lagane ki jaroorat nahi hai

[@ccs1547]

Aisa hi questions aa skta hai kya aur hard

[@OfficeGuruji]

Confusing questions aa sakte hain lekin aayega basic excel hi.

[@kartikattari8263]

Net salary dono ki alg alg q nikle gi sir

[@OfficeGuruji]

Because question me kahi nahi likha ki kewal year 2020 ki nikalo ya 2021 ki. To dono years ki nikalni padegi

[@jyotithareja2404]

Sir average ke liye hum row ko merge krke last m salary 2020 and salary 2021 ki average nikal sktey h

[@jyotithareja2404]

Kuki sir mention nahi h row leni h ya column lena h..

[@OfficeGuruji]

Kar sakte hai but hamne Salary, Net Salary aur Expenses sabka alag alag calculate kiya hai...isliye Average bhi alag alag hi count kiya. Baki aap apni marzi se jo sahi lage kar sakte hain

[@gurpreetnafri6902]

Sir the serial no.in table is “1.” And when we put in excel its “1” even if we type “1.” It still shows “1”

[@AjaySharma_-uv2cz]

Restorer?

[@Ashee_0]

Average salary should be from Net salary

[@OfficeGuruji]

Why?

[@Ashee_0]

@@OfficeGuruji actually they were told us to calculate net salary, after that average salary need to be checked, if average salary need to be from earlier salary they were told before calculating net salary

[@preeti12381]

Sir, sumif, countif ye sare formulas kr uses krwa dijiye

[@OfficeGuruji]

Ok noted

[@rishabhchawla4015]

Bhai ye copy kese krte hai

[@monikamalik7180]

Thank u sir very informative

[@OfficeGuruji]

Thank You

[@anubhavrathore4249]

Thnku sir or hard videos daliye thode alg formulas ke 🙏🏻

[@OfficeGuruji]

Sure

[@Ujjwal_Dutta]

Sir shyd itna lamba Test me nahi aayga. What you think ?

[@OfficeGuruji]

May be 5 questions hi aayenge

[@abhinandanvasudev2026]

Sir typing ke liye bhi video banado

[@sharetradingeducationforev5608]

Hello sir Kindly sir cells ke formula ko copy paste Krna explain kre. Haryana Steno exam k liye ms word jitna bhi important h sara option explain kr dijiye

[@OfficeGuruji]

Ok

[@PASCIHC]

Bhut bdiya sir... Sir 18 dec 2021 me spreadsheet test he... Sir tb tk or jyada videos le aaeye... Word pad se related bhi... ☺☺☺☺ thank you very much again sir

[@OfficeGuruji]

Ok

[@ravi3340]

Sir plz isme if formula lagakar salary kijiye aise nhi krna plz help

[@OfficeGuruji]

Ok noted

[@Bobby25689]

Sir jese aapne salary expenses vala kiya ye galat nhi mana jaayega .. ya formula lgaye if(c2 is male please raaye de isme 😮 i m little confuse .. agr jese aapne btaya ye fast issey no. Milege

[@rawece]

Sir serial no mein digit ke baad ik dot bhi hai....how to put that

[@gauravkharol5641]

Sir chart aur graph ki videos daliye

[@OfficeGuruji]

Ok ji

[@pujagautam4657]

Sir is test me typing test bhi hoga kya....

[@OfficeGuruji]

Yes after Excel Spreadsheet Test..jo bhi qualify karenge unka Stenography test hoga

[@PSCport]

Sr. no. me "." nahi aa rha "1."

[@nayndeep6723]

Agar kisi question me tital heading central allignment hai to us column ka data centre allign rahega ya by default

[@OfficeGuruji]

Agar question me alignment ke liye bola gaya hai to theek hai nahi to aap default settings par bhi set kar sakte hain

[@saurabhsinghnegi6779]

Sir, average salary row me nhi niklegi aapne column banad diya alag se? confusion hai

[@amylintel269]

same doubt

[@OfficeGuruji]

Question silent hai. Jaise sabka alag alag net salary aur expense calculate kiya vaise hi sabki average salary count kar di.

[@saurabhsinghnegi6779]

@@OfficeGuruji ok sir thank you

[@amylintel269]

maine row me try kiya to bohot zyada decimal me aa ra tha......so i think column me hi krna shi hoga....bs ye sb examme on time smjh aa ske to bdhiya😰

[@kartikattari8263]

Sir ek or send kr ra hu question

[@OfficeGuruji]

Aapka first aur last question clear nahi hai. First question me upar se cutting hai and last question me camera stamp aa gaya hai. Please send the clear question paper. Middle question maine karwa diya hai.

[@prisha4721]

Sir hm net salary both yrs ki ik hi column m show kr skte h?

[@OfficeGuruji]

No confusion ho jayegi

[@abhinandanvasudev2026]

Sir average salary net salary ki nikali jayagi na

[@swarnjitsingh1558]

Sir single joint spreadsheet kya hota hai CPT ke notification m likha huya hai k apka test "single joint spreadsheet" based hoga

[@OfficeGuruji]

Joint for Haryana & Punjab ke liye bhi ho sakta hai. May be MS Word se related questions bhi aa sakte hai

[@monikamalik7180]

Sir position ( first, second) ke base par grade nikalna bhi bta dijiye plz

[@OfficeGuruji]

Ok

[@sonikamatth2696]

hlo Sir Aapse ek request h kya aap is video mein jo expense nikale h wo ek baar if k formula se nikal de plzz its a request plzzzzzzzzzzzzzzzz

[@OfficeGuruji]

Ok

[@veerpalkaur9432]

Sir koi advance formula video bna do ji 🙏

[@pushkarkumar5400]

Sir kabhi kabhi descending order mein krta hoon toh side wale column ki value change ho jati h kya wo sahi h

[@OfficeGuruji]

Jab hum sorting karte hai to pure table ki rows change ho jati hain

[@speed-writer]

1 ke baad "dot" de ke autofill kaise kare?? Like, 1. 2. 3.

[@OfficeGuruji]

Excel me dot ko enter karne ki jaroorat nahi hai

[@skasif9831]

🙏

[@ankush1538]

Sir pls thoda hard levl basic ho gya ab bht

[@OfficeGuruji]

Ok

[@SsMoviesclips5817]

sir previous question paper ka pdf provide kijiye

[@OfficeGuruji]

Sabhi videos previous years ke questions ke hisab se hi aa rahi hain

[@speed-writer]

Question incomplete hai... Average salary of "each year" or "each person" mention nahi kiya... Students ko confuse karke shortlisting kiya jaayega 😩

[@umeshchopraa2684]

Absolutely right sane I m thinking just I watch this video.

[@amylintel269]

right 😰😰😰

[@OfficeGuruji]

Yes you are right. Aise hi confusing questions aayenge. You have to think before calculating.

[@munchingmood6707]

Thankyou sir! I also have a sample paper Can i send you via email?

[@OfficeGuruji]

Yes sure

[@nituarora3698]

Sir pta nhi q bt vdo clear nhi dikh rhi kya kru

[@OfficeGuruji]

Video quality ko increase kar lijiye