Question

aman wants to multiply the values in cells b2 and b3, and then divide the total by the value in cell d7. which of the following would be the correct formula? a =b2b3-d7 b =(b2b3)%d7 c =(b2xb3)/d7 d =(b2*b3)/d7

Explanation:

Step1: Identify operations

Multiply B2 and B3 first, then divide by D7.

Step2: Check formula syntax

Excel uses for multiplication, / for division, and parentheses to prioritize operations. Option D correctly groups B2B3 with parentheses then divides by D7. Other options use wrong operators (% for B, - for A) or incorrect symbols (× for C).

Answer:

D. =(B2*B3)/D7