In Excel, .......... refers to any cell containing static data such as numbers…
2024
In Excel, .......... refers to any cell containing static data such as numbers or text, but not formulas.
Answer: A. Constant — Microsoft Excel broadly categorizes cell contents into two fundamental types: Formulas and Constants. A Constant is a piece of data that is entered directly…
- A.
Constant
- B.
Data Validation
- C.
Current Region
- D.
Object
Attempted by 179 students.
Show answer & explanation
Correct answer: A
Microsoft Excel broadly categorizes cell contents into two fundamental types: Formulas and Constants.
A Constant is a piece of data that is entered directly into a cell and remains static. Because it does not begin with an equal sign (=), Excel treats it as literal information rather than an instruction to compute something.
Examples of constants include:
Numeric Values:
150,3.14,-45Text/Strings:
"Total","Akash","Product ID"Dates and Times:
01-06-2026,12:00 PM
If you use Excel's Go To Special feature (Ctrl + G > Special), you can explicitly ask Excel to select all "Constants" across a worksheet to separate them from cells driven by dynamic formulas.