MS Office Notes for SSC Exams
Rahul Kumar
SSC Exam Expert & Content Editor
Updated 03 Oct 2026
In this note
MS Office is the most popular office software package, and it is a favourite topic in the computer section of SSC exams. Questions are asked on the parts of the window, file extensions, Excel functions, error values, PowerPoint views and basic features. These MS Office notes explain MS Word, MS Excel, MS PowerPoint, MS Access and MS Outlook in a simple, exam-oriented way.
Introduction to MS Office
- MS Office is a suite of application software developed by Microsoft.
- Main programs: Word (word processing), Excel (spreadsheet), PowerPoint (presentation), Access (database), Outlook (email and calendar), Publisher (desktop publishing) and OneNote (note taking).
- Common parts of the window: Title bar, Quick Access Toolbar, Ribbon (tabs and groups), Ruler, Scroll bars and Status bar.
- The Ribbon replaced the old menus and toolbars from MS Office 2007.
MS Word
Basics
- MS Word is a word processor used to create letters, reports and documents. The default file extension is .docx (older versions used .doc). A template has the extension .dotx.
- Main tabs: File, Home, Insert, Design, Layout, References, Mailings, Review and View.
- Views: Print Layout, Read Mode, Web Layout, Outline and Draft.
- Page orientation: Portrait (vertical) and Landscape (horizontal). Margins are the blank space around the text.
- Header and Footer appear at the top and bottom of each page. Page Number, date and time can be inserted there.
Important Features
| Feature | Use |
|---|---|
| Format Painter | Copies the formatting of one text and applies it to another |
| Find and Replace | Finds a word and replaces it with another one (Ctrl + H) |
| Spelling and Grammar | Checks mistakes (F7) |
| Track Changes and Comments | Show edits and notes made by reviewers (Review tab) |
| Mail Merge | Creates many personalised copies of one letter using a main document and a data source (Mailings tab) |
| Table of Contents | Created automatically from heading styles (References tab) |
| Styles | Predefined formatting such as Heading 1, Normal and Title |
| Word Count | Shows the number of words, characters, paragraphs and lines |
| Drop Cap | Makes the first letter of a paragraph large |
| Watermark | Faint text or picture behind the page text, for example "Confidential" |
| Thesaurus | Gives synonyms (Shift + F7) |
MS Excel
Basics
- MS Excel is a spreadsheet program used for calculations, data analysis and charts. The default file extension is .xlsx (older versions .xls). A file is called a workbook and each page in it is a worksheet.
- A worksheet has rows (numbers) and columns (letters). In Excel 2007 and later, it has 1,048,576 rows and 16,384 columns (A to XFD).
- The intersection of a row and a column is a cell. The cell address is column letter + row number, such as B5. The selected cell is the active cell.
- The Name Box shows the address of the active cell, and the Formula Bar shows its contents.
- A range is a group of cells, written like A1:B5. Every formula starts with the equal sign (=).
Cell References
| Type | Example | Meaning |
|---|---|---|
| Relative | A1 | Changes when the formula is copied to another cell |
| Absolute | $A$1 | Does not change when copied (press F4 to toggle) |
| Mixed | $A1 or A$1 | Either the column or the row is fixed |
Important Functions
| Function | Purpose |
|---|---|
| SUM | Adds the numbers in a range |
| AVERAGE | Finds the mean |
| MAX / MIN | Largest / smallest value |
| COUNT | Counts the cells that contain numbers |
| COUNTA | Counts the cells that are not empty |
| COUNTBLANK | Counts the empty cells |
| IF | Returns one value if a condition is true and another if it is false |
| SUMIF / COUNTIF | Adds or counts cells that meet a condition |
| VLOOKUP / HLOOKUP | Searches a value in a column / row of a table |
| LEN | Counts the characters in a text |
| LEFT / RIGHT / MID | Extracts characters from a text |
| UPPER / LOWER / PROPER | Changes the case of text |
| CONCATENATE | Joins text from different cells |
| TODAY / NOW | Current date / current date and time |
| ROUND | Rounds a number to the given digits |
Error Values
| Error | Reason |
|---|---|
| #DIV/0! | A number is divided by zero |
| #NAME? | Excel does not recognise a function or name |
| #VALUE! | Wrong type of value in a formula |
| #REF! | Invalid cell reference, for example a deleted cell |
| #N/A | Value not available |
| #NUM! | Invalid numeric value |
| #NULL! | Wrong range operator |
| #### | The column is too narrow to show the value |
Other Excel Features
- Sort and Filter arrange and show selected data. Freeze Panes keeps rows or columns visible while scrolling.
- Conditional Formatting changes the look of a cell based on its value. Data Validation controls what can be typed in a cell.
- Charts: column, bar, line, pie, scatter and area. A pivot table summarises large data quickly.
- The AutoFill handle is the small square at the bottom-right corner of the active cell.
MS PowerPoint
- MS PowerPoint is a presentation program. The default extension is .pptx (older .ppt), a slide show file is .ppsx and a template is .potx.
- A presentation is made of slides. The slide layout decides the arrangement of titles, text and pictures. The Slide Master controls the design of all slides.
- Views: Normal, Slide Sorter, Notes Page, Reading View and Slide Show.
- Transitions control how one slide changes to the next, while Animations control the movement of objects on a slide.
- Notes are written below the slide for the speaker and are not shown during the presentation.
- Slide shows start with F5 (from the first slide) or Shift + F5 (from the current slide).
MS Access and MS Outlook
- MS Access is a database program with extension .accdb. Its main objects are Tables (store data), Queries (search data), Forms (enter data) and Reports (print data).
- MS Outlook manages email, contacts, calendar and tasks. Mail folders include Inbox, Outbox, Sent Items, Drafts and Deleted Items.
Basic Windows Programs
| Program | Use / File type |
|---|---|
| Notepad | Simple text editor, .txt files |
| WordPad | Basic word processor, .rtf files |
| Paint | Drawing program, .png / .bmp / .jpg files |
| Calculator | Standard and scientific calculations |
| File Explorer | Manages files and folders |
| Task Manager | Shows running programs and ends not-responding programs |
| Control Panel | Changes system settings |
| Recycle Bin | Stores deleted files until they are permanently removed |
Practice Questions With Answers
- What is the default file extension of an MS Word 2016 document? Answer: .docx
- The intersection of a row and a column in Excel is called: Answer: Cell
- Which function counts the cells that contain numbers? Answer: COUNT
- Which error appears when a number is divided by zero? Answer: #DIV/0!
- Which key toggles absolute and relative references in Excel? Answer: F4
- Which feature is used to send the same letter to many people? Answer: Mail Merge
- What is the extension of a PowerPoint slide show file? Answer: .ppsx
- Which view in PowerPoint shows all slides as small pictures? Answer: Slide Sorter
- Which program of MS Office is used to create databases? Answer: MS Access
- How many columns does Excel 2016 have? Answer: 16,384
Learn the shortcut keys from our Computer Shortcut Keys note, and the abbreviations from Computer Full Forms. For the complete theory, read the main Computer Knowledge Notes.
Previous chapter
Computer Full Forms for SSC Exams
Next chapter
Internet and Networking Notes for SSC Exams
About the Author
Rahul Kumar
SSC Exam Expert & Content Editor
Rahul is a senior SSC exam strategist with 8+ years of experience helping aspirants crack CGL, CHSL and MTS exams. He writes in-depth notification breakdowns, exam pattern guides and preparation strategies.