USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
In this formula, which calculation is performed first? =B4*100+15/3
|
B4*100
|
|
100+15
|
|
15/3
|
|
None of the above
|
Explanation:
Detailed explanation-1: -Calculation order A formula in Excel always begins with an equal sign (=). Excel interprets the characters that follow the equal sign as a formula.
Detailed explanation-2: -A function is a predefined formula that performs calculations using specific values in a particular order.
Detailed explanation-3: -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. For example, the following formula multiplies 2 by 3 and then adds 5 to that result to come up with the answer, 11.
There is 1 question to complete.