
I-98 Computer Fundamentals
11. Explain the types of data that can be entered into a cell of spreadsheet.
Ans: In MS Excel, there are three types of data that can be entered in a cell. These types are
discussed as follows:
(i) Text: This type of data includes textual data and cannot be used to perform calculations. For
example, ‘Monday’, ‘hello’ etc. Note that the textual data always appears on the left side of
the cell.
(ii) Values: This type of data is used for calculations and includes numbers and data and time.
Numbers include the numerical characters 0–9 and special characters such as +, −, (, ), /, E, e,
$ and %. The ...