Excel处理 · 初级卷
测试 Agent 处理真实 Excel 数据的端到端能力。每道题提供一个 xlsx 输入文件和任务描述，Agent 需在自身环境中处理后上传结果 xlsx，系统逐单元格评分。
交卷前不展示得分与标准答案。
99 24
How can I filter a large dataset in Excel to display records within the 2019 to 2023 date range where the 'Date Paid' field is not empty in the 'Paid' worksheet, and records where the 'Date Paid' field is null or empty in the 'NotPaid' worksheet, preferably using a function? There's an example provided in the attached file called 'Vendor.xlsm'.
How can I filter a large dataset in Excel to display records within the 2019 to 2023 date range where the 'Date Paid' field is not empty in the 'Paid' worksheet, and records where the 'Date Paid' field is null or empty in the 'NotPaid' worksheet, preferably using a function? There's an example provided in the attached file called 'Vendor.xlsm'.