PART 1: Microsoft Word (Word Processing)
1. Interface Fundamentals & Specifications
- Title Bar: Displays default document name (e.g.,
Document1).
- Quick Access Toolbar: Standard toolbar containing quick actions (Save, Undo, Redo).
- Status Bar: Bottom bar displaying Page Number, Word Count, Language, and Zoom Controls.
- Zoom Range: 10% to 500% (Default: 100%).
- File Extensions:
.docx — Default XML format since Word 2007..doc — Legacy binary format (Word 2003 and earlier)..dotx — Word Template document.
2. Ribbon Tabs & Group Breakdown
| Ribbon Tab |
Key Groups & Features |
| Home | Clipboard (Format Painter), Font (Subscript, Superscript, Change Case), Paragraph (Alignments, Indents, Line Spacing), Editing (Find, Replace). |
| Insert | Cover Page, Page Break, Tables, Pictures, SmartArt, Header & Footer, Drop Cap, Symbols & Equations. |
| Layout | Margins, Orientation (Portrait/Landscape), Page Size, Columns, Indent, Spacing. |
| References | Table of Contents, Footnotes & Endnotes, Citations, Index. |
| Mailings | Envelopes, Labels, Start Mail Merge, Select Recipients, Insert Merge Field. |
| Review | Spelling & Grammar (F7), Thesaurus (Shift+F7), Word Count, Track Changes, Comments. |
| View | Document Views, Show/Hide (Ruler, Gridlines), Zoom, Macros (Alt+F8). |
3. Formatting & Special Features
- Text Alignments: Left (
Ctrl+L - Default), Center (Ctrl+E), Right (Ctrl+R), Justify (Ctrl+J).
- Gutter Margin: Extra spacing added to the binding side (left/top) of a document to prevent text coverage during binding.
- Drop Cap: Enlarges the first letter of a paragraph to drop down multiple lines. Default: 3 lines (Maximum: 10 lines).
- Footnote vs Endnote:
- Footnote: Placed at the bottom of the current page (
Alt+Ctrl+F).
- Endnote: Placed at the very end of the document (
Alt+Ctrl+D).
- Wavy Line Indicators:
- Red Wavy Line: Spelling error.
- Blue / Green Wavy Line: Grammar / Contextual error.
4. Essential MS Word Keyboard Shortcuts
| Shortcut Key |
Function |
Shortcut Key |
Function |
Ctrl + N | New Document | Ctrl + Enter | Insert Page Break |
F12 | Save As Dialog Box | Shift + Enter | Soft Return (Line Break) |
Ctrl + H | Find & Replace | Ctrl + [ / ] | Decrease / Increase Font by 1pt |
Ctrl + K | Insert Hyperlink | Ctrl + Spacebar | Clear All Formatting |
Ctrl + D | Font Dialog Box | F7 | Spelling & Grammar Check |
Ctrl + = | Subscript (H2O) | Shift + F7 | Thesaurus (Synonyms) |
Ctrl + Shift + + | Superscript (X2) | Alt + F8 | Macros Window |
PART 2: Microsoft Excel (Spreadsheet Processing)
1. Grid Architecture & Limits
Modern Excel (.xlsx) Grid Specifications:
• Total Rows per Sheet: 1,048,576
• Total Columns per Sheet: 16,384 (First: A, Last: XFD)
• Zoom Range: 10% to 400% (Default: 100%)
- Cell: Intersection of a Row and Column (e.g.,
B5).
- Name Box: Displays the cell address of the currently active cell.
- Formula Bar: Displays the actual formula or data content of the active cell.
- File Extensions:
.xlsx (Default), .xls (Legacy 2003), .xlsm (Macro Enabled), .csv (Comma Separated Values).
2. Cell Referencing System
- Relative Reference (
A1): Default mode; adjusts address automatically when copied across cells.
- Absolute Reference (
$A$1): Uses dollar signs to completely lock column and row references when copied.
- Mixed Reference (
$A1 or A$1): Locks either the column or row specifically.
- Toggle Shortcut: Highlight reference in formula and press
F4.
3. High-Frequency Formulas & Syntax Rules
Golden Rule: Every Excel formula MUST start with an equals sign (=).
=SUM(A1:A10) — Adds all numbers in specified range.=AVERAGE(A1:A10) — Calculates arithmetic mean.=COUNT(A1:A10) — Counts cells containing numbers only.=COUNTA(A1:A10) — Counts all non-empty cells (numbers + text).=COUNTIF(range, criteria) — Counts cells meeting a specific condition.=IF(logical_test, value_if_true, value_if_false) — Conditional logical statement.=VLOOKUP(lookup_val, table_array, col_index, [range_lookup]) — Vertical table lookup.
4. Excel Error Messages Master List
| Error Code |
Root Cause / Meaning |
##### | Column width is too narrow to display the full number/date. |
#DIV/0! | Attempting to divide a number by zero (0) or an empty cell. |
#NAME? | Unrecognized function name (typo in function name like `=SUUM()`). |
#VALUE! | Incorrect data type used (e.g., performing math on text string). |
#REF! | Invalid or deleted cell reference. |
#N/A | Value Not Available (lookup value cannot be found in search range). |
#NUM! | Invalid numeric calculation (e.g., `=SQRT(-9)`). |
5. Essential MS Excel Keyboard Shortcuts
| Shortcut Key |
Function |
Shortcut Key |
Function |
F2 | Edit Active Cell | Ctrl + Shift + L | Toggle Data Filter |
F11 | Create Chart from data | Ctrl + T | Convert Range to Table |
Alt + = | AutoSum Selected Cells | Ctrl + 1 | Format Cells Window |
Ctrl + ; | Insert Current Date | Shift + Spacebar | Select Entire Row |
Ctrl + Shift + : | Insert Current Time | Ctrl + Spacebar | Select Entire Column |
Practice Questions (UPSSSC Pattern)
1. What is the maximum number of rows in a single MS Excel worksheet (.xlsx)?
A) 65,536 B) 256 C) 1,048,576 D) 16,384
2. In MS Word, which margin setting adds extra space to the binding side of a page?
A) Header Margin B) Footer Margin C) Mirror Margin D) Gutter Margin
3. In MS Excel, what error is displayed when a formula attempts to divide by zero?
A) #REF! B) #DIV/0! C) #VALUE! D) #NAME?
4. Which shortcut key runs a Spelling and Grammar check in MS Word?
A) F5 B) F7 C) Shift + F7 D) F12