Computer / Excel / MS Word Shortcuts

Zero Level → SSC CGL, CHSL, CPO, Banking, Railway (हिंदी)

SSC CGL Tip: Computer Awareness में अक्सर Keyboard Shortcuts, MS Office, Internet, और Basic Computer से प्रश्न पूछे जाते हैं।

---

PART 1: Keyboard Shortcuts (Most Important)

Shortcut	Function
Ctrl + A	Select All
Ctrl + B	Bold
Ctrl + C	Copy
Ctrl + D	Font Dialog (MS Word)
Ctrl + F	Find
Ctrl + G	Go To
Ctrl + H	Replace
Ctrl + I	Italic
Ctrl + J	Justify
Ctrl + K	Insert Hyperlink
Ctrl + L	Left Align
Ctrl + M	Increase Indent
Ctrl + N	New Document
Ctrl + O	Open
Ctrl + P	Print
Ctrl + R	Right Align
Ctrl + S	Save
Ctrl + U	Underline
Ctrl + V	Paste
Ctrl + X	Cut
Ctrl + Y	Redo
Ctrl + Z	Undo

याद रखने की ट्रिक

“ABC = All, Bold, Copy”

• A = Select All
• B = Bold
• C = Copy

---

PART 2: Function Keys (F1–F12)

Key	Function
F1	Help
F2	Rename File
F3	Search
F4	Address Bar (Alt+F4 = Close Window)
F5	Refresh
F6	Move Between Screen Elements
F7	Spelling & Grammar (Word)
F8	Boot Menu (कुछ सिस्टम में)
F9	Refresh Fields (Word)
F10	Menu Bar
F11	Full Screen (Browser)
F12	Save As (Word)

ट्रिक

“1 Help – 2 Rename – 3 Search – 5 Refresh – 7 Spelling – 11 Full Screen – 12 Save As”

---

PART 3: Windows Shortcuts

Shortcut	Function
Win + D	Desktop दिखाएँ
Win + E	File Explorer
Win + L	Lock Computer
Win + R	Run Dialog
Win + I	Settings
Win + Tab	Task View
Win + Shift + S	Screenshot
Alt + Tab	Switch Windows
Alt + F4	Close Window
Ctrl + Shift + Esc	Task Manager

---

PART 4: MS Word Shortcuts

Shortcut	Function
Ctrl + N	New Document
Ctrl + O	Open
Ctrl + S	Save
Ctrl + P	Print
Ctrl + B	Bold
Ctrl + I	Italic
Ctrl + U	Underline
Ctrl + E	Center Align
Ctrl + L	Left Align
Ctrl + R	Right Align
Ctrl + J	Justify
Ctrl + Shift + >	Increase Font Size
Ctrl + Shift + <	Decrease Font Size
Ctrl + Enter	Page Break
Shift + F3	Change Case

---

PART 5: MS Excel Shortcuts

Shortcut	Function
F2	Edit Cell
Ctrl + ;	Current Date
Ctrl + Shift + ;	Current Time
Ctrl + Arrow	Move to Data Edge
Ctrl + Home	Cell A1
Ctrl + End	Last Used Cell
Ctrl + Space	Select Column
Shift + Space	Select Row
Ctrl + Page Up	Previous Sheet
Ctrl + Page Down	Next Sheet
Alt + =	AutoSum
Ctrl + `	Show/Hide Formulas

---

Excel Important Formulas

Formula	Purpose
=SUM()	Addition
=AVERAGE()	Average
=MAX()	Largest Value
=MIN()	Smallest Value
=COUNT()	Count Numbers
=COUNTA()	Count Non-Blank Cells
=IF()	Conditional Result
=ROUND()	Round Number
=TODAY()	Current Date
=NOW()	Current Date & Time

Example

=SUM(A1:A10)

Adds values from A1 to A10.

---

PART 6: MS PowerPoint Shortcuts

Shortcut	Function
F5	Start Slide Show
Shift + F5	Slide Show from Current Slide
Ctrl + M	New Slide
Ctrl + D	Duplicate Slide
Ctrl + K	Hyperlink
B	Black Screen During Presentation
W	White Screen During Presentation
Esc	End Slide Show

---

PART 7: Internet Shortcuts

Shortcut	Function
Ctrl + T	New Tab
Ctrl + W	Close Tab
Ctrl + Shift + T	Reopen Closed Tab
Ctrl + Tab	Next Tab
Ctrl + L	Address Bar
Ctrl + D	Bookmark Page
Ctrl + +	Zoom In
Ctrl + –	Zoom Out
Ctrl + 0	Reset Zoom

---

PART 8: Basic Computer Questions

Full Forms

Term	Full Form
CPU	Central Processing Unit
RAM	Random Access Memory
ROM	Read Only Memory
USB	Universal Serial Bus
HDD	Hard Disk Drive
SSD	Solid State Drive
LAN	Local Area Network
WAN	Wide Area Network
WWW	World Wide Web
URL	Uniform Resource Locator

---

PART 9: Memory Devices

Device	Type
RAM	Primary Memory
ROM	Primary Memory
Hard Disk	Secondary Memory
SSD	Secondary Memory
CD/DVD	Optical Storage
Pen Drive	Flash Storage

---

SSC CGL Computer Golden Facts

• CPU → Computer का Brain
• RAM → Volatile Memory
• ROM → Non-Volatile Memory
• 1 Byte = 8 Bits
• 1024 Bytes = 1 KB
• 1024 KB = 1 MB
• 1024 MB = 1 GB
• 1024 GB = 1 TB

---

30 Practice Questions

Keyboard Shortcuts

1. Ctrl + C = ?
2. Ctrl + V = ?
3. Ctrl + Z = ?
4. Ctrl + Y = ?
5. Ctrl + A = ?

Word

6. Ctrl + B = ?
7. Ctrl + U = ?
8. Ctrl + J = ?
9. Shift + F3 = ?
10. Ctrl + Enter = ?

Excel

11. Formula for Addition?
12. Formula for Average?
13. F2 Key?
14. Alt + = ?
15. Ctrl + Home?

Basic Computer

16. CPU Full Form?
17. RAM Type?
18. ROM Type?
19. 1 Byte = ?
20. 1 GB = ?

Internet

21. Ctrl + T?
22. Ctrl + W?
23. Ctrl + Shift + T?
24. Ctrl + L?
25. Ctrl + D?

Windows

26. Win + E?
27. Win + R?
28. Win + L?
29. Alt + Tab?
30. Ctrl + Shift + Esc?

---

Answer Key

1. Copy
2. Paste
3. Undo
4. Redo
5. Select All
6. Bold
7. Underline
8. Justify
9. Change Case
10. Page Break
11. =SUM()
12. =AVERAGE()
13. Edit Active Cell
14. AutoSum
15. Go to Cell A1
16. Central Processing Unit
17. Primary, Volatile Memory
18. Primary, Non-Volatile Memory
19. 8 Bits
20. 1024 MB
21. New Tab
22. Close Tab
23. Reopen Closed Tab
24. Address Bar
25. Bookmark
26. File Explorer
27. Run Dialog
28. Lock Computer
29. Switch Windows
30. Task Manager

---

15-Day Computer Study Plan

Days	Topic
1–2	Basic Computer Fundamentals
3–4	Keyboard & Windows Shortcuts
5–6	MS Word
7–9	MS Excel (Shortcuts + Formulas)
10	MS PowerPoint
11	Internet & Networking Basics
12	Memory Devices & Storage
13	Full Forms & Computer Abbreviations
14	SSC Previous Year Computer Questions
15	Full Revision + Mock Test

Golden SSC CGL Strategy

• ⌨️ रोज़ 10–15 Keyboard Shortcuts याद करें और कंप्यूटर पर उनका अभ्यास करें।
• 📊 Excel के कम से कम 10 बेसिक फ़ॉर्मूले (SUM, AVERAGE, IF, COUNT आदि) का अभ्यास करें।
• 📄 MS Word में Formatting और Alignment के शॉर्टकट इस्तेमाल करके देखें।
• ❓ 20–30 Computer Awareness MCQs प्रतिदिन हल करें।
• 🔁 सप्ताह में एक बार सभी शॉर्टकट और फुल फॉर्म का रिवीजन करें।

इस तरह पढ़ने से शॉर्टकट केवल रटे हुए नहीं रहेंगे, बल्कि परीक्षा और वास्तविक कंप्यूटर उपयोग—दोनों में आसानी से याद आएँगे।