Question

In Microsoft Excel, which formula will yield a value of 10? 5x2 5x2*.5+5 =5*1.5 =(100/5*2)*.25

Answer 1

In Microsoft Excel, it considers potential incorrect or typo text input from the user, as such 'x' is considered as '*' or multiplication symbol when you put as formula, a prompt will be asked to consider this is a multiplication symbol. Thus the choices below will yield a value of 10 given the above premise.

1. =5x2

2. =5x2*.5+5

4. =(100/5*2)*.25

Only the third choice, 5*1.5 will yield 7.5 answer and not 10.

Answer 2

In every formula starts with a "=" so the first first two options 5x2 5x2*.5+5 cant be the option.

=5*1.5 this will yield 7.5

=(100/5*2)*.25 This is the formula which will yield a value of 10 and it is the answer.

I hope this will help you.