FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
To change the order of operations in a formula, you should enclose part of the formula in
A
brackets
B
italics
C
parentheses
D
quotation marks
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: -Parentheses () is used to change the order of an operation. Using parentheses makes Excel do the calculation for the numbers inside the parentheses first, before calculating the rest of the formula. Parentheses are added by typing () on both sides of numbers, like (1+2) .

Detailed explanation-3: -In general, Excel’s order of operation follows the acronym PEMDAS (Parentheses, Exponents, Multiplication, Division, Addition, Subtraction) but with some customization to handle the formula syntax in a spreadsheet.

There is 1 question to complete.