1. MS WORD Shortcut Keys
A. Basic Ctrl Shortcut Keys
| Shortcut Key | Function |
|---|
| Ctrl + A | Select All |
| Ctrl + B | Bold |
| Ctrl + C | Copy |
| Ctrl + D | Open Font Dialog Box |
| Ctrl + E | Center Align |
| 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 Document |
| Ctrl + P | Print |
| Ctrl + Q | Remove Paragraph Formatting |
| Ctrl + R | Right Align |
| Ctrl + S | Save |
| Ctrl + T | Create Hanging Indent |
| Ctrl + U | Underline |
| Ctrl + V | Paste |
| Ctrl + W | Close Document |
| Ctrl + X | Cut |
| Ctrl + Y | Redo |
| Ctrl + Z | Undo |
B. Ctrl + Shift Shortcut Keys
| Shortcut Key | Function |
|---|
| Ctrl + Shift + A | All Caps |
| Ctrl + Shift + D | Double Underline |
| Ctrl + Shift + E | Track Changes |
| Ctrl + Shift + F | Change Font |
| Ctrl + Shift + G | Word Count |
| Ctrl + Shift + H | Apply Hidden Text |
| Ctrl + Shift + K | Small Caps |
| Ctrl + Shift + L | Apply Bulleted List |
| Ctrl + Shift + M | Decrease Indent |
| Ctrl + Shift + N | Apply Normal Style |
| Ctrl + Shift + P | Change Font Size |
| Ctrl + Shift + Q | Change Font to Symbol |
| Ctrl + Shift + S | Apply Styles |
| Ctrl + Shift + T | Reduce Hanging Indent |
| Ctrl + Shift + V | Paste Text Only |
| Ctrl + Shift + W | Underline Words Only |
| Ctrl + Shift + > | Increase Font Size |
| Ctrl + Shift + < | Decrease Font Size |
| Ctrl + Shift + 8 | Show/Hide Formatting Marks |
C. Ctrl + Alt Shortcut Keys
| Shortcut Key | Function |
|---|
| Ctrl + Alt + 1 | Apply Heading 1 |
| Ctrl + Alt + 2 | Apply Heading 2 |
| Ctrl + Alt + 3 | Apply Heading 3 |
| Ctrl + Alt + M | Insert Comment |
| Ctrl + Alt + N | Draft View |
| Ctrl + Alt + O | Outline View |
| Ctrl + Alt + P | Print Layout View |
| Ctrl + Alt + S | Split Window |
| Ctrl + Alt + V | Paste Special |
| Ctrl + Alt + F | Insert Footnote |
| Ctrl + Alt + D | Insert Endnote |
| Ctrl + F9 | Insert Field |
D. Alt Shortcut Keys
| Shortcut Key | Function |
|---|
| Alt + F | Open File Menu |
| Alt + H | Open Home Tab |
| Alt + N | Open Insert Tab |
| Alt + G | Open Design Tab |
| Alt + P | Open Layout Tab |
| Alt + S | Open References Tab |
| Alt + M | Open Mailings Tab |
| Alt + R | Open Review Tab |
| Alt + W | Open View Tab |
| Alt + Q | Search Commands |
| Alt + F1 | Move to Next Field |
| Alt + F3 | Create AutoText |
| Alt + F4 | Close Word |
| Alt + F7 | Find Next Spelling Error |
| Alt + F8 | Open Macro Dialog Box |
| Alt + F9 | Toggle Field Codes |
| Alt + F10 | Open Selection Pane |
| Alt + F11 | Open VBA Editor |
| Alt + Shift + D | Insert Current Date |
| Alt + Shift + T | Insert Current Time |
| Alt + Ctrl + 1 | Apply Heading 1 |
| Alt + Ctrl + 2 | Apply Heading 2 |
| Alt + Ctrl + 3 | Apply Heading 3 |
Note: Alt + letter tab shortcuts depend on the Office version and language.
E. Function Keys (F1–F12)
| Key | Function |
|---|
| F1 | Open Help |
| F2 | Move Selected Text or Object |
| F3 | Insert AutoText |
| F4 | Repeat Last Action |
| F5 | Open Go To |
| F6 | Move to Next Pane |
| F7 | Spelling and Grammar Check |
| F8 | Extend Selection |
| F9 | Update Selected Fields |
| F10 | Activate Menu Key Tips |
| F11 | Move to Next Field |
| F12 | Save As |
F. Shift + Function Keys
| Shortcut Key | Function |
|---|
| Shift + F1 | Reveal Formatting |
| Shift + F2 | Copy Selected Text |
| Shift + F3 | Change Case |
| Shift + F4 | Repeat Find or Go To |
| Shift + F5 | Move to Previous Edit |
| Shift + F6 | Move to Previous Pane |
| Shift + F7 | Thesaurus |
| Shift + F8 | Shrink Selection |
| Shift + F9 | Toggle Field Code |
| Shift + F10 | Open Context Menu |
| Shift + F11 | Move to Previous Field |
| Shift + F12 | Save Document |
G. Ctrl + Function Keys
| Shortcut Key | Function |
|---|
| Ctrl + F1 | Show/Hide Ribbon |
| Ctrl + F2 | Print Preview |
| Ctrl + F3 | Cut to Spike |
| Ctrl + F4 | Close Document |
| Ctrl + F5 | Restore Document Window |
| Ctrl + F6 | Switch to Next Document |
| Ctrl + F7 | Move Window |
| Ctrl + F8 | Resize Window |
| Ctrl + F9 | Insert Field |
| Ctrl + F10 | Maximize/Restore Window |
| Ctrl + F11 | Lock Field |
| Ctrl + F12 | Open Document |
H. Editing and Navigation Shortcuts
| Shortcut Key | Function |
|---|
| Home | Beginning of Line |
| End | End of Line |
| Ctrl + Home | Beginning of Document |
| Ctrl + End | End of Document |
| Ctrl + Left Arrow | Previous Word |
| Ctrl + Right Arrow | Next Word |
| Ctrl + Up Arrow | Previous Paragraph |
| Ctrl + Down Arrow | Next Paragraph |
| Ctrl + Backspace | Delete Previous Word |
| Ctrl + Delete | Delete Next Word |
| Shift + Delete | Cut Selected Text |
| Shift + Insert | Paste |
| Ctrl + Insert | Copy |
| Shift + F10 | Context Menu |
| Page Up | Move One Screen Up |
| Page Down | Move One Screen Down |
I. Formatting Shortcuts
| Shortcut Key | Function |
|---|
| Ctrl + 1 | Single Line Spacing |
| Ctrl + 2 | Double Line Spacing |
| Ctrl + 5 | 1.5 Line Spacing |
| Ctrl + 0 | Add/Remove Space Before Paragraph |
| Ctrl + [ | Decrease Font Size by 1 Point |
| Ctrl + ] | Increase Font Size by 1 Point |
| Ctrl + = | Subscript |
| Ctrl + Shift + = | Superscript |
| Ctrl + Spacebar | Remove Character Formatting |
| Ctrl + Shift + 8 | Show/Hide Formatting Marks |
J. Document and Page Shortcuts
| Shortcut Key | Function |
|---|
| Ctrl + Enter | Page Break |
| Shift + Enter | Line Break |
| Ctrl + Shift + Enter | Column Break |
| Ctrl + Alt + F | Insert Footnote |
| Ctrl + Alt + D | Insert Endnote |
| Ctrl + S | Save |
| F12 | Save As |
| Ctrl + P | Print |
| Ctrl + W | Close Document |
K. Text Selection Shortcuts
| Shortcut Key | Function |
|---|
| Shift + Right Arrow | Select One Character Right |
| Shift + Left Arrow | Select One Character Left |
| Ctrl + Shift + Right Arrow | Select Next Word |
| Ctrl + Shift + Left Arrow | Select Previous Word |
| Shift + Home | Select to Beginning of Line |
| Shift + End | Select to End of Line |
| Ctrl + Shift + Home | Select to Beginning of Document |
| Ctrl + Shift + End | Select to End of Document |
| Shift + Up Arrow | Select One Line Up |
| Shift + Down Arrow | Select One Line Down |
2. MS EXCEL Shortcut Keys
A. Basic Ctrl Shortcut Keys
| Shortcut Key | Function |
|---|
| Ctrl + A | Select All |
| Ctrl + B | Bold |
| Ctrl + C | Copy |
| Ctrl + D | Fill Down |
| Ctrl + E | Flash Fill |
| Ctrl + F | Find |
| Ctrl + G | Go To |
| Ctrl + H | Replace |
| Ctrl + I | Italic |
| Ctrl + K | Insert Hyperlink |
| Ctrl + N | New Workbook |
| Ctrl + O | Open Workbook |
| Ctrl + P | Print |
| Ctrl + R | Fill Right |
| Ctrl + S | Save |
| Ctrl + T | Create Table |
| Ctrl + U | Underline |
| Ctrl + V | Paste |
| Ctrl + W | Close Workbook |
| Ctrl + X | Cut |
| Ctrl + Y | Redo |
| Ctrl + Z | Undo |
| Ctrl + 1 | Format Cells |
| Ctrl + 2 | Bold |
| Ctrl + 3 | Italic |
| Ctrl + 4 | Underline |
| Ctrl + 5 | Strikethrough |
| Ctrl + 6 | Show/Hide Objects |
| Ctrl + 8 | Show/Hide Outline Symbols |
| Ctrl + 9 | Hide Selected Rows |
| Ctrl + 0 | Hide Selected Columns |
B. Ctrl + Shift Shortcut Keys
| Shortcut Key | Function |
|---|
| Ctrl + Shift + L | Apply/Remove Filter |
| Ctrl + Shift + 1 | Number Format |
| Ctrl + Shift + 2 | Time Format |
| Ctrl + Shift + 3 | Date Format |
| Ctrl + Shift + 4 | Currency Format |
| Ctrl + Shift + 5 | Percentage Format |
| Ctrl + Shift + 6 | Scientific Format |
| Ctrl + Shift + 7 | Apply Outline Border |
| Ctrl + Shift + 8 | Select Current Region |
| Ctrl + Shift + 9 | Unhide Rows |
| Ctrl + Shift + 0 | Unhide Columns* |
| Ctrl + Shift + + | Insert Cells/Rows/Columns |
| Ctrl + Shift + – | Delete Cells/Rows/Columns |
| Ctrl + Shift + ; | Insert Current Time |
| Ctrl + Shift + “ | Copy Value from Cell Above |
| Ctrl + Shift + U | Expand/Collapse Formula Bar |
| Ctrl + Shift + Arrow Key | Select Cells to Edge of Data |
*Unhide Columns may be disabled by Windows regional keyboard settings.
C. Alt Shortcut Keys
| Shortcut Key | Function |
|---|
| Alt | Display Ribbon Key Tips |
| Alt + Enter | Start a New Line in a Cell |
| Alt + = | AutoSum |
| Alt + F1 | Insert Embedded Chart |
| Alt + F2 | Save As |
| Alt + F4 | Close Excel |
| Alt + F8 | Open Macro Dialog Box |
| Alt + F11 | Open VBA Editor |
| Alt + Down Arrow | Open Drop-Down List |
| Alt + Page Down | Move One Screen Right |
| Alt + Page Up | Move One Screen Left |
D. Function Keys (F1–F12)
| Key | Function |
|---|
| F1 | Open Help |
| F2 | Edit Active Cell |
| F3 | Paste Name |
| F4 | Repeat Last Action / Change Cell Reference |
| F5 | Open Go To |
| F6 | Switch Between Worksheet, Ribbon and Task Panes |
| F7 | Spelling Check |
| F8 | Extend Selection |
| F9 | Calculate All Open Workbooks |
| F10 | Activate Menu Key Tips |
| F11 | Create Chart on Separate Chart Sheet |
| F12 | Save As |
E. Shift + Function Keys
| Shortcut Key | Function |
|---|
| Shift + F2 | Insert/Edit Note |
| Shift + F3 | Insert Function |
| Shift + F4 | Repeat Find |
| Shift + F5 | Find |
| Shift + F6 | Switch to Previous Pane |
| Shift + F8 | Add to Selection |
| Shift + F9 | Calculate Active Worksheet |
| Shift + F10 | Open Context Menu |
| Shift + F11 | Insert New Worksheet |
| Shift + F12 | Save Workbook |
F. Ctrl + Function Keys
| Shortcut Key | Function |
|---|
| Ctrl + F1 | Show/Hide Ribbon |
| Ctrl + F2 | Open Print Preview |
| Ctrl + F3 | Open Name Manager |
| Ctrl + F4 | Close Workbook |
| Ctrl + F5 | Restore Workbook Window |
| Ctrl + F6 | Switch to Next Workbook |
| Ctrl + F7 | Move Workbook Window |
| Ctrl + F8 | Resize Workbook Window |
| Ctrl + F9 | Minimize Workbook Window |
| Ctrl + F10 | Maximize/Restore Workbook Window |
| Ctrl + F11 | Insert Macro Sheet |
| Ctrl + F12 | Open Workbook |
G. Editing and Navigation Shortcuts
| Shortcut Key | Function |
|---|
| Home | Beginning of Row |
| Ctrl + Home | Beginning of Worksheet (A1) |
| Ctrl + End | Last Used Cell |
| Ctrl + Left Arrow | Move to Left Edge of Data Region |
| Ctrl + Right Arrow | Move to Right Edge of Data Region |
| Ctrl + Up Arrow | Move to Top of Data Region |
| Ctrl + Down Arrow | Move to Bottom of Data Region |
| Page Up | Move One Screen Up |
| Page Down | Move One Screen Down |
| Ctrl + Page Up | Previous Worksheet |
| Ctrl + Page Down | Next Worksheet |
| Ctrl + Spacebar | Select Entire Column |
| Shift + Spacebar | Select Entire Row |
| Ctrl + Backspace | Scroll to Active Cell |
| Delete | Clear Cell Contents |
| Esc | Cancel Entry |
H. Formatting Shortcuts
| Shortcut Key | Function |
|---|
| Ctrl + 1 | Open Format Cells Dialog Box |
| Ctrl + B | Bold |
| Ctrl + I | Italic |
| Ctrl + U | Underline |
| Ctrl + 5 | Strikethrough |
| Ctrl + Shift + ! | Apply Number Format |
| Ctrl + Shift + $ | Apply Currency Format |
| Ctrl + Shift + % | Apply Percentage Format |
| Ctrl + Shift + # | Apply Date Format |
| Ctrl + Shift + @ | Apply Time Format |
| Ctrl + Shift + ^ | Apply Scientific Format |
| Ctrl + Shift + & | Apply Outline Border |
| Ctrl + Shift + _ | Remove Outline Border |
I. Data and Formula Shortcuts
| Shortcut Key | Function |
|---|
| F2 | Edit Active Cell |
| F4 | Change Absolute/Relative Cell Reference |
| Alt + = | AutoSum |
| Ctrl + ` | Show/Hide Formulas |
| Ctrl + ; | Insert Current Date |
| Ctrl + Shift + ; | Insert Current Time |
| Ctrl + ‘ | Copy Formula from Cell Above |
| Ctrl + D | Fill Down |
| Ctrl + R | Fill Right |
| Ctrl + T | Create Table |
| Ctrl + Shift + L | Apply Filter |
| Shift + F3 | Insert Function |
| F9 | Calculate All Worksheets |
| Shift + F9 | Calculate Active Worksheet |
J. Cell Selection Shortcuts
| Shortcut Key | Function |
|---|
| Shift + Right Arrow | Select One Cell Right |
| Shift + Left Arrow | Select One Cell Left |
| Shift + Up Arrow | Select One Cell Up |
| Shift + Down Arrow | Select One Cell Down |
| Ctrl + Shift + Right Arrow | Select to Right Edge of Data |
| Ctrl + Shift + Left Arrow | Select to Left Edge of Data |
| Ctrl + Shift + Up Arrow | Select to Top of Data |
| Ctrl + Shift + Down Arrow | Select to Bottom of Data |
| Ctrl + A | Select Current Data Region / All |
| Ctrl + Spacebar | Select Entire Column |
| Shift + Spacebar | Select Entire Row |
MS WORD
| No. | Question | Answer |
|---|
| 1 | Which tab contains Font options? | Home |
| 2 | Which tab contains Find and Replace? | Home |
| 3 | Which tab contains WordArt? | Insert |
| 4 | Which tab contains Page Number? | Insert |
| 5 | Which tab contains SmartArt? | Insert |
| 6 | Which tab contains Text Box? | Insert |
| 7 | Which tab contains Watermark? | Design |
| 8 | Which tab contains Page Borders? | Design |
| 9 | Which tab contains Margins? | Layout |
| 10 | Which tab contains Columns? | Layout |
| 11 | Which tab contains Orientation? | Layout |
| 12 | Which tab contains Table of Contents? | References |
| 13 | Which tab contains Mail Merge? | Mailings |
| 14 | Which tab contains Spelling & Grammar? | Review |
| 15 | Which tab contains Thesaurus? | Review |
| 16 | Which tab contains Word Count? | Review |
| 17 | Which tab contains Track Changes? | Review |
| 18 | Which tab contains Ruler? | View |
| 19 | Which tab contains Navigation Pane? | View |
| 20 | Which tab contains Macros? | View |