Question

Table s the tal rates for different countries in four different years. However, the person who entered the data didn't use the percentage format Instead of manually entering a percentage sig after exch value in the table, can you scopy and sodal Ml y or Divide function wong with formatincell to correct this mistake so that there is a percentage sign following each value in the same table leg 21.0 should be 21.0%, 1.should be 1.5%. Do not create new tabel) Table 1 2014 France Germany Italy Japan Holland Sweden UK 1913 1950 2100% 1800% 2000% 2600% 1800% 2500% 3000% 1500% 500% 1100% 2000% 900X 2000% 2300% 44001400% 1990 590% 590% 590% 530% 590% 440% 590% 480% 150% 150% 130% 150% 150% 150 150

Answer 1

B C D E F G к 1 2 3 France 4 Germany 5 Italy 6 Japan 7 Holland 8 Sweden 9 UK 10 US 1913 21.00% 20.00% 18.00% 30.00% 5.00% 20.00% 20.00% 44.00% 1950 18.00% 26.00% 25.00% 15.00% 11.00% 9.00% 23.00% 14.00% 1990 5.90% 5.90% 5.90% 5.30% 5.90% 4.40% 5.90% 4.80% 2014 1.50% 1.50% 1.50% 1.30% 1.50% 1.50% 1.50% 1.50% 11 12 First - Select the range and put all in a number format 13 Second: Write 100 in any other cell outside the table, copy it, and select the table special paste by divide function 14 Third: Select % in formatiing and use upto 2 decimal

Do let me know in case of any queries.