USING MICROSOFT EXCEL
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
numeric value whose length is greater than the column width
|
|
|
Enter the wrong cell address in the formula
|
|
|
wrong function name
|
|
|
divide by the value 0
|
Detailed explanation-1: -After you convert the cell from a formula to a value, the value appears as 1932.322 in the formula bar. Note that 1932.322 is the actual calculated value, and 1932.32 is the value displayed in the cell in a currency format.
Detailed explanation-2: -Before sending a report (In Excel) to someone we must convert a formula to value. It simply means to replace a formula with its result value. Just think this way, when you send a report to someone, they are not concerned with formulas but with the values, a formula returns.
Detailed explanation-3: -Since we have done all the heavy lifting in the code itself, all you need to do is use the formula =GetNumeric(A2). This will instantly give you only the numeric part of the string.
Detailed explanation-4: -Once you are done entering your formula, you will see that the information in the cell is different than what is shown in the formula bar. The formula bar shows the formula if there is one, and the cell shows the result.