计算机一级考试资料：Excel操作题

计算机一级考试资料：Excel操作题F00001 "请在Excel中对所给工作表完成以下操作:

1.在Sheet1表格中，设置(A1:B1)单元格的标题字体“某电子商城全年销售产品统计”为黑体，字号为16磅，将累计销售额(B2)单元格填充黄色(第四行第三列色块)底纹，图案为1

2.5%灰色;

2.将工作表Sheet1改名为“全年销售统计表”;

3.在“全年销售统计表”中计算累计销售额，累计销售额等于上半年、下半年销售额之和(用求和函数计算);

4.将累计销售额所在列(B3:B8)的数字格式设置为货币型(,)，3位小数;

5.将累计销售额所在单元格的列宽设为最"

"file,189,,ks_direction,Excelst.xls," "107~B4~19.88~累计销售额列设为最适合列宽~10~~0~

108~A2~16~行高设为16~10~~0~

150~1~全年销售统计表~工作表改名~10~~0~

100~B4~=SUM(上半年!C4,下半年!C4)~用Sum函数求累计销售额~20~~0~

101~B4~,#,##0.000;,-#,##0.000~设置单元格数据类型为货币型，保留3位小数~10~~0~ 20~A3:B7-5~1~内边框~10~~0~

20~A2:B8-3~1~外边框~10~~0~

21~A3:B7-5~255~设置"

F00002 "请在Excel中对所给工作表完成以下操作:

1.将(A1:G1)单元格合并并居中，行高设为最适合行高，数据区域(A2:G10)设置为水平居中，垂直居中;

2.计算职工的奖金/扣除列(使用IF函数，条件是:实际销售量>=12月份应销售量，条件满足的取值800，条件不满足的取值-300);

3.计算月收入(月收入=基本工资+奖金/扣除)，将(G3:G10)单元格的数字格式设为货币(,)，不保留小数;

4.将工作表Sheet1改名为“职工收入”;

5.将12月份应销售量(D列)的列宽设置为15;

6.为表格加单" "file,188,,ks_direction,Excelst.xls,"

"58~1~-4107~图例放置于底部~10~~0~

100~F6~=IF(C6>=D6,800,-300)~计算奖金/扣除列~20~~0~

100~G6~=E6+F6~月收入的计算~10~~0~

20~A2:G10-3~1~单实线外边框~10~~0~

150~1~职工收入~工作表的表名~10~~0~

107~D5~15~D列列宽设为15~10~~0~

101~G7~,#,##0;,-#,##0~数字格式设为货币不保留小数~10~~0~

108~a1:G1~15.75~设为最适合行高~10~~0~

102~"

F00003 "请在Excel中对所给工作表完成以下操作:

1.合并(A1:H1)单元格区域，文本字体设为楷体_GB2312，文本内容垂直居中对齐;

2.将工作表表名改为“批发市场销售表”;

3.分别使用函数计算下半年销售额合计和各类商品每月销售额最大值;

4.选择猪肉、羊肉和牛肉三行(不包括下半年销售额合计)制作三维柱形图，图表的标题为“肉类销售表”，图例放在底部;

5.为“各类商品每月销售最大值”一行中的(B10:G10)区域填充红色(第三行第一列色块)the direct punishment 0.5-10,000 yuan, responsible for the

direct responsibility for the accident and the responsibility of leadership, such as concerning administrative sanctions should be dealt with by the personnel Department of the company. (3) personal injury accident occurs, the direct punishment 500-1000, who is directly responsible for the accident responsibility, give notice of criticism and 50-100 economic sanctions against them. (4) to conceal the accident, reported without undue delay or false, to inform the administrative leadership of the criticism, resulting in serious consequences, the pursuit of leadership, along with 500-1000 punishment. (5) significant near miss should be attempted as the case of responsible for the accident and construction team injuries accident penalty provisions, mutatis mutandis. Eight, should perform in the construction standards and specifications, serial number a 1 GB3323-2005 steel fusion welded butt joints, welding engineering-Ray lighting and quality rating of 2 GB11345-89 steel welds manual methods of ultrasonic inspection and testing results for grade 3 GB50236-2002 industrial pipe welding engineering code for construction and acceptance of field equipment 4 HGJ222-92 technical specification for welding of aluminium and its

alloys 5 low temperature steel welding procedure 6 SH3525-2004 petrochemical JB/ T4708-2000 of welding procedure qualification for

steel pressure vessels 7 JB/4709-2000 8 JB4730-2005 pressure vessel 底纹，25%灰色图案;

6.将A10单元格设置为自动换行;

7." "file,195,,ks_direction,Excelst.xls,"