Home › Exam notes › SSC CGL › Word Processing / Spreadsheet

Word Processing / Spreadsheet

Reasoning & Computer Aptitude · Office, Database & Networking

Useful for: SSC CGL, IBPS Banking, KVS, NVS, OTET, OSSTET, UGC NET, EMRS

and 19 more exams

OSSC RHT — Regular High School Teacher, CTSA / STSS, Central Univ./IIT/NIT Faculty, Junior Teacher, OAVS, OPSC Assistant Professor, OPSC PGT, OSEPA Primary Teacher / JT Category-I, OSEPA Upper Primary — Arts, OSEPA Upper Primary — Science, OSSC Teacher Readiness, OSSSC Govt Physical Education Teacher (PET), OSSSC Govt TGT Arts, OSSSC Govt TGT Science — CBZ, OSSSC Govt TGT Science — PCM, Sainik Schools, Special OTET, SSB Lecturer / PGT, SSB School Teachers

हिंदी में पढ़ें

Overview

This topic tests common Windows operations and MS Word, Excel and PowerPoint features and shortcuts.

Key points

Ctrl + C copy, Ctrl + V paste, Ctrl + X cut, Ctrl + Z undo, Ctrl + Y redo.
Alt + F4 closes the active window; Windows key + D shows the desktop.
Word: F7 spell check; Ctrl + B bold; Ctrl + P print.
Excel: formulas start with "="; $A$1 is an absolute reference; SUM, AVERAGE, COUNT, COUNTA.
PowerPoint: F5 starts the slide show from the beginning.

Explanation

Excel cell address: column letter + row number (B3).
Mail merge in Word combines a letter with a data list.
Relative references change when copied; absolute ($) do not.
Recycle Bin stores deleted files until emptied.

Step by step

Recall the exact term or function asked.
Eliminate options from a different category (hardware vs software, input vs output).
Check the shortcut or acronym expansion.

Examples

Shortcut to start a PowerPoint slide show → F5.
Excel: =A1*$B$1 copied to C2 becomes =A2*$B$1.
Spell check in Word → F7.

Traps and advanced points

Trap: Mixing undo (Ctrl + Z) and redo (Ctrl + Y).
Trap: Forgetting "=" in formulas.
Trap: Thinking absolute references change when copied.

Quick revision

Ctrl + Z undo, Ctrl + Y redo.
F7 Word spell check, F5 slide show.
$ fixes references.

Practice MCQs

Computer proficiency drill: Which shortcut commonly selects all content?
1. Ctrl+M
2. Ctrl+R
3. Ctrl+A
4. Ctrl+L
Read chapter notes · Similar questions
Show answer
Answer: (c) Ctrl+A. Correct: Ctrl+A.
Quick check: Which file extension is commonly associated with a modern Excel workbook?
1. .txt
2. .xlsx
3. .docx
4. .pptx
Read chapter notes · Similar questions
Show answer
Answer: (b) .xlsx. Correct: .xlsx.
Concept check: Which Microsoft Office application is mainly used for slide presentations?
1. Microsoft PowerPoint
2. Calculator
3. Microsoft Excel
4. Microsoft Word
Read chapter notes · Similar questions
Show answer
Answer: (a) Microsoft PowerPoint. Correct: Microsoft PowerPoint.
Concept check: What does Windows File Explorer primarily help users do?
1. Create network cables
2. Compile source code only
3. Browse and manage files and folders
4. Measure CPU temperature
Read chapter notes · Similar questions
Show answer
Answer: (c) Browse and manage files and folders. Correct: Browse and manage files and folders.
Concept check: Which Microsoft Office application is mainly used for spreadsheets?
1. Microsoft PowerPoint
2. Microsoft Excel
3. Microsoft Word
4. Notepad
Read chapter notes · Similar questions
Show answer
Answer: (b) Microsoft Excel. Correct: Microsoft Excel.
In a Ranchi review practice scenario, In Excel, a formula normally begins with which symbol?
1. #
2. =
3. &
4. @
Read chapter notes · Similar questions
Show answer
Answer: (b) =. Correct: =.
In a Kochi review practice scenario, Quick check: Which shortcut commonly selects all content?
1. Ctrl+M
2. Ctrl+A
3. Ctrl+L
4. Ctrl+R
Read chapter notes · Similar questions
Show answer
Answer: (b) Ctrl+A. Correct: Ctrl+A.
In a Lucknow accounts practice scenario, Which Excel function is commonly used to add a range of numbers?
1. SUM
2. COUNTIF only
3. UPPER
4. CONCAT only
Read chapter notes · Similar questions
Show answer
Answer: (a) SUM. Correct: SUM.
In a Ranchi records practice scenario, Applied recall: Which shortcut commonly pastes clipboard content?
1. Ctrl+P
2. Ctrl+S
3. Ctrl+V
4. Ctrl+C
Read chapter notes · Similar questions
Show answer
Answer: (c) Ctrl+V. Correct: Ctrl+V.
In a Kochi office practice scenario, Concept check: Which Excel function is commonly used to add a range of numbers?
1. CONCAT only
2. UPPER
3. COUNTIF only
4. SUM
Read chapter notes · Similar questions
Show answer
Answer: (d) SUM. Correct: SUM.
In a Kochi office practice scenario, Concept check: What does Windows File Explorer primarily help users do?
1. Browse and manage files and folders
2. Create network cables
3. Measure CPU temperature
4. Compile source code only
Read chapter notes · Similar questions
Show answer
Answer: (a) Browse and manage files and folders. Correct: Browse and manage files and folders.
In a Delhi office practice scenario, Which shortcut commonly selects all content?
1. Ctrl+R
2. Ctrl+L
3. Ctrl+M
4. Ctrl+A
Read chapter notes · Similar questions
Show answer
Answer: (d) Ctrl+A. Correct: Ctrl+A.
Concept check: Which shortcut commonly saves the current document?
1. Ctrl+N
2. Ctrl+F
3. Ctrl+Z
4. Ctrl+S
Read chapter notes · Similar questions
Show answer
Answer: (d) Ctrl+S. Correct: Ctrl+S.
In a Kochi admin practice scenario, Concept check: Which file extension is commonly associated with a modern PowerPoint presentation?
1. .docx
2. .pptx
3. .xlsx
4. .rtf
Read chapter notes · Similar questions
Show answer
Answer: (b) .pptx. Correct: .pptx.
In an Indore records practice scenario, Computer proficiency drill: Which file extension is commonly associated with a modern Excel workbook?
1. .txt
2. .pptx
3. .xlsx
4. .docx
Read chapter notes · Similar questions
Show answer
Answer: (c) .xlsx. Correct: .xlsx.