Basic Microsoft Excel Formulas/ 25 Basic Excel Formulas/ 50 Excel Shortcuts You Need To You

Basic Microsoft Excel Formulas/ 25 Basic Excel Formulas/ 50 Excel Shortcuts You Need to You 

50 Excel Shortcuts /25 Basic Excel Formulas

Basic Microsoft Excel Formulas

S.NO.	FORMULA NAME	FORMULA PATTERN
1	SUM	=SUM(A1:A5)
2	SUM	=(A1+A2+A3+A4+A5)
3	SUM	=(45+4+44+48)
4	PRODUCT	=PRODUCT (F1:F2)
5	PRODUCT	=(B3*B4*B5)
6	PRODUCT	=(34*56)
7	SUBTRACT/MIN IS	=(E3-E4)
8	DIVIDE	=(F3/F4)
9	PERCENTAGE	=(G3/G4*100)
10	MAXIMUM	=MAX(H3:M3)
11	MINIMUM	=MIN(H3:M3)
12	POWER	=POWER(2,4)[24=26]
13	AVERAGE	=AVERAGE(C3:C14)
14	SQUARE ROOT	=SQRT(25)
15	COUNT	=COUNT(C4:P4)
16	COUNT BLANK	=COUNTBLANK(C3:C16)
17	COUNT IF	=COUNTIF(D4:Z4,”P”)
18	CURRENT DATE & TIME	=NOW()
19	TODAYS DATE	=TODAY()
20	DAY# OF CURRENT MONTH	=DAY(NOW())
21	CURRENT MONTH	=MONTH(NOW())
22	CURRENT YEAR	=YEAR(NOW))

MOST IMPORTANT COMPUTER RELETED FULL FORMS/ COMPUTER KNOWLEDGE

MOST IMPORTANT COMPUTER RELETED FULL FORMS/ COMPUTER KNOWLEDGE

कंप्यूटर में रजिस्टर क्या है और कितने प्रकार के होते है?- What is Computer Register in Hindi

 कंप्यूटर में रजिस्टर क्या है और कितने प्रकार के होते है?- What is Computer Register in Hindi

Computer Register in Hindi: दोस्तों, आज के इस पोस्ट में हम आपको कंप्यूटर रजिस्टर के बारें में बताएँगे. इसके साथ साथ रजिस्टर के प्रकार, जरुरत, उपयोग को विस्तार से बताएँगे. पूरी जानकरी के लिए पोस्ट को पूरा जरुर पढ़े.

Compter Shortcuts Keys / windows/ word/ excel/ outlook shortcut keys

 (Compter Shortcuts Keys)

Basic Shortcuts keys: 

Alt + F: File menu option in current program

Alt + E: Edit option in current program

F1:  Universal help for all programs

Ctrl + A: Select All text

Ctrl + X: Cut selected item

Shift + Del: Cut Selected item

Ctrl + C: Copy selected item

Ctrl + Ins: Copy selected item

Ctrl + V: Paste

Ctrl + Ins: Paste

Home: Go to beginning of current line

Ctrl + Home: Go to beginning Document

End: Go to end of line

ctrl + End: Go to end of document

Shift + Home: Highlight from current position to beginning of line

Shift + End: Highlight from current position to end of line

Ctrl + Left Arrow: Move on word to the left at a line

Ctrl + Right Arrow: Move on word to the right at a line