DATABASE FUNDAMENTALS
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: -The ISNUMBER function is an information function used to find if the cell value in reference is a numerical value or not. It returns values as “true” or “false.” The formula for the ISNUMBER function is “=ISNUMBER (value).” It is a worksheet (WS) function in Excel.
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.