Correct option is B
The correct answer is (b) =A2*B2
Explanation: (Information about the correct answer):
• In Microsoft Excel, the asterisk symbol (*) is used as the mathematical operator for multiplication.
• Every formula in Excel must begin with an equal sign (=).
• Entering =A2*B2 in cell C2 will take the value in A2 and multiply it by the value in B2.
• Cell references allow the calculation to update automatically if the numbers in A2 or B2 change.
• This is one of the most basic arithmetic operations performed in spreadsheets.
Information Booster: (additional info around the correct answer):
• You can also use the PRODUCT function, like =PRODUCT(A2, B2), to achieve the same result.
• Standard operators include + (addition), - (subtraction), * (multiplication), and / (division).
Additional Knowledge: (Information about incorrect options):
=A2+B2 (Option a)
• This formula is used for addition, adding the values of cell A2 and B2.
MULTIPLY(A2,B2) (Option c)
• This is not a standard built-in function name in Excel; 'PRODUCT' is the correct function name.
=A2-B2 (Option d)
• This formula is used for subtraction, subtracting the value of B2 from A2.
So the correct answer is (b)
