USING MICROSOFT EXCEL
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
^
|
|
|
*
|
|
|
%
|
|
|
>
|
Detailed explanation-1: -& operator is not an arithmetic operator The basic arithmetic operations are addition, subtraction, multiplication, and division. There are more arithmetic operators like exponentiation, modulus operations, increment, decrement, etc. *-Multiplication operator. So, And operator is not an arithmetic operator.
Detailed explanation-2: -Detailed Solution. The correct answer is SUM().
Detailed explanation-3: -When more than one arithmetic operator is involved in a formula, excel follows the same basic order of operations that you use in algebra. An arithmetic operator simply means the mathematical function which takes two operands and then performs a calculation on them.
Detailed explanation-4: -The arithmetic operator, ^, directs Excel to perform the division operation. Point mode allows you to select cells for use in a formula by using the keyboard. As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations.