上机平台

Questions Tags Users

excel操作实训

Asked Jun 5, 2025 Modified Jan 1, 0001
Viewed 154
2310

image.png

任务一:请将形如“2020年10月3日”这样的日期,在excel中使用text函数,转换为“2020-10-03”这样的格式

任务二:给出年份,判断其是闰年还是平年
闰年和平年的区别

edited Jan 1, 0001
廖隆标26
asked Jun 5, 2025
9 Answers

edited Jan 1, 1970
侯志武1
answered Jun 5, 2025

edited Jan 1, 1970
夏世锦1
answered Jun 5, 2025

image.png

edited Jan 1, 1970
刘子轩1
answered Jun 5, 2025

edited Jan 1, 1970
李奧1
answered Jun 5, 2025

edited Jan 1, 1970
李晶晶1
answered Jun 5, 2025

edited Jan 1, 1970
潘颂雯1
answered Jun 5, 2025

捕获2.PNG

edited Jan 1, 1970
李施琪1
answered Jun 5, 2025

image.png

edited Jan 1, 1970
任年旺1
answered Jun 16, 2025

image.png

edited Jan 1, 1970
xiaoyue1
answered Jun 19, 2025
Related Questions

Powered by Answer - the open-source software that powers Q&A communities.
Made with love © 2026 上机平台.