FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
In MS-Excel numeric value can be treated as a label value if it precedes with
A
Apostrophe (’)
B
Exclamation (!)
C
Hash (#)
D
None of these
Explanation: 

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.

There is 1 question to complete.