USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
true
|
|
|
false
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -The most common error when entering a formula is to reference the wrong cell in the formula. The Percent Style button instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign.
Detailed explanation-2: -The #REF! error shows when a formula refers to a cell that’s not valid. This happens most often when cells that were referenced by formulas get deleted, or pasted over.
Detailed explanation-3: -You will get the #REF! error when a formula references a cell that’s not valid. This often happens when referenced cells get deleted or pasted over. Select the cell with the #REF!
Detailed explanation-4: -If Excel cannot properly evaluate a worksheet formula or function, it displays an error value (such as #REF!, #NULL!, or #DIV/0!) in the cell where the formula is located.