MICROSOFT EXCEL FORMULA Basic Maths Functions Function Formula Example To add up the total =SUM(cell range ) =SUM(B2:B9) To add…
BASIC EXCEL FORMULAS 1 SUM =SUM(A1:A5) 2 SUM =(A1+A2+A3+A4+A5) 3 SUM =(45+2+43+48) 4 PRODUCT =PRODUCT(F1:F2) 5 PRODUCT =(34*65) 6 SUBTRACT…
COMPUTER SHORTCUT KEYS IN MS OFFICE AND WINDOWS WORD SHORTCUT KEYS EXCEL SHORTCUT KEYS CTRL +A SELECT ALL CONTENTS OF…
EXCEL SHORTCUTS KEY’S FUCTION KEYS SHORTCUT Action SHORTCUT Action F1 Help / सहायता SHIFT +F4 Find next F2 Edit…
BASIC EXCEL FORMULA FORMULA NAME FORMULA PATTERN SUM =SUM (A1:A5) SUM =(A1+A2+A3+A4+A5) SUM =(45+2+43+48) PRODUCT =PRODUCT(F1:F2) PRODUCT =(B3*B4*85 PRODUCT =(34*65)…
MICROSOFT POWER POINT SHORTCUT KEYS Save presentation CTRL + S Print a presentation CTRL +P Create a new presentation CTRL…