Question

Which of the following is not a type of data in spreadsheet?

• A. Text
• B. Numbers
• C. Formula
• D. Graphic

Hint:

Always distinguish between what goes inside a cell (Text, Numbers, and Formulas) and what sits above or over the cells (Graphics, Charts, and Shapes).

Answer 1

The Correct Option is D

Step 1: Understanding Spreadsheet Architecture:
In spreadsheet software (such as Microsoft Excel, Google Sheets, or LibreOffice Calc), grid units called cells are used to store and manipulate computational data.

Step 2: Analyzing Cell Data Types:
When an active cell is selected, it can hold specific built-in data types:

• Text (Labels): Descriptive alphabetic or alphanumeric characters (e.g., names, addresses) that are treated as strings and are not used in mathematical equations.
• Numbers (Values): Raw numeric entries (integers, fractions, decimals, dates, currencies) on which mathematical computations are performed.
• Formulas: Mathematical expressions or logical functions (beginning with the equal sign, “$=$”) that compute and dynamically display values based on cell coordinates (e.g., =SUM(A1:A10)).

Step 3: Evaluating the Odd Option:
A Graphic (such as an image, diagram, or floating chart) is an external visual object. It does not exist as a data type inside a cell grid system; rather, it floats on top of the worksheet layer. Thus, it is not a cell data type.