SSC CGL Computer – MS Excel – Level 3 · Challenge
← Back
TRIM leaves "SSC CGL" (single inner space) → 7 characters.
₹299 →
SSC CGL Computer – MS Excel – Level 3 · Challenge – 7 questions, subject: Computer Knowledge. Every question has the correct answer with a one-line explanation; tap "Show Answer". Free practice for TNPSC, UPSC, SSC, Bank and RRB exams – Shanmugam IAS Academy, Coimbatore.
Get daily current affairs & exam alerts – follow us
YouTube
WhatsApp Channel
Telegram Channel
Facebook Page
Instagram
Share with friends & study groups
Link to this page from your website / blog (HTML code)
1.
Statement-basedWhich is/are correct?
I. Moving a formula by cut and paste changes its relative references.
II. Copying a formula changes its relative references.
I. Moving a formula by cut and paste changes its relative references.
II. Copying a formula changes its relative references.
Correct Answer: D [Only II]
Explanation:
Moving keeps references; copying adjusts the relative ones.
2.
Match the followingMatch the error value with its usual cause:
P. #REF! Q. #N/A R. #VALUE! S. #NUM!
1. A lookup finds no match 2. An impossible number such as the square root of –4 3. A referenced row or column was deleted 4. Arithmetic on text
P. #REF! Q. #N/A R. #VALUE! S. #NUM!
1. A lookup finds no match 2. An impossible number such as the square root of –4 3. A referenced row or column was deleted 4. Arithmetic on text
Correct Answer: C [P-3, Q-1, R-4, S-2]
Explanation:
#REF! cell gone · #N/A not found · #VALUE!
3.
Chronological orderArrange in chronological order of first release: Excel for Windows, VisiCalc, Excel for Macintosh, Lotus 1-2-3
Correct Answer: A [VisiCalc → Lotus 1-2-3 → Excel for Macintosh → Excel for Windows]
Explanation:
Answer: VisiCalc → Lotus 1-2-3 → Excel for Macintosh → Excel for Windows. 1979 → 1983 → 1985 → 1987.
4.
What does =ROUND(1234.567,-2) return?
Correct Answer: B [1200]
Explanation:
Negative digits round to the left of the decimal point – to the nearest hundred.
5.
Spot My Mistake'In A$1 the column stays fixed when the formula is copied.' Which reference actually keeps only the column fixed?
Correct Answer: D [$A1]
Explanation:
The $ locks what follows it: $A1 locks the column; A$1 locks the row.
6.
Two-quantity comparison
Quantity I: the number of cells in the range B2:D10
Quantity II: the column number of column AA
Quantity I: the number of cells in the range B2:D10
Quantity II: the column number of column AA
Correct Answer: C [Quantity I = Quantity II]
Explanation:
QI = 3 × 9 = 27; QII = 26 + 1 = 27 → equal.
7.
What does =LEN(TRIM(" SSC CGL ")) return?
Correct Answer: A [7]
Explanation:
TRIM leaves "SSC CGL" (single inner space) → 7 characters.
➤ Full notes, shortcuts and every answer explained – SSC CGL 2026 Computer Knowledge book (₹149): www.shanmugamiasacademy.in/study-materials/ssc-cgl-computer-knowledge
📘 SSC CGL 2026 – Computer Knowledge (Tier II Paper I – Section III)
Here you get the answer with a one-line explanation. 672 original questions with answer key and explanations · notes, figures, shortcut keys and memory aids · practice sets + 3 Computer Knowledge mock tests
Get the book – ₹149 More quizzes
› SSC CGL Computer – Mock Test M3 – Computer Knowledge Module
› SSC CGL Computer – Mock Test M2 – Computer Knowledge Module
› SSC CGL Computer – Mock Test M1 – Computer Knowledge Module
› SSC CGL Computer – Cyber Security & Abbreviations – Exam-Level Drill
› SSC CGL Computer – Cyber Security & Abbreviations – Level 3 · Challenge
› SSC CGL Computer – Cyber Security & Abbreviations – Level 2 · Exam Level · Section III pace
Score: 0
Answered: 0 / 0
