FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Answer: The correct answer is 2. The order of operations can be remembered by the acronym PEMDAS, which stands for: parentheses, exponents, multiplication and division from left to right, and addition and subtraction from left to right.

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: -A formula in Excel always begins with an equal sign (=). Excel 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-4: -In a formula, multiplication is performed before subtraction. In a formula, operations within parenthesis are performed after operations outside parentheses. An absolute reference does not change when the formula is copied or moved to another cell.

Detailed explanation-5: -First, we solve any operations inside of parentheses or brackets. Second, we solve any exponents. Third, we solve all multiplication and division from left to right. Fourth, we solve all addition and subtraction from left to right.