SSC CGL Computer – MS Excel – Exam-Level Drill
← Back
Both tests are TRUE → AND is TRUE → Distinction.
₹299 →
SSC CGL Computer – MS Excel – Exam-Level Drill – 6 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.
B2 holds =A2*$E$1. It is copied to D5. What formula appears in D5?
Correct Answer: B [=C5*$E$1]
Explanation:
2 columns right and 3 rows down: A2 → C5; $E$1 stays.
2.
B2 holds =$A2*B$1. It is copied to D4. What formula appears in D4?
Correct Answer: D [=$A4*D$1]
Explanation:
2 columns right, 2 rows down: $A2 → $A4 (column fixed); B$1 → D$1 (row fixed).
3.
Which column number is column SSC?
Correct Answer: C [13,341]
Explanation:
S = 19, C = 3: 676 × 19 + 26 × 19 + 3 = 12,844 + 494 + 3 = 13,341.
4.
What are the letters of column number 2026?
Correct Answer: B [BYX]
Explanation:
2 × 676 + 25 × 26 + 24 = 1,352 + 650 + 24 = 2,026 → B, Y, X.
5.
Diagram-basedIn the schematic of the Excel window, what is the part marked 2?
Correct Answer: D [Name Box]
Explanation:
Part 2 shows C5 – the address of the active cell, i.e.
6.
On the Marks sheet, Divya (row 6) has 66 and 71. What does =IF(AND(C6>=60,D6>=60),"Distinction","Pass") return?
Correct Answer: A [Distinction]
Explanation:
Both tests are TRUE → AND is TRUE → Distinction.
➤ 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
