急:请问怎样用EXCEL计算出各选项占整体(整体为148)的百分数,顺便讲讲方法,

1个回答

  • 155.41%44.59%

    315.54%13.51%16.22%25.00%4.05%27.03%

    427.70%27.70%21.62%14.19%12.16%0.00%

    529.05%40.54%18.92%11.49%0.00%0.00%

    636.49%25.68%8.78%4.05%4.73%24.32%

    710.81%22.97%50.68%18.24%3.38%0.00%

    844.59%6.76%26.35%8.11%1.35%4.73%

    910.81%11.49%23.65%44.59%6.08%0.00%

    106.76%18.92%16.22%31.76%6.76%12.84%

    1118.92%36.49%37.84%12.16%8.11%0.00%

    126.76%50.68%24.32%10.14%8.11%0.00%

    1358.11%20.27%14.19%4.73%5.41%0.00%

    1410.81%24.32%16.22%6.08%13.51%29.73%

    1553.38%21.62%23.65%6.08%1.35%0.00%

    1625.00%25.68%25.68%23.65%1.35%0.00%

    1737.84%14.19%18.92%10.81%2.70%14.86%

    1831.76%12.16%19.59%16.22%20.27%0.68%

    195.41%29.05%45.27%14.19%2.03%0.00%

    2022.30%26.35%27.03%24.32%0.00%0.00%

    2154.73%19.59%27.70%18.92%11.49%0.00%

    先在空单元格中输入148,接着复制这个单元格,接着用选择性粘贴,在弹出的对话框中选择除,最后按确认就可以了.