"一、单元格设置法:<br><br><li>01<br>打开一个工作样表作为例子。<br><br><img src=""https://pic.wenwen.soso.com/pqpic/wenwenpic/0/20210324005804-666441745_jpeg_600_457_50077/0""/><br><br><li>02<br>在单元格上点击鼠标右键,选择设置单元格格式。<br><br><img src=""https://pic.wenwen.soso.com/pqpic/wenwenpic/0/20210324005804-1462656128_jpeg_600_307_36547/0""/><br><br><li>03<br>将单元格设置为数值,并将小数位数设置为0。<br><br><img src=""https://pic.wenwen.soso.com/pqpic/wenwenpic/0/20210324005805-2129120519_jpeg_593_586_35781/0""/><br><br><li>04<br>点击格式刷命令。<br><br><li>05<br>下拉所有单元格完成设置。<br><br><img src=""https://pic.wenwen.soso.com/pqpic/wenwenpic/0/20210324005806-1410435688_jpeg_600_307_33492/0""/><br><br>二、函数法:<br><li>01<br>切换到公式标签。<br><br><img src=""https://pic.wenwen.soso.com/pqpic/wenwenpic/0/20210324005806-466736558_jpeg_600_457_51864/0""/><br><br><li>02<br>在数学和三角函数中点击roundup函数。<br><br><img src=""https://pic.wenwen.soso.com/pqpic/wenwenpic/0/20210324005807-2136369601_jpeg_600_368_39988/0""/><br><br><li>03<br>第一个参数选择引用单元格。<br><br><img src=""https://pic.wenwen.soso.com/pqpic/wenwenpic/0/20210324005808-1016287077_jpeg_600_307_25743/0""/><br><br><li>04<br>第二个参数设置为0,点击确定。<br><br><img src=""https://pic.wenwen.soso.com/pqpic/wenwenpic/0/20210324005809-581009676_jpeg_600_307_27665/0""/><br><br><li>05<br>下拉填充单元格,完成进一位取整操作。<br><br>Excel的主要功能是:<br>1:建立电子表格<br>2:数据管理<br><br>3:制作图表<br>4:数据网上共享"
"这个不需要什么公式,在相应要取数的单元格里输入“=”,<br><img src=""https://iknow-pic.cdn.bcebos.com/5243fbf2b2119313970df8c569380cd791238d7c?x-bce-process=image/resize,m_lfit,w_600,h_800,limit_1"" max-height=""200""><br>然后鼠标选择相对应的表格单元格中的内容<br><img src=""https://iknow-pic.cdn.bcebos.com/b999a9014c086e06fcc1383e0e087bf40ad1cb5e?x-bce-process=image/resize,m_lfit,w_600,h_800,limit_1"" max-height=""200""><br>最后点“Enter”键就可以<br><img src=""https://iknow-pic.cdn.bcebos.com/9345d688d43f8794362d4f5bde1b0ef41ad53af0?x-bce-process=image/resize,m_lfit,w_600,h_800,limit_1"" max-height=""200"">"