Question

Question 14 (3 points)

Which formula is properly constructed?
O=(B2+09)
O=4+(V=14
O=G-)4(-3)
= (D4*G*L#)

Answer 1

The only properly constructed formula among the options is (D4*G*L#)

O=(B2+09): This formula is incorrect because it assigns the value of (B2+09) to the variable "O" without an equal sign (=) before the expression.

O=4+(V=14): This formula has two assignment statements within the same expression, which is not allowed. It should be either `O=4+V` or O=V=14` depending on the intended meaning.

O=G-)4(-3): This formula has an invalid operator (-) before the number 4. Operators should be used between operands, not directly before them.

(D4*G*L#): This formula uses valid operators and expressions within parentheses, making it the only correct option. The "#" at the end is likely a placeholder for another operation or value, but it doesn't affect the initial construction of the formula.

Therefore, the formula **(D4*G*L#)** is the only properly constructed one among the given options.

Answer 2

This is an Excel formula and the last one is properly constructed.

= (D4*G*L#)

Step-by-step explanation:

We can use many types of formulas in Excel, for example, sum, average, and count numbers.

We Always must start with the symbol "=", therefore the 3 first option of the question is wrong, start with a letter "O".

O=(B2+09)

O=4+(V=14

O=G-)4(-3)

The last option is properly constructed because we start with the symbol "=", in this case, just we need to add the field that we want to multiply.

For example:

= (D4*G4*L4)