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 range automatically selected by Excel is always correct. Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula.
Detailed explanation-2: -The range automatically selected by Excel is always correct. You can use the arrow keys to complete an entry in Point mode. The AVERAGE function requires that the argument be included within parentheses following the function name.
Detailed explanation-3: -Expert-Verified Answer. Yes excel is used for mathematical calculations that is absolutely true.
Detailed explanation-4: -Instead of using a calculator, use Microsoft Excel to do the math! You can enter simple formulas to add, divide, multiply, and subtract two or more numeric values.
Detailed explanation-5: -Correct common formula errors one by one Select the worksheet you want to check for errors. If the worksheet is manually calculated, press F9 to recalculate. If the Error Checking dialog is not displayed, then click on the Formulas tab > Formula Auditing > Error Checking button.