Vidyalelo
Computer Fundamentals · Q54

Microsoft Excel

Computer Related · Computer Fundamentals · question 54

Q54

A numeric value can be treated as label value if ________ precedes it.

A.
Apostrophe ( ‘ )
Answer
B.
Exclamation ( ! )
C.
Hash ( # )
D.
Tilde ( ~ )

Answer: Option A

Solution

Answer: Option A
Solution:
An apostrophe before a cell value forces Excel to interpret the value as text. This is mostly useful for values that look like a number or date.