Question

'LABELS' in MS Excel means :

• A. Information which can be treated mathematically
• B. A text or special character
• C. It is used for descriptive information of rows or columns
• D. Both (B) and (C)

Hint:

Labels in Excel are text entries that describe rows or columns, so both (B) and (C) are true.

Answer 1

The Correct Option is D

Step 1: Understanding the Concept:
Data typed into an Excel cell is either a value or a label.
A value can be used in calculations. A label is only text.

Step 2: Working Out the Answer:
Labels are text or special characters typed in cells. This makes statement (B) true.
They are used to give descriptive information for rows or columns, for example "Sales" or "Month". This makes statement (C) true.
Since both (B) and (C) are correct, option (D) is the right choice.

Step 3: Why the Other Options Are Wrong:
Option (A): Information that can be treated mathematically is a value (a number or formula result). It is not a label, so (A) is wrong.
Option (B): Option (B) alone is true but incomplete, because (C) is also true.
Option (C): Option (C) alone is true but incomplete, because (B) is also true.

Final Answer:
Both statements (B) and (C) describe labels. This is option (D).