![](https://img.haomeiwen.com/i7459195/cd9c7aecac8c3930.jpg)
![](https://img.haomeiwen.com/i7459195/aff17a98d7ef498b.jpg)
![](https://img.haomeiwen.com/i7459195/b4260cd8faafb38a.jpg)
![](https://img.haomeiwen.com/i7459195/d68d5029a7eabd64.jpg)
![](https://img.haomeiwen.com/i7459195/00d693268da5216c.jpg)
![](https://img.haomeiwen.com/i7459195/4f8dbbc24072552e.jpg)
查找某人在编辑
![](https://img.haomeiwen.com/i7459195/d106073a0e393a40.jpg)
![](https://img.haomeiwen.com/i7459195/3a0d51f96c7ef0d9.jpg)
不记得用*代替
排序谁定谁,点上方升降序
按班级,学科排
![](https://img.haomeiwen.com/i7459195/53237ec8202bfd8f.jpg)
![](https://img.haomeiwen.com/i7459195/53a4421cf7a6ab99.jpg)
三科总分,先建单元格,第一行入=,点语十数+外再回车出数放右下角变小十再双击或拖动
粗十是选定,虚线十是可拖动,右下十是合并计算
![](https://img.haomeiwen.com/i7459195/d628d13eb94adcac.jpg)
![](https://img.haomeiwen.com/i7459195/48aa873f75f7ec12.jpg)
先点个单元格第二行再点∑,其他函教,ranK,转到或插入,函数,选ranK,点转到确定,第一个同学的成绩
![](https://img.haomeiwen.com/i7459195/904572e397fe0fce.jpg)
第二行变向下箭头
![](https://img.haomeiwen.com/i7459195/c09c87c302d6999e.jpg)
再双击
![](https://img.haomeiwen.com/i7459195/816971816d0e0835.jpg)
班级平均中间分一行,数据,合并计算,首行首列,选科目拖动,确定,
![](https://img.haomeiwen.com/i7459195/d02d5633336448de.jpg)
设置单元格,数值,小数,排序
![](https://img.haomeiwen.com/i7459195/c5317979f6d758fd.jpg)
![](https://img.haomeiwen.com/i7459195/23a7bf282a84ee1a.jpg)
![](https://img.haomeiwen.com/i7459195/17cd7e73ec11350f.jpg)
查找某人在编辑
不记得用*代替
排序谁定谁,点上方升降序
按班级,学科排
三科总分,先建单元格,第一行入=,点语十数+外再回车出数放右下角变小十再双击或拖动
粗十是选定,虚线十是可拖动,右下十是合并计算
先点个单元格第二行再点∑,其他函教,ranK,转到或插入,函数,选ranK,点转到确定,第一个同学的成绩
第二行变向下箭头
再双击
班级平均中间分一行,数据,合并计算,首行首列,选科目拖动,确定,
设置单元格,数值,小数,排序
本文标题:EXCEL学习
本文链接:https://www.haomeiwen.com/subject/qnnmbxtx.html
网友评论