Concept:An apostrophe at the beginning of a cell entry forces the spreadsheet to treat that entry as a label, or text, rather than a number or formula.
Explanation:When you type an apostrophe sign (
′) before a value, the spreadsheet hides the apostrophe but still handles the value as text.
This is useful for data that looks like a number or date, such as phone numbers, roll numbers, or values beginning with zero.
For example, entering
′0021 in a cell displays
0021 as a label, not as the number
21.
The apostrophe is therefore the correct spreadsheet symbol used to convert a number to a label.
Answer:D. apostrophe sign (')