DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Apostrophe (’)
|
|
|
Exclamation (!)
|
|
|
Hash (#)
|
|
|
None of these
|
Detailed explanation-1: -A numeric value can be treated as label value if precedes it. a)Apostrophe ( ‘ )b)Exclamation ( ! ) c)Hash ( # )d)Tilde ( )Correct answer is option ‘A’.
Detailed explanation-2: -Solution(By Examveda Team) An apostrophe before a cell value forces Excel to interpret the value as label. This is mostly useful for values that look like a number or date.
Detailed explanation-3: -Entering a Label (Text) or a Value (Number) Click the cell where you want to enter a label or a value. Type a label (text) or a value (number). A label can include uppercase and lowercase letters, spaces, punctuation, and numbers. When typing values, do so without commas and dollar signs.
Detailed explanation-4: -When a label is too long to fit within a worksheet cell, we must increase the column width.