SSC CGL Computer – MS Excel – Level 2 · Exam Level · Section III pace

← Back

SSC CGL Computer – MS Excel – Level 2 · Exam Level · Section III pace – 15 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.  
Match the followingMatch the function with what it does:
P. COUNTIF Q. VLOOKUP R. ROUND S. CONCAT
1. Joins pieces of text 2. Counts cells that meet a condition 3. Finds a value in the first column of a table and returns a value from that row 4. Rounds a number to given digits

Correct Answer: A [P-2, Q-3, R-4, S-1]

Explanation:

COUNTIF counts with a condition; VLOOKUP looks up; ROUND rounds; CONCAT joins text.

2.  
Odd one outOdd one out (by ribbon tab):

Correct Answer: D [PivotTable]

Explanation:

PivotTable is on Insert; the other three are on the Data tab.

3.  
What does the formula =2^3^3 return in Excel?

Correct Answer: C [512]

Explanation:

^ is worked left to right: (2^3)^3 = 8^3 = 512 (not 2^27).

4.  
Assertion–Reason
A: In Excel, =-4^2 returns 16.
R: Excel performs negation before exponentiation.

Correct Answer: B [Both A and R are true and R explains A]

Explanation:

Negation (rank 2) comes before ^ (rank 4), so Excel squares –2.

5.  
On the Marks sheet, C3 holds 45. What does =IF(C3>=50,"Pass","Fail") return?

Correct Answer: D [Fail]

Explanation:

45 >= 50 is FALSE → the third argument, Fail.

6.  
True/False countHow many are true?
(i) $A$1 does not change when the formula is copied.
(ii) In $A1 the column is fixed.
(iii) In A$1 the column is fixed.
(iv) A1 is a relative reference.

Correct Answer: C [3]

Explanation:

(iii) is false – A$1 fixes the row, not the column.

7.  
Cell C1 holds =A1+B1. It is copied to C4. What formula appears in C4?

Correct Answer: A [=A4+B4]

Explanation:

Three rows down → both row numbers +3.

8.  
Find the value of =5+3*2^2-8/4.

Correct Answer: B [15]

Explanation:

2^2 = 4; 3 × 4 = 12; 8/4 = 2; 5 + 12 − 2 = 15.

9.  
A workbook that contains macros must be saved with which extension?

Correct Answer: A [.xlsm]

Explanation:

.xlsm = macro-enabled workbook; .xlsx cannot store macros.

10.  
In Microsoft 365, =SORT(A2:A10) is typed in C2, but cell C5 already holds some text. What does C2 show?

Correct Answer: B [#SPILL!]

Explanation:

SORT returns 9 values that must spill into C2:C10; C5 is in the way → #SPILL!.

11.  
Arrange in orderArrange in Excel's order of calculation, first to last: ^, &, negation, *, =, %

Correct Answer: D [negation → % → ^ → * → & → =]

Explanation:

Rough Notes Prepare Proper Marks And Joyful Celebrations.

12.  
Which chart is most suitable for showing the change in monthly sales over two years?

Correct Answer: C [Line chart]

Explanation:

A line chart shows a trend over time.

13.  
Reverse questionThe answer is 'Data Validation'. Which description fits?

Correct Answer: A [Allowing only whole numbers from 0 to 100 to be entered in a cell]

Explanation:

Validation restricts entries; filter shows rows; conditional formatting colours; Freeze Panes keeps headings.

14.  
How many rows does a worksheet in current versions of Excel have?

Correct Answer: B [10,48,576 (1,048,576)]

Explanation:

2²⁰ = 10,48,576 rows (international grouping 1,048,576); 16,384 is the number of columns.

15.  
Applying a Filter to a list:

Correct Answer: C [hides the rows that do not meet the condition]

Explanation:

Filtered-out rows stay in the sheet, only hidden.

➤ 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 ₹299 →
Score: 0 Answered: 0 / 0