1、首先打开Excel办公软件,本次演示所用版本为家庭和学生版2016,其他版本亦可。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f3d3572c11dfa9ec716a433e6cd0f703918fc157?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、新建Excel表格并输入演示数据,将结果单元格用淡蓝色底纹显示,可以更直观的看到结果。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d53f8794a4c27d1e71bf2fed15d5ad6eddc43879?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、鼠标移动到c6单元格并双击之后输入公式,公式内容为“=ROUND(1+(3-1)*RAND(),2)”,表示在1~3之间取值,保留小数点后两位数字,若保留一位小数,只需要将函数表示小数位数的2换成即可。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d000baa1cd11728bd0cf980bc6fcc3cec3fd2c3c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、输入完成之后,按回车可以看到当前的显示结果,该结果为随机数,所以每次显示均不一样。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8b13632762d0f7036e4180f506fa513d2697c52c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、在c6单元格上使用格式填充柄将下方有淡绿色底纹的单元格全部选中,可以得到若干随机数。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/21a4462309f79052952c501702f3d7ca7bcbd5e3?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
本回答被网友采纳