164k views
1 vote
When you format a cell to display percentages, Excel assumes that whatever you enter into that cell in the future will be a percentage.

a) True
b) False

User Todd Lyons
by
7.6k points

1 Answer

4 votes

Final answer:

It is false that Excel will assume any future entry into a cell formatted for percentages is automatically a percentage. Excel interprets numbers as decimals, with 1 being 100% and 0.5 as 50%.

Step-by-step explanation:

When you format a cell to display percentages in Excel, it is false to assume that whatever you enter into that cell in the future will automatically be a percentage. This is because Excel interprets every number you enter as a decimal after you have formatted a cell for percentages. For example, if you enter the number 1, Excel will interpret it as 100%. Likewise, entering 0.5 would be interpreted as 50%, 0.01 as 1%, and so on.

User Mustapha GANGA
by
7.3k points