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: -An equal sign (=) always precedes a formula. A2 is a cell reference. (A2 refers to the second cell in the first column.) + is an arithmetic operator that adds the value that precedes it with the value that follows it.
Detailed explanation-2: -A formula always begins with an equal sign (=). Excel for the web interprets the characters that follow the equal sign as a formula. Following the equal sign are the elements to be calculated (the operands), such as constants or cell references. These are separated by calculation operators.
Detailed explanation-3: -An equal sign = precedes all formulas and functions. Formulas and functions must be created with cell references to conduct what-if scenarios where mathematical outputs are recalculated when one or more inputs are changed.
Detailed explanation-4: -The equal sign (=) precedes a formula. Excel has more than 400 functions that perform just about every type of calculation you can imagine.
Detailed explanation-5: -Explanation: A formula performs calculations or other actions on the data in your worksheet. A formula always starts with an equal sign (=), which can be followed by numbers, math operators (such as a plus or minus sign), and functions, which can really expand the power of a formula.