今天分享几个统计成绩常用的Excel函数公式,让分数统计分析变得不再麻烦,可以直接套用哟!当然也可以用于公司销售业绩统计分析。
01.计算总分
计算总分也就是对每一名学生的三科分数进行求和,以前讲过Alt+=键可以快速求和,今天要分享的是求和公式。
在H2单元格输入公式:
2025年07月25日
今天分享几个统计成绩常用的Excel函数公式,让分数统计分析变得不再麻烦,可以直接套用哟!当然也可以用于公司销售业绩统计分析。
计算总分也就是对每一名学生的三科分数进行求和,以前讲过Alt+=键可以快速求和,今天要分享的是求和公式。
在H2单元格输入公式:
2025年07月25日
2025年07月25日
The People's Government of Daoxian County successfully challenged the Guinness World Record for "Dragon Boat Race with the Largest Number of Participants" on June 2, 2024. The Guinness World Records judge confirmed on the site that the number of participating dragon boats reached 212. The photo shows dragon boats mustering on the Xiaoshui River in Daoxian County on that day. (Photo/Jiang Keqing)
2025年07月25日
The aerial photo above, taken on August 28, shows the Xiaodukou Pumping Station (the high-rise part of the building that spans the river) and its sluice gates in Xiaodukou Town, Lixian County. The Xiaodukou Pumping Station was tested for drainage on the same day. The construction of the pumping station started in October 2019. It is currently the largest of its kind in Hunan Province. The pumping station is designed to discharge a flow of 294 cubic meters per second, with six generators and an installed capacity of 20,700 kilowatts. After put into operation, it can benefit Lixian County, Jinshi City, Linli County, and the Cendan Farm, covering a protection area of 785 square kilometers. (Photo/Bo Yipu and Xiao Lihua)
2025年07月25日
3月1日,香港启德体育园正式启用。该项目占地28公顷,包含5万座主场馆、1万座体艺馆及5000座青年体育场三大核心场馆,是香港规模最大的体育及文娱综合体,将作为第十五届全国运动会重要赛事场地,进一步提升香港承办国际大型活动的能力。
Kai Tak Sports Park commenced operations today. Spanning 28 hectares, the project comprises three core venues: a 50,000-seat main stadium, a 10,000-seat multipurpose arena, and a 5,000-seat youth sports ground. As the city's largest integrated sports and entertainment complex, it will serve as a key venue for the 15th National Games, further bolstering Hong Kong's capacity to host major international events.
2025年07月25日
2021-01-21 | China Economic Net
China's online retail sales of goods rose 14.8 percent year on year to 9.8 trillion yuan (about 1.5 trillion U.S. dollars) in 2020, data from the Ministry of Commerce (MOC) showed Tuesday.
2025年07月25日
每个合数都可以写成几个质数相乘的形式,其中每个质数都是这个合数的因数,叫做这个合数的分解质因数。 分解质因数只针对合数。今天算法是关于质因数分解的,其中我们不仅要有一个函数用于判断质数,还要把一个比较大的数字分解出他的质因数,并得到那个最大的质因数。
A003. Largest prime factor
2025年07月25日
At noon on April 10, the world's largest container ship "Mediterranean Irina" (MSCIRINA) developed independently by China berthed at the Nansha Phase II Container Terminal in Guangzhou Port. Only 17 days later, the ship with a maximum loading capacity of 24,346 TEUs once again broke the historical record of the largest container ship docked in Nansha Port.
2025年07月25日
In 2024, Shandong Port Group hit a major milestone, handling over 1.8 billion tons of cargo and 44 million TEUs. This pushed Shandong’s coastal ports past 2 billion tons, securing its top spot among China’s coastal provinces for the third year running. In 2025, Qingdao Port, a key subsidiary, set its 13th global efficiency record for automated container terminals, cementing its industry leadership.
2025年07月25日
LCP 全称 “Largest Contentful Paint”,翻译为“最大内容绘制”,用于监控网页可视区内“绘制面积”最大的元素开始呈现在屏幕上的时间点。
最大内容绘制,LCP(Largest Contentful Paint),用于记录视窗内最大的元素绘制的时间,该时间会随着页面渲染变化而变化,因为页面中的最大元素在渲染过程中可能会发生改变,另外该指标会在用户第一次交互后停止记录。
Powered By Z-BlogPHP 1.7.4
蜀ICP备2024111239号-43