SSC CGL Computer – MS Excel – Level 1 · Warm-up

← Back

SSC CGL Computer – MS Excel – Level 1 · Warm-up – 12 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.  
An Excel file that can hold several worksheets is called a:

Correct Answer: D [Workbook]

Explanation:

Workbook (.xlsx) → worksheets → cells.

2.  
Every formula in Excel begins with the sign:

Correct Answer: C [=]

Explanation:

The = tells Excel that a calculation follows.

3.  
The box where a column and a row meet in a worksheet is called a:

Correct Answer: B [Cell]

Explanation:

A cell is addressed as column letter + row number, e.g.

4.  
Which part of the Excel window shows the formula (not its result) of the active cell?

Correct Answer: A [Formula bar]

Explanation:

The formula bar shows and edits the cell's content; the Name Box shows its address.

5.  
In current versions of Excel, the last column of a worksheet is:

Correct Answer: C [XFD]

Explanation:

XFD = column 16,384; IV was the last column of old .xls sheets.

6.  
Which function returns the largest number in a range?

Correct Answer: B [MAX]

Explanation:

MAX gives the largest, MIN the smallest.

7.  
One-line recallA formula that divides a number by zero shows the error:

Correct Answer: D [#DIV/0!]

Explanation:

Division by zero or by an empty cell → #DIV/0!.

8.  
Remove Duplicates and Text to Columns are found on which tab of Excel?

Correct Answer: A [Data]

Explanation:

Data → Data Tools group: Text to Columns, Remove Duplicates, Data Validation.

9.  
Fill in the blankIn =SUM(B2:B9) the colon (:) is the ______ operator.

Correct Answer: D [range]

Explanation:

Colon = range; comma = union; space = intersection.

10.  
Which chart plots pairs of numbers (X, Y) to show the relationship between two variables?

Correct Answer: B [Scatter chart]

Explanation:

Scatter (XY) chart – each point is an (X, Y) pair; pie and doughnut show parts of a whole.

11.  
A cell shows ##### after a long number is typed. The usual reason is:

Correct Answer: A [the column is too narrow]

Explanation:

Widen the column and the number appears.

12.  
Statement-basedWhich is/are correct?
I. COUNTA counts every non-empty cell in a range.
II. COUNT counts cells that contain text.

Correct Answer: C [Only I]

Explanation:

COUNT counts only numbers, so II is wrong.

➤ 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