电脑基本技能考题新发地房地产

/电脑基本技能考题共6题，每题20分，总120分（第5题为附加题）考题内容都是我自己出的，如有错误疏漏或者描述不清可以找我问，同时请大家海涵1、用自己的编号一直减去100，直到减到小于等于108为止，例如我的编号为393，则393-100-100-100=93≤108，93为我的编号，搜索对应的水浒传第93位人物的名字，然后按照下图示例建立，，将存储为2003版本，命名为部门+姓名+日期。涉及到的操作有：建立表格、根据窗口调整表格、平均分布各行、各列、插入图片并调整图片大小、字体调整（统一为小四仿宋）、加粗居中、调整边框粗细、1.5倍行距等）。2、将后附的地产人员编号表（附1）复制到表，并增加两个，第一个命名为“本部门人员”，作出属于本部门的人员名单；第二个命名为“先后进入公司人员”，作出编号小于及大于自己最近的5个人（连同自己共计11人）的名单，并将编号转为数字求和。将存储为2003版本，命名为部门+姓名+日期。涉及到的操作有：筛选、行高调整（统一30）、列宽调整（统一20）、字体调整（统一为18仿宋）、加粗居中、加边框、序列填充、求和等）。注：以上两题均需要用到编号，如尚无编号的可以使用本人号最后三位代替。3、用手机给自己拍个自拍照，利用自带画图工具或者其他工具截取大头贴，将图像调整宽度为333像素（高度像素不限，保持长宽比），在图像下面写上自己名字（字体、大小不限），将图片另存为格式，命名为部门+姓名+日期。4、下载一首你最喜欢的歌（3格式），将歌曲重命名为歌名+演唱者姓名。5、将后附的坐标点（附2）在中生成一个闭合图形，图形用任意颜色填充后将图形面积折算成亩标注到图形内，之后将图形另存为2004格式，命名为部门+姓名+日期。（该题可能稍有难度，为附加题，非工程人员不答此题）6、新建一个文件夹，重命名为部门+姓名+日期，将以上所有文件放入文件夹并压缩，将压缩完毕后的文件夹用自己的邮箱（或其他邮箱）发送到我（）、陈晓航（）及本部门负责人邮箱，要求发送时要显示所有收件人。提示：文件夹中应包含1个文件、1个文件、1个文件、1个3文件、1个文件（非工程人员不含），共计5个文件。附1：地产人员编号所属部门姓名人员编号质量安全部安辉000058工程管理部鲍玉辉000650工程管理部毕志伟000218开发设计部曹健000241营销部曹杏敏000085营销部柴学丽000084营销部柴学琳000040工程管理部陈建华000177工程管理部陈朋000098成本部陈西000143综合管理部陈晓航000249开发设计部程亮000223质量安全部崔景呈000310营销部董金婷000469工程管理部杜宝利000099财务部顿佳欢000290营销部范志翾000216成本部冯超000129工程管理部冯建芳000172营销部高荣芳000274工程管理部高晓伟000685工程管理部高艳青000237开发设计部葛卫亮000128营销部谷文倩000261营销部郭宏泽000170质量安全部韩志彬000615工程管理部黄烁000087工管中心嵇茂林000889开发设计部姜大力000225总裁办焦洪涛000079工程管理部解爱华000081营销部靳新月000827工程管理部李红利000222工程管理部李华伟000624营销部李佳乐000169营销部李建南000130开发设计部李美江000088开发设计部李琦000258成本部李舜000247成本部李薛祎000680成本部李跃000073成本部历艳林000122工程管理部梁贺000664财务部梁永霞000597质量安全部蔺鑫000607工程管理部刘红军000092营销部刘嘉文000660工程管理部刘建涛000052工程管理部刘江永000539工程管理部刘淼000770工程管理部刘楠000641营销部刘双胜000217营销部刘晓涛000158成本部刘亚楠000082营销部刘杨000148工程管理部刘泽民000066工程管理部刘战军000068工程管理部刘志霞000432营销部卢静000168成本部路晓萍000232工管中心罗建永000060营销部罗琳000175工程管理部马海亮000215工程管理部马金刚000581工程管理部马圣涛000869工程管理部马晓龙000047工程管理部牛奥林000273财务部牛美玲000277工管中心瞿春金000599成本部冉振莽000566工程管理部任继春000054质量安全部任毓强000030质量安全部时波涛000229成本部史军伟000278营销部史新颖000035营销部宋佳星000171成本部宋雅云000042工程管理部苏东升000596质量安全部唐丽萍000656质量安全部田良000547营销部田野000101工管中心王大伟000393成本部王耕蕾000155工程管理部王洪全000609开发设计部王虎000078工程管理部王建潮000794成本部王琦000227工管中心王山000891质量安全部王思涯000570质量安全部王小东000627成本部王晓叶000046成本部王秀丽000636开发设计部王玉秋000585质量安全部王远征000669营销部王洲000095营销部吴景迪000156工程管理部吴天伟000363开发设计部吴天宇000603开发设计部吴艳珍000192开发设计部武毅000089成本部夏亚秋000139成本部许蕾000094工程管理部薛吉华000161成本部闫亮000283工管中心闫世方000003工程管理部闫世新000113质量安全部杨春辉000617质量安全部杨春庆000219工程管理部杨继才000860营销部杨乐宇000157工程管理部杨硕000262开发设计部杨松000224营销部杨新颖000167工程管理部杨再丰000069财务部尹威娜000165开发设计部袁海民000067开发设计部张保000077营销部张迪2000236开发设计部张栋博000213成本部张金哲000138营销部张静1000091工程管理部张昆000652工程管理部张磊000667质量安全部张立博000315成本部张莉莉000365营销部张萌000605工程管理部张世敏000201成本部张微微000118开发设计部张逍3000668开发设计部张晓京000269工程管理部张学朝000025工程管理部张宇000075开发设计部张圆圆000645工程管理部赵琛000793营销部赵丹丹000163工程管理部赵圣英000451开发设计部赵伟1000233开发设计部钟春美000314工程管理部周洪海000057成本部周伟建000071营销部祖晓东000093附2：坐标点J001,1,39498206.376,4492325.554J002,1,39498237.928,4492315.794J003,1,39498326.269,4492291.707J004,1,39498333.56,4492386.989J005,1,39498575.067,4492351.026J006,1,39498573.799,4492410.023J007,1,39498586.484,4492545.245J008,1,39498571.617,4492547.866J009,1,39498571.18,4492572.327J010,1,39498651.378,4492567.935J011,1,39498703.972,4492562.765J012,1,39498743.978,4492557.351J013,1,39498737.394,4492511.401J014,1,39498801.738,4492495.496J015,1,39498804.99,4492474.982J016,1,39498819.864,4492472.099J017,1,39498815.202,4492448.369J018,1,39498797.441,4492448.812J019,1,39498793.445,4492429.296J020,1,39498842.685,4492418.611J021,1,39498851.329,4492334.948J022,1,39498766.636,4492351.433J023,1,39498748.193,4492302.706J024,1,39498748.193,4492302.706J025,1,39498870.233,4492271.451J026,1,39498875.94,4492261.43J027,1,39498877.611,4492248.672J028,1,39498879.864,4492217.423J029,1,39498879.111,4492181.718J030,1,39498872.663,4492149.507J031,1,39498874.071,4492132.809J032,1,39498875.699,4492094.822J033,1,39498876.94,4492082.231J034,1,39498883.557,4492069.54J035,1,39498886.92,4492046.969J036,1,39498887.642,4492045.401J037,1,39498888.825,4492044.221J038,1,39498887.148,4492042.66J039,1,39498690.262,4492059.784J040,1,39498686.517,4491957.179J041,1,39498728.202,4491918.555J042,1,39498761.738,4491845.755J043,1,39498794.009,4491811.097J044,1,39498806.508,4491955.136J045,1,39498891.984,4491955.136J046,1,39498923.108,4491960.966J047,1,39498929.817,4491942.207J048,1,39498940.447,4491906.636J049,1,39498935.855,4491904.686J050,1,39498932.975,4491904.024J051,1,39498931.654,4491903.009J052,1,39498930.321,4491900.343J053,1,39498930.625,4491893.872J054,1,39498933.81,4491884.233J055,1,39498973.663,4491818.872J056,1,39499009.751,4491799.337J057,1,39499012.344,4491790.756J058,1,39499015.268,4491787.173J059,1,39499017.484,4491787.447J060,1,39499020.803,4491789.141J061,1,39499023.955,4491788.106J062,1,39499042.487,4491773.318J063,1,39499057.103,4491750.876J064,1,39499063.507,4491728.958J065,1,39499059.983,4491715.249J066,1,39499065.405,4491701.987J067,1,39499079.638,4491658.879J068,1,39499079.607,4491606.641J069,1,39499055.925,4491614.259J070,1,39499039.46,4491612.573J071,1,39499021.82,4491616.455J072,1,39499012.86,4491613.188J073,1,39499008.907,4491607.579J074,1,39499010.334,4491594.786J075,1,39499027.277,4491574.659J076,1,39499030.644,4491562.577J077,1,39499029.327,4491555.175J078,1,39499025.378,4491546.963J079,1,39499009.579,4491530.021J080,1,39499003.819,4491525.279J081,1,39498995.654,4491521.359J082,1,39498982.409,4491520.938J083,1,39498970.049,4491524.314J084,1,39498961.912,4491523.964J085,1,39498954.148,4491519.731J086,1,39498948.935,4491515.228J087,1,39498941.055,4491502.752J088,1,39498936.272,4491497.352J089,1,39498928.997,4491495.084J090,1,39498914.196,4491496.581J091,1,39498887.48,4491514.71J092,1,39498861.381,4491542.586J093,1,39498849.242,4491553.253J094,1,39498819.51,4491576.83J095,1,39498809.853,4491585.17J096,1,39498799.43,4491603.911J097,1,39498791.735,4491622.867J098,1,39498782.719,4491651.264J099,1,39498780.04,4491674.374J100,1,39498785.271,4491689.26J101,1,39498786.733,4491702.188J102,1,39498781.011,4491718.122J103,1,39498776.384,4491719.338J104,1,39498770.905,4491717.757J105,1,39498765.791,4491710.824J106,1,39498762.625,4491706.324J107,1,39498755.563,4491684.309J108,1,39498752.27,4491657.991J109,1,39498754.103,4491636.277J110,1,39498764.33,4491605.932J111,1,39498784.8,4491567.04J112,1,39498799.181,4491546.422J113,1,39498808.568,4491535.768J114,1,39498818.167,4491525.787J115,1,39498825.45,4491513.295J116,1,39498827.751,4491505.376J117,1,39498828.216,4491494.455J118,1,39498822.345,4491484.017J119,1,39498806.587,4491468.943J120,1,39498793.674,4491451.878J121,1,39498780.939,4491443.568J122,1,39498769.231,4491443.466J123,1,39498753.174,4491452.043J124,1,39498721.406,4491450.5J125,1,39498709.544,4491452.432J126,1,39498701.034,4491456.425J127,1,39498685.561,4491470.077J128,1,39498678.857,4491471.108J129,1,39498670.582,4491465.937J130,1,39498665.252,4491457.065J131,1,39498651.231,4491435.623J132,1,39498641.369,4491430.062J133,1,39498630.235,4491432.048J134,1,39498611.058,4491450.978J135,1,39498603.015,4491464.493J136,1,39498602.268,4491478.212J137,1,39498609.519,4491511.607J138,1,39498609.23,4491530.727J139,1,39498601.018,4491553.301J140,1,39498602.971,4491574.512J141,1,39498598.538,4491577.727J142,1,39498592.344,4491577.181J143,1,39498587.122,4491572.268J144,1,39498583.644,4491556.176J145,1,39498590.385,4491520.507J146,1,39498589.445,4491512.23J147,1,39498584.064,4491504.039J148,1,39498581.587,4491502.503J149,1,39498573.643,4491501.991J150,1,39498568.689,4491503.442J151,1,39498557.414,4491510.268J152,1,39498550.204,4491510.449J153,1,39498547.242,4491510.18J1