问题 问答题

在考生文件夹下创建工作簿文件EX4.XLS,按要求在EX4.XLS中完成以下操作。

1.在Sheet1工作表中建立如下内容工作表,并用函数求出每人的全年工资,表格中的所有数据为紫色、19磅、居中放置,并自动调整行高和列宽,数值数据加美元货币符号(保留两位小数),表格标题为绿色,合并居中,工作表命名为“工资表”。

2.将工资表复制为一个名为“排序”的新工作表,在“排序”工作表中,按全年工资从高到低排序,全年工资相同时,按 10~12月工资从大到小排,结果保存在EX4.XLS中。

3.将工资表复制为一张新工作表,并为此表数据创建“簇状柱形图”(第1行第6列除外),横坐标为“各季度”,图例为“姓名”,工作表名为“图表”,图表标题为“工资图表”。结果保存在EX4.XLS中。

答案

参考答案:

步骤1:打开考生文件夹,新建一个Excel工作表,并按题目要求输入数据。 步骤2:选中B3:F6,单击常用工具栏中的“自动求和”按钮,计算每人的全年工资。 步骤3:按题目要求设置字体。操作过程如图7.42所示。

步骤4:设置单元格数据的对齐方式。选择“格式”→“单元格”,在弹出的“单元格格式”对话框中,切换到“对齐”选项卡。操作过程如图7.43所示。

 步骤5:自动调整行高和列宽。操作过程如图7.44所示。

 步骤6:选择“格式”→“单元格”命令,在弹出的“单元格格式”对话框“分类”列表框中选择“货币”项,并设置小数位数为“2”。 步骤7:选择“格式”→“单元格”命令,在打开的“单元格格式”对话框的“字体”选项卡中,设置标题颜色。 步骤8:选中A1:n,单击常用工具栏中的“合并及居中”按钮。 步骤9:用鼠标右键单击工作表名,在弹出的快捷菜单中选择“重命名”命令,输入工作表名称为“工资表”。 2.[解题步骤] 步骤1:复制工作表。操作过程如图7.45所示。 步骤2:对数据进行排序。操作过程如图7.46所示。

 步骤3:选择“文件”→“保存”命令,保存文件。 3.[解题步骤] 步骤1:新建一个工作表,选中要复制的工作表,右键单击,在弹出的快捷菜单中选择“复制”命令,打开新建的工作表,右键单击,在弹出的快捷菜单中选择“粘贴”命令。 步骤2:选中需要建立图表的行和列,单击常用工具栏中的“图表向导”按钮,按照提示及题目要求,完成建立图表操作。 步骤3:选择“文件”→“保存”命令,保存文件。

阅读理解

F. Scott Fitzgerald, born on September 24,1896, an American novelist, was once a student of St. Paul Academy, the Newman School and attended Princeton. University for a short while. In 1917 he joined the army and was posted in Alabama, where he met his future wife Zelda Sayre. Then he had to make some money to impress her.

His life with her was full of great happiness, as he wrote in his diary : “ My own happiness in the past often approached such joy that I could share it even with the person dearest to me but had to walk it away in quiet streets and take down parts of it in my diary. ”

This side of paradise, his first novel, was published in 1920. encouraged by its success, Fitzgerald began to devote more time to his writing. Then he continued with the novel the Beautiful and Damned (1922), a collection of short stories Thales of the Jazz Age (1922), and a play The Vegetable (1923). But his greatest success was The Great Gatsby, published in 1925,which quick brought him praise from the literary world. Yet it failed to give him the needed financial security. Then, in 1926, he published another collection lf short stories All the Sad Young Men.

However, Fitzgerald’s problems with his wife Zelda affected his writing. During the 1920s he tried to reorder his life, but failed. By 1930, his wife had her first breakdown and went to a Swiss clinic. During this period he completed novels Tender Is the Night in 1934 and The love of the last Tycoon in 1940.While his wife was in hospital in the United States, he got totally addicted to alcohol. Sheila Graham, his dear friend, helped him fight his alcoholism.

小题1: How many novels written by Fitzgerald are mentioned in the passage ?

A.5

B.6

C.7

D.8小题2:Which of the following is the correct order to describe Fitzgerald’s life according to the passage?

a. He became addicted to drinking.

b. He studied at St. Paul Academy.

c. He published his first novel This Side of Paradise.

d. The Great Gatsby won high praise. 

e. He failed to reorder his life.

f. He joined the army and met Zelda.

A.f-c-e-a-b-d

B.b-e-a-f-c-d

C.f-d-e-c-b-a

D.b-f-c-d-e-a小题3:We can infer from the passage that Fitzgerald           .

A.had made some money when he met Zelda in Alabama.

B.was well educated and well off before he served in the army

C.would have completed more works if his wife hadn’t broken down

D.helped his friend get rid of drinking while his wife was in hospital小题4:The passage is probably followed by a concluding paragraph about_______  .

A.Zelda’s personal life

B.Zelda’s illness and treatment

C.Fitzgerald’s friendship with Graham

D.Fitzgerald’s contributions to the literary (文学的)world

单项选择题