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 arithmetic operator, ^, directs Excel to perform the division operation. As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations. Moving from left to right, the first calculation in the order of operations is negation.
Detailed explanation-2: -A formula in Excel always begins with an equal sign (=).
Detailed explanation-3: -A formula starts with an equals sign (=) that tells the spreadsheet you want to do a calculation. A formula then has a symbol for what kind of calculation you want to perform (add, subtract, multiply, divide, etc.).
Detailed explanation-4: -A Formula is an equation designed by a user in Excel, while a Function is a predefined calculation in the spreadsheet application.