MS Excel  Formulas

Multiple Copy – Select & Hold Ctrl & Drag Anywhere

Clipboard -  Use Clipboard For Multiple Copy

Chart – Alt+F1

Multiple Copy Chart -  Drag Chart & Hold Both Ctrl & Left Click then release left click

File Location -  =cell(“filename”)

Show Formula – Ctrl+ ~

Sum –

How to find percentage if you have 286 marks out of 600?

Sol- 286*100/600 = 47%

Percentage –

Sumif – Mohit naam ke jitne Student hain unke Number

Count – Count only count numbers not letters

Vlookup -  Ram Ke Internet Ke Number

Average Formula -  

IF – Student Grade

Countif – Karan naam ke ladko ki ginti

Kitne ladko ke “47” number aaye hai unki ginti

·       Tips – Use Fx (Function Arguments) For Formula