计算机二级练习题excel

1、房房产产销销售售表表姓姓名名联联系系电电话话新新电电话话号号码码出出生生日日期期闰闰年年楼楼号号面面积积郎怀民5782874587828741965/11/12否7-101125.12谷金力5779512587795121973/1/31否7-102158.23张南玲5755735587557351962/5/21否7-201125.12邓云5754110587541101960/6/26是7-202158.23贾丽娜5763371587633711964/4/17是7-301125.12万基莹5743343587433431969/9/5否7-302158.23吴冬玉575900858759

2、0081976/4/9是7-401125.12项文双5808998588089981970/1/20否7-402158.23徐华5805148588051481975/5/10否7-501125.12罗金梅5714219587142191962/6/9否7-502158.23齐明5712941587129411958/9/9否7-601125.12赵援5766408587664081949/8/21否7-602158.23罗颖5722745587227451948/10/6是7-701125.12张永和5734228587342281977/1/6否7-702158.23陈平574823858

3、7482381965/1/23否7-801125.12谢彦5787544587875441968/4/23是7-802158.23明小莉5715830587158301954/2/24否7-901125.12张立娜5752751587527511970/1/3否7-902158.23董江波5746176587461761948/8/1是7-1001125.12张力宏5801702588017021968/10/2是7-1002158.23简红强5728988587289881976/3/3是7-1101216.65何再前5725276587252761960/1/10是7-1102259.28

4、蔡立5753690587536901956/5/1是7-1201216.65黄芯5715138587151381956/4/9是7-1202259.28契税统计面积户数125.1210158.2310216.652259.282单单价价契契税税房房价价总总额额契契税税总总额额销销售售代代表表68211.50%853443.5212801.65赵倩蓉70243.00% 1111407.5233342.23王思文72271.50%904242.2413563.63赵倩蓉74303.00% 1175648.9035269.47罗天明76331.50%955040.9614325.61王思文78363

5、.00% 1239890.2837196.71王思文80391.50% 1005839.6815087.60李艳秋82423.00% 1304131.6639123.95李艳秋84451.50% 1056638.4015849.58罗天明86483.00% 1368373.0441051.19赵倩蓉88511.50% 1107437.1216611.56王思文90543.00% 1432614.4242978.43赵倩蓉92571.50% 1158235.8417373.54罗天明94603.00% 1496855.8044905.67赵倩蓉96631.50% 1209034.5618135.

6、52罗天明98663.00% 1561097.1846832.92王思文100691.50% 1259833.2818897.50赵倩蓉102723.00% 1625338.5648760.16赵倩蓉104751.50% 1310632.0019659.48李艳秋106783.00% 1689579.9450687.40李艳秋108815.00% 2357368.65117868.43王思文110845.00% 2873859.52143692.98赵倩蓉112875.00% 2445328.55122266.43王思文114905.00% 2979127.20148956.36李艳秋契税总额

7、162305.664420148.119240134.86292649.336房房产产销销售售表表契税统计房产销售表姓名联系电话新电话号码 出生日期闰年楼号面积单价吴冬玉5759008587590081976/4/9 是7-401125.128039项文双5808998588089981970/1/20 否7-402158.238242董江波5746176587461761948/8/1 是7-1001125.1210475张力宏5801702588017021968/10/2 是7-1002158.2310678黄芯5715138587151381956/4/9 是7-1202259.281

8、1490邓云5754110587541101960/6/26 是7-202158.237430徐华5805148588051481975/5/10 否7-501125.128445罗颖5722745587227451948/10/6 是7-701125.129257陈平5748238587482381965/1/23 否7-801125.129663谷金力5779512587795121973/1/31 否7-102158.237024贾丽娜5763371587633711964/4/17 是7-301125.127633万基莹5743343587433431969/9/5 否7-302158

9、.237836齐明5712941587129411958/9/9 否7-601125.128851谢彦5787544587875441968/4/23 是7-802158.239866简红强5728988587289881976/3/3 是7-1101216.6510881蔡立5753690587536901956/5/1 是7-1201216.6511287郎怀民5782874587828741965/11/12 否7-101125.126821张南玲5755735587557351962/5/21 否7-201125.127227罗金梅5714219587142191962/6/9 否7-

10、502158.238648赵援5766408587664081949/8/21 否7-602158.239054张永和5734228587342281977/1/6 否7-702158.239460明小莉5715830587158301954/2/24 否7-901125.1210069张立娜5752751587527511970/1/3 否7-902158.2310272何再前5725276587252761960/1/10 是7-1102259.2811084契税房价总额契税总额销售代表1.50%1005839.6815087.60李艳秋3.00%1304131.6639123.95李艳秋

11、1.50%1310632.0019659.48李艳秋3.00%1689579.9450687.40李艳秋5.00%2979127.20148956.36李艳秋8289310.48李李艳艳秋秋 汇汇总总3.00%1175648.9035269.47罗天明1.50%1056638.4015849.58罗天明1.50%1158235.8417373.54罗天明1.50%1209034.5618135.52罗天明4599557.70罗罗天天明明 汇汇总总3.00%1111407.5233342.23王思文1.50%955040.9614325.61王思文3.00%1239890.2837196.71王

12、思文1.50%1107437.1216611.56王思文3.00%1561097.1846832.92王思文5.00%2357368.65117868.43王思文5.00%2445328.55122266.43王思文10777570.26王王思思文文 汇汇总总1.50%853443.5212801.65赵倩蓉1.50%904242.2413563.63赵倩蓉3.00%1368373.0441051.19赵倩蓉3.00%1432614.4242978.43赵倩蓉3.00%1496855.8044905.67赵倩蓉1.50%1259833.2818897.50赵倩蓉3.00%1625338.564

13、8760.16赵倩蓉5.00%2873859.52143692.98赵倩蓉11814560.38赵赵倩倩蓉蓉 汇汇总总35480998.82总总计计汇总李艳秋罗天明王思文赵倩蓉050000100000150000200000250000300000350000400000450000汇总求和项:契税总额销售代表汇总李艳秋273514.7832罗天明86628.099王思文388443.8806赵倩蓉366651.2162总计1115237.979请完成以下操作：1.使用IF函数自动填写“契税栏”，标准：面积小于140的，契税1.5%；小于200但大于等于140的，契税3%；其他面积的契税为5%.使用公式自动填写“房价总额”，使用数组公式填写“契税总额”.2.使用COUNTIF和SUMIF函数统计不同面积房屋的户数和契税总额，结果填入契税统计表。3.将“联系电话”升位并填入“新电话号