FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Using the correct order of operations, what does this formula equal? =(4-2)*6/2.
A
=4
B
=6
C
=8
D
=2
Explanation: 

Detailed explanation-1: -To change the order of evaluation, enclose in parentheses the part of the formula to be calculated first. For example, the following formula produces 11 because Excel performs multiplication before addition. The formula multiplies 2 by 3 and then adds 5 to the result.

Detailed explanation-2: -Detailed Solution. The correct answer is SUM().

Detailed explanation-3: -Simple formulas always start with an equal sign (=), followed by constants that are numeric values and calculation operators such as plus (+), minus (-), asterisk(*), or forward slash (/) signs. Let’s take an example of a simple formula.

There is 1 question to complete.