Question

When a cell is formatted for a percent, if you enter the number .5, Excel translates the value as 50%.

a) True
b) False

Answer 1

Entering .5 in a cell formatted for percent in Excel translates the value as 50%, which is true.

Step-by-step explanation:

When a cell in Excel is formatted to display percentages and you enter the number .5, Excel will indeed translate this value as 50%. This is because Excel interprets the number you enter as the fraction of 100, so entering .5 is the same as entering 50/100, which is 50% when expressed as a percent. Therefore, the statement is true.