Answer:
Option 4 is correct ,=(B2+C9)
Explanation:
In excel a formula starts with an equal sign followed by the expression.
In first option the formula is incorrect inside the brackets. where 4 is equating to bracket. In 2nd option opening and closing brackets are not same. First closing bracket is missing an opening bracket. In third option all the formula is correct except the part where # is used in formula. Hash tags cannot be used in formula as a value. Here in option D B2 and C9 are cell in excel, whereas parentheses are only used for better readability.
The answer is true.
Let's say we are calculating the volume of a grain silo where the the width is a constant, but the height can be changed.
In our code we would calculate the volume using something like:
PI * (WIDTH / 2)^2 * height
The variables in all caps would be named constants. Using them makes the code more readable to other people than if we were to just use their values like:
3.14 * (145.75 / 2)^2 * height