A B C D E F
English Sindhi Urdu Maths Computer Total
56 85 90 78 70 379
bas es tarah se column mein marks likh ke agar aap chahto column barha sakte ho kam bhi kar sakte ho,
Now total kaaren sab se pehla column choose karen English paper ki marks jo A column main aap ko nazar aa rahi hai os ki second (2) Row hain aur ab aap column ke last subject wala count karenge, last column mein subject Computer hai aur E column hai aur ki row bhi second (2) hai.
ab hum sab ko formula laga ke total karenge jaisa ke aap dekh rahe hai ko Total F wale column mein likha huwa hai aur hum os ke neeche second (2) row comuter ki marks ke sanme formula lagayenge.
=SUM(A2:E2) Enter
es formula se A column se le kar E column tak marks add karenga, total ka dosra bhi formula hai.
=SUM(A2+B2+C2+D2+E2) enter
es formula mein column by column add kiya gaya hai jitne column ho bas wo likh ke + ki symbol dete jao aur braket mein band kar ke enter karo to marks total kar dega.
aap ki knowledge mein aur bhi izafa karne ja raha hoon.
Excel mein Columns 256
65536 Rows.
aur jab hum 256x65536 karenge to es ka answer ye aayega 1,67,77,216 jo ke yeh Cells hain.
aur Excel mein last column IV hai. os ka shortcut ctrl+right arrow hai.
_________________________________________________________________________________
Excel mein Per% kaise niklate hain akasar hum marks ko percentage nikalte hain.
aap ko bas yeh dekhana hai ke total marks kis column mein hain aur row kon si hai Obtained/ Total H column main hai aur row 3 hain to to hum formula es tarah se likhenge
=sum(H3*100/500).
* ye multiplication ka symbol hai es ke 100 likhna hai os k baad ye /divide ki symbol deni hai phir jitne total marks hai wo likhen 600 ho ya 800 ho, wo likhen.
aik aur bhi per% formula share kar raha hoon.
=sum(353*100/400)
es formula mein hum ne total column nahen likha hai ke kis mein hai direct hum ne marks likhi hai jo aap ne li hai os ke same formula hai aap ko opar bataya gaya hai.
