打开excel文档
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/96dda144ad345982fc3cc42d00f431adcaef84de?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2
以某一学期的学生的期末考试成绩为例,试计算学生化学成绩占其总分的百分比
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9922720e0cf3d7ca5bdc1fc9fe1fbe096b63a962?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3
选中对应单元格后,在函数“fx”右侧键入化学成绩与总分之比,如“F6/I6”
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/aec379310a55b3193023a3ca4fa98226cefc17b2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4
按下键盘上的回车键即“enter”键后,相应单元格中会出现小数,这个小数就是上一步中的比值
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/314e251f95cad1c83e44dd98733e6709c83d5195?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5
鼠标移动到以选中单元格的右下角,直到鼠标变成黑色小十字
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/728da9773912b31b59b6ec968a18367adbb4e1b3?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6
向下拖动鼠标,即可得到所有同学的化学成绩于总分之比
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/09fa513d269759ee2f7a4074befb43166d22df62?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7
选中比值这一列,鼠标右键点击“设置单元格格式”
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/71cf3bc79f3df8dc73c2ae2ec111728b46102895?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
8
在弹出的窗口中,选择“数据”-“百分比”
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d043ad4bd11373f04ce54e20a80f4bfbfaed04b2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
9
鼠标点击“确定”
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/cefc1e178a82b901a977e28c7f8da9773812efb3?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
10
这样,单项所占合计的百分比就计算出来啦
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/79f0f736afc37931d3b2a796e7c4b74542a911b2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)