According to Office Party of mass line education practice activities led group of unified arrangements, units main led to for cadres workers Shang a times party lecture, due to himself level limited, only put this stage concentrated learning of experience today and everyone common with learning exchange, purpose is let we further deep understanding mass line of connotation, insisted party of mass line, do masses work, following main from four a aspects told: a, and full awareness party of mass line education practice activities of major meaning Party's 18 major distinct proposed to focus on the party's advanced nature and purity, in the party, with \nd clean for the people\content of the party's mass line and educational practice. This is comrade XI Jinping as party General Secretary and adhere to strictly administering the party, strengthen the party's major decision is in line with the public expectations and strengthening the construction of learning-oriented service innovation of Marxist party's major deployment, is the important measure to advance the great cause of socialism with Chinese characteristics. First, carry out the party's mass line in education practice, was carrying 18 of the party spirit, summon a powerful force for realizing the great rejuvenation of the Chinese nation the Chinese dream of urgent needs. Party's 18 to promote strategic deployment to building socialism with Chinese characteristics, presents two 100-year goal, namely, by 2020 China's gross domestic product and per capita income of urban and rural residents in 2010 on the basis of double complete the building of a well-off society; the middle of this century into a prosperous, democratic, civilized and harmonious Socialist modern country, and on this basis, the Chinese dream of realizing the great rejuvenation of the Chinese nation. 18 Congress of the party, Comrade XI Jinping repeatedly expounded the Chinese dream. The basic connotation of the Chinese dream, is the national prosperity, national revitalization, the happiness of the people, China important to follow is to keep China Road, carry forward the spirit and cohesion strength of China, dream dreams of the people of China, but determined confidence, enhance self-awareness, achieve self-reliance, to build a stronger China, civilization, harmony, beauty, China, China, China. Strategic conception of China was 18 the spirit of the enrichment and development of the party, conscientiously study the Chinese dream, leading people to hard to realize the Chinese dream, mass education activities in depth the fundamental starting point and ending point. Strengthen the education of the party's mass line, helps to train the collective consciousness of the unity of the party and the people, playing the Chinese dream ideological bases. Comrade Mao Zedong stressed that parties should have \anguage\alist countries must have \ory ha全国计算机二级MS Office高级应用 Excel练习题参考答案

话框。切换至\数字\选项卡，在\分类\下拉列表中选择\数值\命令，在右侧的小数位数微调框中输入\，设置完毕后单击\确定\按钮即可。 4.【解题步骤】

步骤1：在\销售情况\工作表的F3单元格中输入\图书定价!$A$3:$C$19,3,FALSE)\，按\键确认，然后向下填充公式到最后一个数据行。

步骤2：在\销售情况\工作表的H3单元格中输入\，按\键确认，然后向下填充公式到最后一个数据行。 5.【解题步骤】

步骤1：在\销售情况\工作表中选中数据区域，在【插入】选项卡下的【表格】组中单击\数据透视表\按钮，打开\创建数据透视表\对话框，在\选择放置数据透视表的位置\中选择\新工作表\。

步骤2：单击\确定\按钮后即可看到实际效果。 步骤3：双击\，重命名为\数据透视分析\。

步骤4：将鼠标放置于\书店名称\上，待鼠标箭头变为双向十字箭头后拖动鼠标到\列标签\中，按照同样的方式拖动\日期\和\图书名称\到\行标签\中，拖动\小计\至\数值\中。 6.【解题步骤】

步骤1：选中博达书店销售额小计，单击【插入】选项卡下【图表】组中的\柱形图\按钮，在弹出的下拉列表中选择\簇状柱形图\。

步骤2：在\数据透视图\中单击\书店名称\右侧下三角按钮，在下拉列表中只选择\博达书店\。 步骤3：单击\确定\按钮 7.【解题步骤】

步骤：单击\保存\按钮，保存\文件。

第六套: 考生文件夹（E6）

1.【解题步骤】

步骤1：双击\工作表名，待\呈选中状态后输入\销售情况\即可，按照同样的方式将\命名为\平均单价\。

2.【解题步骤】

步骤1：选中\店铺\所在的列，单击鼠标右键，在弹出的快捷菜单中选择\插入\选项。 步骤2：工作表中随即出现新插入的一列。 步骤3：双击A3单元格，输入\序号\二字。

步骤4：在A4单元格中输入\，然后鼠标移至A4右下角的填充柄处。 步骤5：按住\键的同时拖动填充柄。

步骤6：拖动填充柄继续向下填充该列，直到最后一个数据行。 3.【解题步骤】

步骤1：选中A1：F1单元格区域，右击鼠标，在弹出的快捷菜单中选择\设置单元格格式\命令。弹出\设置单元格格式\对话框。在\对齐\选项卡下的\文本控制\组中，勾选\合并单元格\；在\文本对齐方式\组的\水平对齐\选项下选择\居中\。而后单击\确定\即可。

步骤2：按照同样的方式打开\设置单元格格式\对话框，切换至\字体\选项卡，在\字体\下拉列表中选择一种合适的字体，此处我们选择\黑体\。在\字号\下拉列表中选择一种合适的字号，此处我们选择\。在\颜色\下拉列表中选择合适的颜色，此处我们选择\深蓝，文字2,深色50%\。

步骤3：单击\确定\后即可。

步骤4：选中A1：F83单元格区域，在【开始】选项卡下的【单元格】组中，单击\格式\下拉列表，在弹出的下拉列表中选择\行高\命令，在对话框中输入合适的数值即可，此处我们输入\，输入完毕后单击\确定\即可。

步骤5：按照同样的方式选择\列宽\命令，此处我们输入\，输入完毕后单击\确定\即可。 步骤6：设置完毕行高以及列宽，便可看到实际显示的效果。

步骤7：选中数据表，在【开始】选项卡下的【对齐方式】组中选择合适的对齐方式，此处我们选择\居中\。

步骤8：选中数据区域，单击鼠标右键，在弹出的快捷菜单中选择\设置单元格格式\命令，弹出\设置单元格格式\对话框。切换至\边框\选项卡，在\预置\组中选中\外边框\，在\线条\组的\样式\下选择一种线条样式，而后单击\确定\即可。

步骤9：选中\销售额\数据列，单击鼠标右键，在弹出的快捷菜单中选择\设置单元格格式\命令，弹出\设置单元格格式\对话

roved that a people and a nation, if it does not have its own spiritual pillar, there is no unity of spiritual support, it means that no soul, will lose cohesion and vitality. Figuratively speaking, a sack of potatoes, quantity cannot be too a team, form a joint force; only like granite, so closely United to form invincible, no difficult means of strength. National rejuvenation of Chinese dream, not only embodies the common interests and pursuits, and covers a variety of groups and classes, has a wide applicability and inclusive, with a strong integrating force and lead the force. She embodies the aspirations of several generations of Chinese, reflecting today ... Into sex and purity, and the inevitable requirement of constantly improving the party's governing capacity. Strengthening the construction of the advanced nature and purity, the core problem is always maintaining the party's flesh-and-blood ties with the masses, so that our party will always be the most wholehearted support of the masses. Must take the fundamental interests of the overwhelming majority of the people as the party all the starting point and ending point, the party has always been a common fate with the masses, this is the magic weapon for our party to always maintain the advanced nature and purity. Strengthening the construction of party's advanced nature and purity and enhancing the party's ruling ability will eventually be implemented to realize, safeguard and develop the fundamental interests of the overwhelming majority of the people. All the work merits this is a measure of the party's fundamental standards, is a measure of the party's advanced nature and purity standards. Believe who, depending on who, who, standing on the position of the overwhelming majority of the people are always, always realize, safeguard and develop the fundamental interests of the overwhelming majority of the people, it is a touchstone of the Marxist party of judgement, is also sign of Marxist party is different from other political parties. Marxist political party has a clear political position and historical mission: for the interests of the vast majority of people, committed to the fundamental interests of the overwhelming majority of the people. From the day of the establishment of the Chinese Communist Party, always adhere to basic principles of historical materialism, for the interests of the most people as their goal, always serving as its fundamental purpose and values. Fully trust the masses, closely rely on the masses maintain flesh-and-blood ties with the masses is always the source of our party full of vigor and vitality, is always the most determined in the development of our party and our country. Conscientiously accept supervision by the masses, pay attention to listen to the masses ' assessment, which itself was the party's advanced nature and purity into practical action to realize the fundamental interests of the overwhelming majority of the people. At present, the party committees and leading cadres and the Government generally value the close relations with the masses, do a lot of productive work, but there are still some5

According to Office Party of mass line education practice activities led group of unified arrangements, units main led to for cadres workers Shang a times party lecture, due to himself level limited, only put this stage concentrated learning of experience today and everyone common with learning exchange, purpose is let we further deep understanding mass line of connotation, insisted party of mass line, do masses work, following main from four a aspects told: a, and full awareness party of mass line education practice activities of major meaning Party's 18 major distinct proposed to focus on the party's advanced nature and purity, in the party, with \n for the people\n content of the party's mass line and educational practice. This is comrade XI Jinping as party General Secretary and adhere to strictly administering the party, strengthen the party's major decision is in line with the public expectations and strengthening the construction of learning-oriented service innovation of Marxist party's major deployment, is the important measure to advance the great cause of socialism with Chinese characteristics. First, carry out the party's mass line in education practice, was carrying 18 of theparty spirit, summon a powerful force for realizing the great rejuvenation of the Chinese nation the Chinese dream of urgent needs. Party's 18 to promote strategic deployment to building socialism with Chinese characteristics, presents two 100-year goal, namely, by 2020 China's gross domestic product and per capita income of urban and rural residents in 2010 on the basis of double complete the building of a well-off society; the middle of this century into a prosperous, democratic, civilized and harmonious Socialist modern country, and on this basis, the Chinese dream of realizing the great rejuvenation of the Chinese nation. 18 Congress of the party, Comrade XI Jinping repeatedly expounded the Chinese dream. The basic connotation of the Chinese dream, is the national prosperity, national revitalization, the happiness of the people, China important to follow is to keep China Road, carry forward the spirit and cohesion strength of China, dream dreams of the people of China, but determined confidence, enhance self-awareness, achieve self-reliance, to build a stronger China, civilization, harmony, beauty, China, China, China. Strategic conception of China was 18 the spirit of the enrichment and development ofthe party, conscientiously study the Chinese dream, leading people to hard to realize the Chinese dream, mass education activities in depth the fundamental starting point and ending point. Strengthen the education of the party's mass line, helps to train the collective consciousness of the unity of the party and the people, playing the Chinese dream ideological bases. Comrade Mao Zedong stressed that parties should have \anguage\alist countries must have \ory has框。切换至\数字\选项卡，在\分类\下拉列表中选择\数值\命令，在右侧的\示例\中输入\，设置完毕后单击确定即可。 4．【解题步骤】

步骤1：在\平均单价\工作表中选中B3：C7区域，单击鼠标右键，在弹出的快捷菜单中选择\定义名称\命令，打开\新建名称\对话框。在\名称\中输入\商品均价\后单击确定即可。

步骤2：根据题意，在\销售情况\表中选中\销售额\列，单击鼠标右键，在弹出的的快捷菜单中选择\插入\选项，即可在左侧插入一列，在F3单元格中输入标题\平均单价\。

步骤3：在F4单元格中输入\（D4，商品均价，2，FALSE）\，然后按Enter键确认即可把\平均单价\工作表中的平均单价引入到\销售情况\工作表中。

步骤4：拖动F4右下角的填充柄直至最下一行数据处，完成平均单价的填充。

步骤5：根据销售量以及平均单价计算销售额。在G4单元格中输入\即可得出结果。 步骤6：拖动G4右下角的填充柄直至最下一行数据处，完成销售额的填充。 5．【解题步骤】

步骤1：在创建数据透视表之前，要保证数据区域必须要有列标题，并且该区域中没有空行。

步骤2：选中数据区域，在【插入】选项卡下的【表格】组中单击\数据透视表\按钮，打开\创建数据透视表\对话框。 步骤:3：在\选择一个表或区域\项下的\表/区域\框显示当前已选择的数据源区域。此处对默认选择不作更改。 步骤4：指定数据透视表存放的位置：选中\新工作表\，单击\确定\按钮。

步骤5：Excel会将空的数据透视表添加到指定位置并在右侧显示\数据透视表字段列表\窗口。双击\，重命名为\数据透视分析\。

步骤6：将鼠标放置于\商品名称\上，待鼠标箭头变为双向十字箭头后拖动鼠标到\报表筛选\中即可将商品名称作为报表筛选字段。按照同样的方式拖动\店铺\到\行标签\中、拖动\季度\到\列标签\中，拖动\销售额\至\数值\中。

步骤7：对数据透视表进行适当的格式设置。单击【开始】选项卡下【样式】组中的\套用表格格式\按钮，在弹出的下拉列表中选择一种合适的样式，此处我们选择\中等深浅\下的\数据透视表样式中等深浅2\。 6．【解题步骤】

步骤1：单击数据透视表区域中的任意单元格，而后在\数据透视表工具\的【选项】选项卡下，单击\工具\组中的\数据透视图\按钮，打开\插入图表\对话框。

步骤2 ：此处我们选择\簇状柱形图\，单击\确定\按钮后弹出簇状柱形图。 步骤3：在\数据透视图\中单击\商品名称\右侧下拉列表，只选择\笔记本\。 步骤4:单击\确定\按钮后，即可只显示各门店四个季度笔记本的销售额情况。 步骤5：最后单击\保存\按钮保存\计算机设备全年销量统计表.xlsx\文件。

第七套: 考生文件夹（E7）

1.【解题步骤】

步骤1：打开素材文件\素材.xlsx\，单击【文件】选项卡下的\另存为\按钮将此文件另存为\课时费.xlsx\的文件。 2.【解题步骤】

:步骤1：右击\课时费统计表\，在弹出的快捷菜单中的\工作表标签颜色\中的\主体颜色\中选择\红色\。

步骤2：在\课时费统计表\表中，选中A1：I1区域，右击鼠标，在弹出的快捷菜单中选择\设置单元格格式\命令，弹出\设置单元格格式\对话框。在\对齐\选项卡下的\文本控制\组中，勾选\合并单元格\复选框；切换至\字体\选项卡，在\字体\下拉列表中选择一种合适的字体，此处我们选择\黑体\命令。在\字号\下拉列表中选择一种合适的字号，此处我们选择\命令。

步骤3：选中A2：I22区域，在【开始】选项卡下的【样式】组中单击\套用表格格式\按钮，在弹出的下拉列表中选择一种恰当的样式。按照题意，此处我们选择\表样式中等深浅5\命令。

步骤4：此时弹出\套用表格式\对话框，勾选\表包含标题\复选框。 步骤5：最后单击\确定\按钮即可。

步骤6：选中前6列，右击鼠标，在弹出的快捷菜单中选择\设置单元格格式\命令，弹出\设置单元格格式\对话框。在\对齐\选项卡下的\文本对齐方式\组的\水平对齐\下拉列表框中选择\居中\命令，而后单击\确定\即可。

步骤7：根据题意，选中与数值和金额有关的列标题，右击鼠标，在弹出的快捷菜单中选择\设置单元格格式\命令，弹出\设置单元格格式\对话框。在\对齐\选项卡下的\文本对齐方式\组的\水平对齐\下拉列表框中选择\居中\命令。设置完毕后单击\确定\按钮即可。

步骤8：然后再选中与数值和金额有关的列，按照同样的方式打开\设置单元格格式\对话框，在\对齐\选项卡下的\文本对齐方

roved that a people and a nation, if it does not have its own spiritual pillar, there is no unity of spiritual support, it means that no soul, will lose cohesion and vitality. Figuratively speaking, a sack of potatoes, quantity cannot be too a team, form a joint force; only like granite, so closely United to form invincible, no difficult means of strength. National rejuvenation of Chinese dream, not only embodies the common interests and pursuits, and covers a variety of groups and classes, has a wide applicability and inclusive, with a strong integrating force and lead the force. She embodies the aspirations of several generations of Chinese, reflecting today ... Into sex and purity, and the inevitable requirement of constantly improving the party's governing capacity. Strengthening the construction of the advanced nature and purity, the core problem is always maintaining the party's flesh-and-blood ties with the masses, so that our party will always be the most wholehearted support of the masses. Must take the fundamental interests of the overwhelming majority of the people as the party all the starting point and ending point, the party has always been a common fate with the masses, this is the magic weapon for our party to always maintain the advanced nature and purity. Strengthening the construction of party's advanced nature and purity and enhancing the party's ruling ability will eventually be implemented to realize, safeguard and develop the fundamental interests of the overwhelming majority of the people. All the work merits this is a measure of the party's fundamental standards, is a measure of the party's advanced nature and purity standards. Believe who, depending on who, who, standing on the position of the overwhelming majority of the people are always, always realize, safeguard and develop the fundamental interests of the overwhelming majority of the people, it is a touchstone of the Marxist party of judgement, is also sign of Marxist party is different from other political parties. Marxist political party has a clear political position and historical mission: for the interests of the vast majority of people, committed to the fundamental interests of the overwhelming majority of the people. From the day of the establishment of the Chinese Communist Party, always adhere to basic principles of historical materialism, for the interests of the most people as their goal, always serving as its fundamental purpose and values. Fully trust the masses, closely rely on the masses maintain flesh-and-blood ties with the masses is always the source of our party full of vigor and vitality, is always the most determined in the development of our party and our country. Conscientiously accept supervision by the masses, pay attention to listen to the masses ' assessment, which itself was the party's advanced nature and purity into practical action to realize the fundamental interests of the overwhelming majority of the people. At present, the party committees and leading cadres and the Government generally value the close relations with the masses, do a lot of productive work, but there are still someAccording to Office Party of mass line education practice activities led group of unified arrangements, units main led to for cadres workers Shang a times party lecture, due to himself level limited, only put this stage concentrated learning of experience today and everyone common with learning exchange, purpose is let we further deep understanding mass line of connotation, insisted party of mass line, do masses work, following main from four a aspects told: a, and full awareness party of mass line education practice activities of major meaning Party's 18 major distinct proposed to focus on the party's advanced nature and purity, in the party, with \nd clean for the people\content of the party's mass line and educational practice. This is comrade XI Jinping as party General Secretary and adhere to strictly administering the party, strengthen the party's major decision is in line with the public expectations and strengthening the construction of learning-oriented service innovation of Marxist party's major deployment, is the important measure to advance the great cause of socialism with Chinese characteristics. First, carry out the party's mass line in education practice, was carrying 18 of the party spirit, summon a powerful force for realizing the great rejuvenation of the Chinese nation the Chinese dream of urgent needs. Party's 18 to promote strategic deployment to building socialism with Chinese characteristics, presents two 100-year goal, namely, by 2020 China's gross domestic product and per capita income of urban and rural residents in 2010 on the basis of double complete the building of a well-off society; the middle of this century into a prosperous, democratic, civilized and harmonious Socialist modern country, and on this basis, the Chinese dream of realizing the great rejuvenation of the Chinese nation. 18 Congress of the party, Comrade XI Jinping repeatedly expounded the Chinese dream. The basic connotation of the Chinese dream, is the national prosperity, national revitalization, the happiness of the people, China important to follow is to keep China Road, carry forward the spirit and cohesion strength of China, dream dreams of the people of China, but determined confidence, enhance self-awareness, achieve self-reliance, to build a stronger China, civilization, harmony, beauty, China, China, China. Strategic conception of China was 18 the spirit of the enrichment and development of the party, conscientiously study the Chinese dream, leading people to hard to realize the Chinese dream, mass education activities in depth the fundamental starting point and ending point. Strengthen the education of the party's mass line, helps to train the collective consciousness of the unity of the party and the people, playing the Chinese dream ideological bases. Comrade Mao Zedong stressed that parties should have \anguage\alist countries must have \ory ha全国计算机二级MS Office高级应用 Excel练习题参考答案

式\组的\水平对齐\下拉列表框中选择\靠右（缩进）\。设置完毕后单击\确定\按钮即可。

步骤9：选中\学时数\所在的列右击鼠标，在弹出的的快捷菜单中选择\设置单元格格式\命令。在弹出的\设置单元格格式\对话框中切换至\数字\选项卡。在\分类\组中选择\数值\命令，在右侧的\小数位数\微调框中选择\。设置完毕后单击\确定\按钮即可。

步骤10：选中\课时费\和\课时标准\所在的列，按照同样的方式打开\设置单元格格式\对话框。切换至\数字\选项卡，在\分类\组中选择\货币\，在右侧的\小数位数\微调框中选择\。设置完毕后单击\确定\按钮即可。 3.【解题步骤】

步骤1：在采用公式的方式计算\课时费统计表\中的F至L列中的空白内容之前，为了方便结果的计算，我们先对\教师基本信息\工作表和\课时费标准\工作表的数据区域定义名称。首先切换至\教师基本信息\表中，选中数据区域，右击鼠标，在弹出的快捷菜单中选择\定义名称\命令，打开\新建名称\对话框。在\名称\中输入\教师信息\后单击确定即可。

步骤2：按照同样的方式为\课时费标准\定义名称为\费用标准\。

步骤3：先根据\教师基本信息\表计算\课时费统计表\中\职称\列的内容。选中\课时费统计表\中的F3单元格，输入公式\教师信息,5,FALSE)\后按\键即可将对应的职称数据引用至\课时费统计表\中。

步骤4：按照根据\教师基本信息\计算\课时费统计表\中\职称\列的内容同样的方式来计算\课时标准\列的内容，此处不再赘述。引用\课时费标准\中的课时标准对应的数据至\课时费统计表\。

步骤5：现在我们来根据\授课信息表\和\课程基本信息\工作表计算\学时数\列内容。按照同样的方式先对\课程基本信息\的数据区域定义名称，此处我们定义为\课程信息\。

步骤6：再对\授课信息表\中的数据按姓名排序。选中\姓名\列，单击【数据】选项卡下【排序和筛选】组中的\升序\按钮，打开\排序提醒\对话框，默认选项，然后单击\排序\按钮即可。

步骤7：然后在\授课信息表\的F2单元格中增加\学时数\列，即输入\学时数\字样。

步骤8：再根据\教师基本信息\计算\课时费统计表\中\职称\列的内容同样的方式引用\课程基本信息\中的学时数数据至对应的\授课信息表\中。

步骤9：最后我们来计算\课时费统计表\中的\学时数\列。选中H3单元格，输入公式\授课信息表!$D$3:$D$72,E3,授课信息表!$F$3:$F$72)\，然后按\键即可。

步骤10：在I3单元格中输入公式\即可完成课时费的计算。 4．【解题步骤】

步骤1：在创建数据透视表之前，要保证数据区域必须要有列标题，并且该区域中没有空行。

步骤2：选中\课时费统计表\工作表的数据区域，在【插入】选项卡下的【表格】组中单击\数据透视表\按钮，打开\创建数据透视表\对话框。

步骤3：在\选择一个表或区域\项下的\表/区域\框显示当前已选择的数据源区域。此处对默认选择不作更改。 步骤4：指定数据透视表存放的位置：选中\新工作表\，单击\确定\按钮。

步骤5：Excel会将空的数据透视表添加到指定位置，并在右侧显示\数据透视表字段列表\窗口。

步骤6：根据题意，选择要添加到报表的字段。将\年度\拖曳至\报表筛选\条件，\教研室\拖曳至\列标签\列表框，\职称\拖曳至\行标签\列表框，\课时费\拖曳至\数值\列表框中求和。

步骤7：单击数据透视表区域中的任意单元格，而后在【数据透视表工具】的【选项】选项卡下，单击\工具\组中的\数据透视图\按钮，打开\插入图表\对话框。根据题意，此处我们选择\饼图\。

步骤8 ：单击\确定\按钮后返回数据透视工作表中，根据题意，拖动饼图至A12：F24单元格内区域内即可。 步骤9： 为该工作表命名。双击数据透视表的工作表名，重新输入\数据透视图\字样。

步骤10：鼠标右击表名\数据透视图\，在弹出的快捷菜单中的\工作表标签颜色\级联菜单\主体颜色\中选择\蓝色\命令。 5．【解题步骤】

步骤：单击\保存\按钮保存\课时费.xlsx\文件。

第八套: 考生文件夹（E8）

1.【解题步骤】

步骤1：首先我们按照素材中\银行流水账表格.docx\所示依次输入原始数据。

步骤2：然后我们在\月\列中以填充的方式输入\九\。将鼠标光标放置A2单元格右下角的填充柄处，待鼠标变成黑色十字形状后拖住不放，向下填充直至A6单元格处。

步骤3：，将表中数值格式设为数值保留2位小数。此处我们选择E3单元格，右击鼠标，在弹出的的快捷菜单中选择\设置单元格

roved that a people and a nation, if it does not have its own spiritual pillar, there is no unity of spiritual support, it means that no soul, will lose cohesion and vitality. Figuratively speaking, a sack of potatoes, quantity cannot be too a team, form a joint force; only like granite, so closely United to form invincible, no difficult means of strength. National rejuvenation of Chinese dream, not only embodies the common interests and pursuits, and covers a variety of groups and classes, has a wide applicability and inclusive, with a strong integrating force and lead the force. She embodies the aspirations of several generations of Chinese, reflecting today ... Into sex and purity, and the inevitable requirement of constantly improving the party's governing capacity. Strengthening the construction of the advanced nature and purity, the core problem is always maintaining the party's flesh-and-blood ties with the masses, so that our party will always be the most wholehearted support of the masses. Must take the fundamental interests of the overwhelming majority of the people as the party all the starting point and ending point, the party has always been a common fate with the masses, this is the magic weapon for our party to always maintain the advanced nature and purity. Strengthening the construction of party's advanced nature and purity and enhancing the party's ruling ability will eventually be implemented to realize, safeguard and develop the fundamental interests of the overwhelming majority of the people. All the work merits this is a measure of the party's fundamental standards, is a measure of the party's advanced nature and purity standards. Believe who, depending on who, who, standing on the position of the overwhelming majority of the people are always, always realize, safeguard and develop the fundamental interests of the overwhelming majority of the people, it is a touchstone of the Marxist party of judgement, is also sign of Marxist party is different from other political parties. Marxist political party has a clear political position and historical mission: for the interests of the vast majority of people, committed to the fundamental interests of the overwhelming majority of the people. From the day of the establishment of the Chinese Communist Party, always adhere to basic principles of historical materialism, for the interests of the most people as their goal, always serving as its fundamental purpose and values. Fully trust the masses, closely rely on the masses maintain flesh-and-blood ties with the masses is always the source of our party full of vigor and vitality, is always the most determined in the development of our party and our country. Conscientiously accept supervision by the masses, pay attention to listen to the masses ' assessment, which itself was the party's advanced nature and purity into practical action to realize the fundamental interests of the overwhelming majority of the people. At present, the party committees and leading cadres and the Government generally value the close relations with the masses, do a lot of productive work, but there are still some7

According to Office Party of mass line education practice activities led group of unified arrangements, units main led to for cadres workers Shang a times party lecture, due to himself level limited, only put this stage concentrated learning of experience today and everyone common with learning exchange, purpose is let we further deep understanding mass line of connotation, insisted party of mass line, do masses work, following main from four a aspects told: a, and full awareness party of mass line education practice activities of major meaning Party's 18 major distinct proposed to focus on the party's advanced nature and purity, in the party, with \n for the people\n content of the party's mass line and educational practice. This is comrade XI Jinping as party General Secretary and adhere to strictly administering the party, strengthen the party's major decision is in line with the public expectations and strengthening the construction of learning-oriented service innovation of Marxist party's major deployment, is the important measure to advance the great cause of socialism with Chinese characteristics. First, carry out the party's mass line in education practice, was carrying 18 of theparty spirit, summon a powerful force for realizing the great rejuvenation of the Chinese nation the Chinese dream of urgent needs. Party's 18 to promote strategic deployment to building socialism with Chinese characteristics, presents two 100-year goal, namely, by 2020 China's gross domestic product and per capita income of urban and rural residents in 2010 on the basis of double complete the building of a well-off society; the middle of this century into a prosperous, democratic, civilized and harmonious Socialist modern country, and on this basis, the Chinese dream of realizing the great rejuvenation of the Chinese nation. 18 Congress of the party, Comrade XI Jinping repeatedly expounded the Chinese dream. The basic connotation of the Chinese dream, is the national prosperity, national revitalization, the happiness of the people, China important to follow is to keep China Road, carry forward the spirit and cohesion strength of China, dream dreams of the people of China, but determined confidence, enhance self-awareness, achieve self-reliance, to build a stronger China, civilization, harmony, beauty, China, China, China. Strategic conception of China was 18 the spirit of the enrichment and development ofthe party, conscientiously study the Chinese dream, leading people to hard to realize the Chinese dream, mass education activities in depth the fundamental starting point and ending point. Strengthen the education of the party's mass line, helps to train the collective consciousness of the unity of the party and the people, playing the Chinese dream ideological bases. Comrade Mao Zedong stressed that parties should have \anguage\alist countries must have \ory has格式\命令。

步骤4：在弹出的\设置单元格格式\对话框中切换至\数字\选项卡。在\分类\列表框中选择\数值\命令，在右侧的\小数位数\微调框中选择\。

步骤5：单击\确定\按钮后即可完成设置。

步骤6：按照同样的方式分别为其他数值的格式设为数值保留2位小数。 2.【解题步骤】

步骤1：根据题意，在H3单元格中输入余额的计算公式\，按\键确认即可得出本期余额的计算结果。 步骤2：其他余额的计算采用自动填充公式的方式。选中H3单元格，将鼠标光标放置H3单元格右下角的填充柄处，待鼠标变成黑色十字形状后拖住不放，向下填充直至H6单元格处。 3.【解题步骤】

步骤1：选定\方向\列中的G2：G6区域，在【数据】选项卡下的【数据工具】组中，单击\数据有效性\按钮，打开\数据有效性\对话框。

步骤2：切换至\设置\选项卡，在\允许\下拉列表框中选择\序列\命令；在\来源\文本框中输入\借,贷,平\（注意要用英文输入状态下的逗号分隔），选中\忽略空值\和\提供下拉菜单\两个复选框。

步骤3：再切换至\输入信息\选项卡，勾选\选定单元格显示输入信息\复选框，在\输入信息\文本框中输入\请在这里选择\。 步骤4：单击\确定\按钮后即可在\方向\列中看到实际效果。

步骤5：根据题意，通过IF函数输入\方向\列内容。在\单元格中输入\平\借\贷\，然后按\键确认。

步骤6：按照同样的方式通过IF函数向方向列的其他单元格内输入内容。 4.【解题步骤】

步骤1：选中A1：H1单元格，在【开始】菜单下的【对齐方式】组中单击\居中\按钮，即可将第一行中的各个标题居中显示。 步骤2：选中数据区域，在【开始】菜单下的【样式】组中单击\套用表格格式\按钮，在弹出的下拉列表中选中一种自动套用的格式。此处，我们选择\中等深浅\组中的\表样式中等深浅2\命令。

步骤3：单击鼠标选中后弹出\套用表格式\对话框，在此对话框中勾选\表包含标题\复选框。 步骤4：单击\确定\按钮后即可为数据列表套用自动表格样式。

步骤5：选中表格，在【表格工具】的【设计】选项卡下，单击【工具】组中的\转换为区域\按钮。 步骤6：单击\是\按钮即可将表格转换为普通区域。 5.【解题步骤】

步骤1：选中数据区域，在【数据】选项卡下的【分级显示】组中，单击\分类汇总\按钮。

步骤2：弹出\分类汇总\对话框，在\分类字段\下拉列表中选择\日\命令，在\汇总方式\中选择\求和\命令，在\选定汇总项\中勾选\本期借方\和\本期贷方复选框\。

步骤3：单击\确定\按钮后即可看到实际汇总效果。 6．【解题步骤】

步骤：单击功能区中的【文件】按钮，在打开的后台视图中单击\另存为\按钮，在随后弹出的\另存为\对话框中以文件名\银行存款日记账.xlsx\进行保存。

第九套: 考生文件夹（E9）

1.【解题步骤】

步骤1：将表中数值格式设为会计专用并保留2位小数。此处我们选择C4单元格，右击鼠标，在弹出的的快捷菜单中选择\设置单元格格式\命令。

步骤2：在弹出的\设置单元格格式\对话框中切换至\数字\选项卡。在\分类\中选择\会计专用\命令，在右侧的\小数位数\微调框中选择\。

步骤3：单击\确定\按钮后即可完成设置。

步骤4：按照同样的方式分别为其他数值的格式设为会计专用并保留2位小数。 2.【解题步骤】

步骤1：在\销售统计\表中，选中A1：E1单元格，右击鼠标，在弹出的快捷菜单中选择\设置单元格格式\命令，弹出\设置单元格格式\对话框。在\对齐\选项卡下的\文本控制\组中，勾选\合并单元格\复选框；在\文本对齐方式\组的\水平对齐\下拉列表中选择\居中\命令。而后单击\确定\即可。

roved that a people and a nation, if it does not have its own spiritual pillar, there is no unity of spiritual support, it means that no soul, will lose cohesion and vitality. Figuratively speaking, a sack of potatoes, quantity cannot be too a team, form a joint force; only like granite, so closely United to form invincible, no difficult means of strength. National rejuvenation of Chinese dream, not only embodies the common interests and pursuits, and covers a variety of groups and classes, has a wide applicability and inclusive, with a strong integrating force and lead the force. She embodies the aspirations of several generations of Chinese, reflecting today ... Into sex and purity, and the inevitable requirement of constantly improving the party's governing capacity. Strengthening the construction of the advanced nature and purity, the core problem is always maintaining the party's flesh-and-blood ties with the masses, so that our party will always be the most wholehearted support of the masses. Must take the fundamental interests of the overwhelming majority of the people as the party all the starting point and ending point, the party has always been a common fate with the masses, this is the magic weapon for our party to always maintain the advanced nature and purity. Strengthening the construction of party's advanced nature and purity and enhancing the party's ruling ability will eventually be implemented to realize, safeguard and develop the fundamental interests of the overwhelming majority of the people. All the work merits this is a measure of the party's fundamental standards, is a measure of the party's advanced nature and purity standards. Believe who, depending on who, who, standing on the position of the overwhelming majority of the people are always, always realize, safeguard and develop the fundamental interests of the overwhelming majority of the people, it is a touchstone of the Marxist party of judgement, is also sign of Marxist party is different from other political parties. Marxist political party has a clear political position and historical mission: for the interests of the vast majority of people, committed to the fundamental interests of the overwhelming majority of the people. From the day of the establishment of the Chinese Communist Party, always adhere to basic principles of historical materialism, for the interests of the most people as their goal, always serving as its fundamental purpose and values. Fully trust the masses, closely rely on the masses maintain flesh-and-blood ties with the masses is always the source of our party full of vigor and vitality, is always the most determined in the development of our party and our country. Conscientiously accept supervision by the masses, pay attention to listen to the masses ' assessment, which itself was the party's advanced nature and purity into practical action to realize the fundamental interests of the overwhelming majority of the people. At present, the party committees and leading cadres and the Government generally value the close relations with the masses, do a lot of productive work, but there are still some