计算机二级excel练习_精品文档表格文件下载.xls

计算机二级excel练习_精品文档表格文件下载.xls

《计算机二级excel练习_精品文档表格文件下载.xls》由会员分享，可在线阅读，更多相关《计算机二级excel练习_精品文档表格文件下载.xls（2页珍藏版）》请在冰豆网上搜索。

折折扣扣表表价价格格表表数数量量折折扣扣率率说说明明类类别别单单价价000%0-99件的折扣率衣衣服服1201001006%100-199件的折扣率裤裤子子802002008%200-299件的折扣率鞋鞋子子15030030010%300件的折扣率采采购购表表项项目目采采购购数数量量采采购购时时间间单单价价折折扣扣合合计计衣服202008/1/1212002,400.00裤子452008/1/128003,600.00鞋子702008/1/12150010,500.00衣服1252008/2/51200.0614,100.00裤子1852008/2/5800.0613,912.00鞋子1402008/2/51500.0619,740.00衣服2252008/3/141200.0824,840.00裤子2102008/3/14800.0815,456.00鞋子2602008/3/141500.0835,880.00衣服3852008/4/301200.141,580.00裤子3502008/4/30800.125,200.00鞋子3152008/4/301500.142,525.00衣服252008/5/1512003,000.00裤子1202008/5/15800.069,024.00鞋子3402008/5/151500.145,900.00衣服2652008/6/241200.0829,256.00裤子1252008/6/24800.069,400.00鞋子1002008/6/241500.0614,100.00衣服3202008/7/101200.134,560.00裤子4002008/7/10800.128,800.00鞋子1252008/7/101500.0617,625.00衣服3852008/8/191200.141,580.00裤子2752008/8/19800.0820,240.00鞋子2402008/8/191500.0833,120.00衣服3602008/9/271200.138,880.00裤子3252008/9/27800.123,400.00鞋子1202008/9/271500.0616,920.00衣服2952008/10/241200.0832,568.00裤子1552008/10/24800.0611,656.00鞋子2102008/10/241500.0828,980.00衣服3952008/11/41200.142,660.00裤子1602008/11/4800.0612,032.00鞋子2752008/11/41500.0837,950.00统统计计表表统统计计类类别别总总采采购购量量总总采采购购金金额额衣衣服服2800305424裤裤子子鞋鞋子子