The data that is entered in a cell may be either:
A. Numeric
B. Alpha-Numeric
C. Date
D. Chart
Choose the correct answer from the options given below:
Answer & explanation
Correct answer: option 4
The correct answer is Option (4) → A, B and C only
When data is typed in a cell, Excel recognises its type by itself: a number, a piece of text (letters with or without numbers) or a date. A chart is not typed into a cell; it is drawn from the data already in the cells.
A. Numeric — Correct. Numbers such as amounts and quantities are entered in cells and can be used in calculations.
B. Alpha-Numeric — Correct. Text made of letters (and numbers), such as names and headings, is entered in cells.
C. Date — Correct. A date entered in a cell is recognised as a date and can be formatted or used in date calculations.
D. Chart — Incorrect. A chart is a graphic object created from a range of cells; it is not data entered in a cell.
NCERT (2026-27 edition): |