计算机应用基础实训项目三excel 综合应用答案2043

Sheet1 1-8月累计 客户名称 收入(万) 在用机架 新增机架 在用带宽(M) 新增带宽(M) 每个机架平均费用 超过一个亿的客户列 表 关于同志近三年现实表现材料材料类招标技术评分表图表与交易pdf视力表打印pdf用图表说话 pdf 客户1 330,304 16,939 4,087 14,695,621.6 4,772,852 3303.04 客户1 客户2 279,792 11,816 2,362 11,073,999.2 2,774,229 2797.92 客户2 客户3 135,334 3,034 624 5,551,024.0 1,392,944 1353.34 客户3 客户4 30,040 2,693 405 87,264.0 62,688 300.4 客户4 客户5 24,397 2,452 883 181,920.0 10,240 243.97 客户5 客户6 18,078 637 148 1,858,000.0 370,960 180.78 客户6 客户7 13,733 583 134 589,792.0 212,192 137.33 客户7 客户8 7,878 222 47 199,000.0 41,000 78.78 客户9 7,266 387 91 85,000.0 1,000 72.66 客户10 5,296 441 259 146,000.0 46,000 52.96 客户11 4,119 190 90 54,000.0 21,000 41.19 客户12 3,802 279 29 15,000.0 0 38.02 客户13 3,035 283 63 159,920.0 40,960 30.35 客户14 967 28 7 20,000.0 0 9.67 客户15 230 7 0 80,000.0 20,000 2.3 客户16 0 0 0 0.0 0 0 客户17 0 0 0 0.0 0 0 客户18 0 0 0 0.0 0 0 客户19 0 0 0 0.0 0 0 客户20 0 0 0 0.0 0 0 总计 864,271 39,991 9,229 34,796,540.8 9,766,065 平均 8月 收入(万) 在用机架 新增机架 在用带宽(M) 新增带宽 7月 44,134 4,219 346 3,644,244 491,232 37,141 2,230 318 3,902,836.80 1,021,787.20 45,285 3,873 370 3,153,012 806,896 20,418 624 22 1,392,944 215,648 36,224 1,912 101 2,881,049.60 365,952 3,566 1,056 255 12,288 0 18,403 602 48 1,177,296 295,824 3,166 232 15 60,640 0 3,386 801 57 12,288 0 2,955 182 24 490,264 118,352 2,940 217 139 60,640 0 1,738 100 2 92,888 9,000 2,419 158 63 371,912 8,000 1,136 49 12 60,000 20,000 1,841 98 6 83,888 18,432 929 91 10 1,000 0 920 81 11 1,000 0 508 349 257 0 0 885 37 3 40,000 0 501 0 0 0 0 501 0 0 0 0 371 90 0 15,000 0 459 90 0 15,000 3,000 82 0 0 73,960 0 422 92 0 0 0 43 0 0 20,000 0 341 0 0 73,960 40,960 43 7 0 0 0 83 7 0 0 0 0 0 0 0 0 47 0 0 20,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 6月 5月 42,990 1,811 343 2,515,097.60 1,659,008 41,274 3,028 457 1,815,716 309,980 41,108 3,503 475 2,346,116 530,400 35,848 1,468 280 856,089.60 319,680 17,333 554 62 881,472 101,376 17,062 492 154 780,096 194,304 3,362 744 55 12,288 12,288 3,411 38 2 50,400 50,400 3,121 78 40 60,640 10,240 3,169 689 241 0 0 1,945 95 9 363,912 47,104 2,737 86 32 316,808 96,256 1,865 92 0 65,456 4,096 1,725 92 27 61,360 2,000 983 34 15 40,000 0 946 19 9 40,000 0 911 70 7 1,000 0 914 63 24 1,000 0 768 0 0 33,000 0 510 90 0 12,000 6,000 501 0 0 0 0 504 0 0 33,000 12,000 460 92 29 0 0 501 0 0 0 0 324 90 0 12,000 0 438 63 18 0 0 69 7 0 0 0 84 7 0 0 0 49 0 0 20,000 0 51 0 0 20,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4月 3月 41,198 2,571 1,920 1,505,736 689,760 38,746 651 120 815,976 84,992 33,371 1,188 496 536,409.60 222,768 32,544 692 183 313,641.60 133,529.60 17,531 338 84 585,792 207,168 17,299 254 141 378,624 201,224 3,549 36 27 0 0 4,543 9 0 0 0 3,029 448 103 0 0 3,016 345 113 0 0 2,240 65 2 59,360 9,000 2,114 18 0 92,248 0 2,001 54 36 220,552 128,304 1,554 63 4 50,360 35,072 917 39 0 1,000 0 1,027 0 0 21,000 0 910 10 8 40,000 0 921 39 0 1,000 0 745 0 0 21,000 0 761 2 2 40,000 0 640 90 85 6,000 6,000 501 0 0 0 0 501 0 0 0 0 496 5 0 0 0 389 45 13 0 0 400 32 5 0 0 281 7 7 0 0 114 0 0 0 0 13 0 0 20,000 20,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2月 1月 37,260 531 276 730,984 216,128 38,266 255 255 514,856 514,856 32,049 509 195 180,112 122,368 32,424 314 314 57,744 57,744 14,791 113 56 177,400 0 14,512 57 57 177,400 177,400 4,144 9 9 0 0 4,259 0 0 0 0 3,084 232 21 0 0 3,098 211 211 0 0 2,081 18 3 92,248 21,000 2,123 15 15 71,248 71,248 1,479 59 34 15,288 15,288 1,427 25 25 0 0 966 0 0 21,000 6,000 1,199 0 0 15,000 15,000 924 39 1 1,000 1,000 916 38 38 0 0 736 0 0 40,000 40,000 774 0 0 0 0 520 5 0 0 0 535 5 5 0 0 500 0 0 0 0 500 0 0 0 0 392 27 1 0 0 410 26 26 0 0 126 0 0 0 0 127 0 0 0 0 0 0 0 0 0 23 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0