Ms Office And Shortcuts MCQs
High-yield multiple choice questions asked in previous years (UPSC, SSC CGL, JKSSB, RRB & State PSCs).
High-Yield Concept Capsule & Key Facts
📌 Core practical computing segment in IBPS RRB PO/Clerk, SSC CGL Tier-2, JKSSB Junior Assistant, and Railway exams.
MS Word & Formatting Commands
- • Font Formatting: Ctrl+B (Bold), Ctrl+I (Italic), Ctrl+U (Underline), Ctrl+Shift+> (Increase font size), Ctrl+] (Grow font by 1pt), Ctrl+Shift+< (Decrease font size).
- • Paragraph Alignment: Ctrl+L (Left align), Ctrl+R (Right align), Ctrl+E (Center align), Ctrl+J (Justify align). Line spacing: Ctrl+1 (Single), Ctrl+2 (Double), Ctrl+5 (1.5 lines).
- • Document Navigation & Editing: Ctrl+H (Find & Replace), Ctrl+F (Find/Navigation Pane), Ctrl+K (Insert Hyperlink), F7 (Spelling and Grammar check), Shift+F7 (Thesaurus synonym lookup), Ctrl+Enter (Insert Page Break).
MS Excel Formulas & MS PowerPoint Shortcuts
- • Excel Cell Navigation & Referencing: F2 (Edit active cell), F4 (Toggle absolute/relative referencing $A$1), Shift+F3 (Insert Function), Ctrl+; (Insert current date), Ctrl+Shift+; (Insert current time), Alt+= (AutoSum formula =SUM()).
- • Excel Grid Mechanics: A standard Excel sheet has 1,048,576 rows and 16,384 columns (last column is XFD). Intersection of row and column is a 'Cell'.
- • PowerPoint Slideshow Controls: F5 (Start slide show from beginning), Shift+F5 (Start slide show from current slide), Ctrl+M (Insert new slide), Ctrl+N (Create new presentation file), Esc (End slide show), B/W (Black/White screen during slide show).
| Shortcut Key | MS Word Function | MS Excel Function | MS PowerPoint Function |
|---|---|---|---|
| F5 | Go To dialog | Go To cell dialog | Start Slide Show from beginning |
| Shift + F5 | Go to last edit location | Find previous search | Start Slide Show from current slide |
| Ctrl + M | Increase hanging indent | N/A | Insert a New Blank Slide |
| Ctrl + K | Insert Hyperlink | Insert Hyperlink | Insert Hyperlink |
| F7 | Spelling & Grammar check | Spelling check | Spelling check |
| Shift + F7 | Thesaurus (Synonyms) | Thesaurus | Thesaurus |
Which function key is pressed in MS Word to initiate the Spelling and Grammar check across the document?
What is the keyboard shortcut to insert a new slide into an existing MS PowerPoint presentation?
In MS Excel, what is the shortcut key combination to automatically insert the AutoSum formula for a selected column of numbers?
What is the total maximum number of rows available in a single worksheet in modern versions of Microsoft Excel (.xlsx)?
Which shortcut key combination is used to center-align the selected paragraph in Microsoft Word?
What is the universal shortcut key across MS Word, Excel, and PowerPoint to open the 'Insert Hyperlink' dialog box?
In MS Excel, pressing the F2 key allows the user to:
Which shortcut key starts a PowerPoint slide show presentation from the currently active slide rather than from the beginning?
What formula symbol is used in MS Excel to lock a row or column into an absolute cell reference?
Which shortcut combination opens the 'Find and Replace' dialog box with the Replace tab active in MS Word?
In Microsoft Excel, what is the shortcut key to insert the current system date into the selected cell?
What is the function of the shortcut key combination 'Ctrl + Shift + >' in Microsoft Word?
Which view in Microsoft PowerPoint is best suited for reordering, reorganizing, and applying slide transitions to multiple slides simultaneously?
In MS Excel, what does the formula error '#DIV/0!' signify?
What is the shortcut key to insert a manual Page Break in Microsoft Word?
Frequently Asked Questions (Ms Office And Shortcuts)
Q: What is the difference between pressing F5 and Shift+F5 in Microsoft PowerPoint?
In MS PowerPoint, pressing F5 launches the slide show presentation from the very first slide (Slide 1), whereas pressing Shift+F5 launches the slide show directly from the currently active slide.
Q: What is the keyboard shortcut to insert a hard Page Break in MS Word?
Pressing Ctrl + Enter inserts a manual Page Break immediately at the current cursor position in MS Word.
Q: How do you cycle between relative and absolute cell references in MS Excel?
While editing a formula in the formula bar, pressing the F4 function key cycles through absolute referencing ($A$1), mixed row-locked referencing (A$1), mixed column-locked referencing ($A1), and relative referencing (A1).
Explore More Computer Awareness & ICT Topics
Ready to test your speed under real exam conditions?
Attempt timed full-length CBT tests with negative marking and percentile analysis.