promotion of employment, form a reasonable and orderly pattern of income distribution, build a more fair and sustainable social security systems, medical and health system reform. The plenary, innovation of social governance, must focus on the maintenance of fundamental interests of the overwhelming majority of the people, maximize factors, enhance social development, improving social governance, the interests of national security, ensure that the people live and work, social stability and order. o improve social governance, stimulating social organization, innovative and effective system of preventing and resolving social conflicts, improving the public security system, set up the National Security Council, national security systems and national security strategy to ensure national security. Plenary session, the construction of ecological civilization, you must establish systems of ecological system, using the system to protect the ecological environment. To improve natural resources asset property right system and use control, red line of delimitation of ecological protection, resources paid use system and ecological compensation system in ecological environment protection management system reform. Plenary session, centering on building a listening party command, can win and having a fine style of the people's army, a strong army under the new situation of the party Goals, restricting the development of national defense and army building is solved outstanding contradictions and problems, innovation and development of military theory, enhance military strategic guidance, improve the military strategy in the new period, building a modern military force system with Chinese characteristics. o deepen the adjustment of personnel system reform in the army, military policy and system reform, promote the development of military and civilian integration depth. Plenary session stressed that comprehensive reform must be to strengthen and improve the party's leadership, give full play to the core role of the party commands the overall situation and coordinating all parties, improving the party's leading water ... Margin. Challenged the leadership of the Communist Party of China, Marxism-Leninism and Mao Zedong thought by Deng Xiao-ping's flag, replaced by three representatives and the harmonic society. The former Communist Party spirit and social cohesion point of almost all political makeover. Characteristics of socialism public ownership is shifting to private ownership, planned regulation and market regulation, the proletarian regime controlled by the elite. Of universal equality, fairness and basic principles of distribution system is socialist society, however after economic monopolized by powerful, vested interests grow, employers do not have the same status, hardly seems fair social distribution. State key protection of capital interests rather than the interests of citizens, had been hits the bottom of the proletariat .……2014 / 2015 学年第 一 学期
…… 内蒙古扎兰屯林业学校考试命题纸
…课程：EXCEL在会计中的应用 考试班级：1306班财电专业 … …题号 一 二 三 四 五 六 七 八 九 总分 …得分 … …批卷人 … …
… 一、单项选择题（每题
2分，共40分）
… … 1. 在Excel中，给当前单元格输入数值型数据时，默认为( )。
线 A、居中 B、左对齐 C、右对齐 D、随机
.：…号 … 2．在Excel中，要在同一工作簿中把工作表sheet3移动到sheet1前面，应
学……( )。
. …A、单击工作表sheet3标签，并沿着标签行拖动到sheet1前
.. …B、单击工作表sheet3标签，并按住Ctrl键沿着标签行隙 拖到sheet1
前…
……C、单击工作表sheet3标签，并选\编辑\菜单的\复制\命令，然后单击工作 订表sheet1标签，再选\编辑\菜单的\粘贴\命令
.. … D、单击工作表sheet3标签，并选\编辑\菜单的\剪切\命令，然后单击工作
. ... 表sheet1标签，再选\编辑\菜单的\粘贴\命令
… … 3．在Excel中，A1单元格设定其数字格式为整数，当输入\时，显示为
.：…( )。
名… A、33.51 B、33 C、34 D、ERROR
姓……4 .在Excel中，用户在工作表中输入日期，( )形式不符合日期格
式。…
… … A、’20-02-2000’ B、02-OCT-2000
装 … C、2000/10/01 D、2000-10-01
… 5．下列关于Excel的叙述中，不正确的一条是( )。
… A、在单元格名称框中不可以填入单元格区域，如A1：D5
… …B、在单元格名称框中可以填写单元格的地址
... … C、在单元格名称框中显示出当前单元格的地址 D… 、在单元格名称框中可以填入各种形式的单元格的地址 6. … ：…在Excel中，选定整个工作表的方法是（ ）。
…级…A、双击状态栏 B、单击左上角的行列坐标的交叉点 班 C…、右键单击任一单元格，从弹出的快捷菜单中选择\选定工作表\ D、按下Alt键的同时双击第一个单元格
7. 在Excel中产生图表的源数据发生变化后，图表将（ ）。
bviously, face China's Socialist system, the Communist Party is not the party. In that case, political chaos has been very tight. Is remodeling or reconstruction, is a correction or a stove. Whether to turn right or left, is back to the source or put forward new political ideas. This is to determine the road problems in China, is also the key out of the deep water of the reform of the economic system. After 18, the new Central collective leadership attaches great importance to political orientation. First, the \es\point, starting from the Central Government's self-restraint, which preaches and pro-image, brought fresh feeling to the community. Secondly, before reform and opening up and reform and opening two periods after non-negative, untying the tangle of the society a long time on this issue. Third, a new generation of party leaders on various occasions to Mao Ze-Dong and Mao Ze-Dong's thought of evaluation has room for manoeuvre, through to the ruling ideology of Mao Zedong thought, is the call of the soul to the Socialist Revolution and construction. Empty talks jeopardize implement the Constitution, stressed the need to turn off the power in a cage. Also stresses that Mao Zedong thought cannot be lost, 30 years after the reform and opening up 30 years ago can not deny each other. Both advocate democracy and release \not speak of\constraints. Neither deny the history of the CPC Central Committee on several issues ... Comrades: today brings together members, mainly in order to provide a platform to Exchange and learn from each other in order to facilitate our work. Just now, we focus on taxation, planning and stability, safety, project construction, typical topics such as private facts presentation and interaction, and towns currently exist in the in-depth analysis of the problems to be solved, to explore new methods to solve the problem. It can be said that summing up the achievement, no grandstanding; analysis A、不会改变 B、发生改变，但与数据无关
C、发生相应的改变 D、被删除
8. 在Excel中输入分数时，最好以混合形式(0 ？/？)方式输入，以免与（ ）格式相混。
A、日期 B、货币 C、数值 D、文本
9. 应纳个人所得税税额的计算公式为应纳税所得额乘以使用税率减去（ ）。
A、所得额 B、速算扣除数 C、工资薪金收入 D、三险一金 10. 在Excel中，在单元格中输入 =12>24，确认后，此单元格显示的内容为（ ）。
A、TRUE B、=12>24 C、FALSE D、12>24 11. 在Excel中工作簿名称被放置在（ ）。
A、标签行 B、标题栏 C、工具栏 D、信息行 12. 在Excel中，在单元格中输入 =6+16+MIN(16,6)，将显示（ ）。 A、38 B、44 C、22 D、28 13. 在Excel中选取\自动筛选\命令后，在清单上的（ ）出现了下拉式按钮图标。 A、字段名处 B、所有单元格内 C、空白单元格内 D、底部 14. 在Excel中建立图表时，我们一般（ ）。
A、先输入数据，再建立图表 B、建完图表后，再输入数据 C、在输入的同时，建立图表 D、首先建立一个图表标签 15. 年数总和法计算固定资产累计折旧使用财务函数（ ） 。 A、DDB( ) B、SLN( ) C、SYD( ) D、IF( )
16. 在Excel中，若单元格C1中公式为=A1+B2，将其复制到单元格E5，则E5中的公
式是（ ）。
A、=C3+A4 B、=C5+D6 C、=C3+D4 D、=A3+B4 17. 用于分析某种利润率变化的图表是（ ）。
A、面积图 B、直方图 C、折线图 D、饼图 18. 下列不属于产品成本计算的基本方法是（ ）。 A、分次法 B、品种法 C、分批法 D、分步法
19. 在同一工作簿中，Sheet1工作表中的D3单元格要引用Sheet3工作表中F6单元
格中的数据，其引用表述为（ ）。
A、=F6 B、=Sheet3!F6 C、=F6! Sheet3 D、Sheet3#F6 20. Excel保存的工作簿默认文件扩展名是（ ）。
A、XLS B、XLT C、DBF D、TXT 二、填空题（每空1分，共20分）
1. 如果科目级长设定为两位，在编码时，若科目在十个以下，编码的十位数必须以
____________表示。
national interests and try again, is an affirmation of Deng Xiao-ping's reform ideas. These strong political signal showing a new generation of political leaders is still keeping to the Socialist road. Four is revisiting the \ao Ze-Dong's historical cycle of\profile anti-corruption and the importance of the Constitution, reorganization is bad style of officialdom, was to civilize people obey the law, while improving the color change of the regime of vigilance. Five is to reform into deeper waters and stressed that top-level design, this is a review on the reform and opening up in the past, is also looking for a way out. Six foreign and Russia closer, the flexible attitude on the issue of the Korean peninsula, Sino-Japanese fishing hardline China on the island out of the \ent\profile shadow began to gradually plan development. Signs show that the new leadership began to make a left turn in politics. However, as of right now, not only ideological confusion in the community, the new leadership's thinking is messy. New leaders both stressed the need to promotion of employment, form a reasonable and orderly pattern of income distribution, build a more fair and sustainable social security systems, medical and health system reform. The plenary, innovation of social governance, must focus on the maintenance of fundamental interests of the overwhelming majority of the people, maximize factors, enhance social development, improving social governance, the interests of national security, ensure that the people live and work, social stability and order. o improve social governance, stimulating social organization, innovative and effective system of preventing and resolving social conflicts, improving the public security system, set up the National Security Council, national security systems and national security strategy to ensure national security. Plenary session, the construction of ecological civilization, you must establish systems of ecological system, using the system to protect the ecological environment. To improve natural resources asset property right system and use control, red line of delimitation of ecological protection, resources paid use system and ecological compensation system in ecological environment protection management system reform. Plenary session, centering on building a listening party command, can win and having a fine style of the people's army, a strong army under the new situation of the party Goals, restricting the development of national defense and army building is solved outstanding contradictions and problems, innovation and development of military theory, enhance military strategic guidance, improve the military strategy in the new period, building a modern military force system with Chinese characteristics. o deepen the adjustment of personnel system reform in the army, military policy and system reform, promote the development of military and civilian integration depth. Plenary session stressed that comprehensive reform must be to strengthen and improve the party's leadership, give full play to the core role of the party commands the overall situation and coordinating all parties, improving the party's leading water ... Margin. Challenged the leadership of the Communist Party of China, Marxism-Leninism and Mao Zedong thought by Deng Xiao-ping's flag, replaced by three representatives and the harmonic society. The former Communist Party spirit and social cohesion point of almost all political makeover. Characteristics of socialism public ownership is shifting to private ownership, planned regulation and market regulation, the proletarian regime controlled by the elite. Of universal equality, fairness and basic principles of distribution system is socialist society, however after economic monopolized by powerful, vested interests grow, employers do not have the same status, hardly seems fair social distribution. State key protection of capital interests rather than the interests of citizens, had been hits the bottom of the proletariat 2. 标识一个单元格的方法是_________________________________。
3. 在Excel中系统默认的图表类型是_______________。
4. 按__________键激活“编辑栏”和单元格后可以进行插入和修改数据。 5. 直线法下计算固定资产折旧最大的特点是每期的折旧额___________。
6. Excel中运算符有__________________、_______________和
________________三种运算符。
7. 退出Excel可使用组合键_______________。 8. 会计报表主要包括________________ 、______________、_______________
和 ________________ 。
9. Excel中，一个完整的函数是由_____________和_____________构成的。
10. 费用按经济用途分类可分为______________和_____________费用 。 11. Excel公式中可使用通配符查找一些文本，使用的通配符有________和
_________两种通配符。
12. 函数中参数多于一个是，必须用_________符号把它们分隔开。
三、判断题（每小题2分，共20分）
1. 在Excel中，输入当天的日期可按组和键“Ctrl+；” 。( ) 2. 函数参数应用括号括起来，且括号前应有空格 。( ) 3. 默认情况下，在Excel03版中新建工作薄的工作表数为3个。( ) 4. 在Excel中，可使用 & 运算符来连接字符串。（ ）
5. 在Excel中，工作表的拆分分为水平拆分和垂直拆分。( )
6. 函数if（）、day()、syd()都是财务函数。（ ） 7. 在Excel中，创建公式的操作步骤是④②①③。( ) ① 在编辑栏键入“＝” ② 键入公式
③按Enter键 ④选择需要建立公式的单元格
8. Excel中，单元格地址绝对引用的方法是在构成单元格地址的字母和数字分别加上“$”符号 。 ( )
9. 主要财务指标体系分为三大类：偿债能力指标、营运能力指标和盈利能力指
标。（ ）
10.Excel中比较运算符有=、>、>=、<、<=、<>六种。（ ） 四、编辑公式题（共20分）
bviously, face China's Socialist system, the Communist Party is not the party. In that case, political chaos has been very tight. Is remodeling or reconstruction, is a correction or a stove. Whether to turn right or left, is back to the source or put forward new political ideas. This is to determine the road problems in China, is also the key out of the deep water of the reform of the economic system. After 18, the new Central collective leadership attaches great importance to political orientation. First, the \es\point, starting from the Central Government's self-restraint, which preaches and pro-image, brought fresh feeling to the community. Secondly, before reform and opening up and reform and opening two periods after non-negative, untying the tangle of the society a long time on this issue. Third, a new generation of party leaders on various occasions to Mao Ze-Dong and Mao Ze-Dong's thought of evaluation has room for manoeuvre, through to the ruling ideology of Mao Zedong thought, is the call of the soul to the Socialist Revolution and construction. Empty talks jeopardize implement the Constitution, stressed the need to turn off the power in a cage. Also stresses that Mao Zedong thought cannot be lost, 30 years after the reform and opening up 30 years ago can not deny each other. Both advocate democracy and release \not speak of\constraints. Neither deny the history of the CPC Central Committee on several issues ... Comrades: today brings together members, mainly in order to provide a platform to Exchange and learn from each other in order to facilitate our work. Just now, we focus on taxation, planning and stability, safety, project construction, typical topics such as private facts presentation and interaction, and towns currently exist in the in-depth analysis of the problems to be solved, to explore new methods to solve the problem. It can be said that summing up the achievement, no grandstanding; analysis
根据上表编写出以下单元格的计算公式： 1、单元格D8（即已计提月份）的计算公式；（5分） 2、单元格F8（即尚可使用月份）的计算公式；（3分） 3、单元格F9（即净残值）的计算公式；（2分） 4、单元格D12（即年折旧额）的计算公式；（4分） 5、单元格E12（即累计折旧）的计算公式；（3分）
6、单元格F12（即年末折余价值）的计算公式。（3分） national interests and try again, is an affirmation of Deng Xiao-ping's reform ideas. These strong political signal showing a new generation of political leaders is still keeping to the Socialist road. Four is revisiting the \ao Ze-Dong's historical cycle of\profile anti-corruption and the importance of the Constitution, reorganization is bad style of officialdom, was to civilize people obey the law, while improving the color change of the regime of vigilance. Five is to reform into deeper waters and stressed that top-level design, this is a review on the reform and opening up in the past, is also looking for a way out. Six foreign and Russia closer, the flexible attitude on the issue of the Korean peninsula, Sino-Japanese fishing hardline China on the island out of the \ent\profile shadow began to gradually plan development. Signs show that the new leadership began to make a left turn in politics. However, as of right now, not only ideological confusion in the community, the new leadership's thinking is messy. New leaders both stressed the need to
Excel在会计中的应用期末考试题
