题目内容

Excel操作题:
(1)在第一行处插入一标题行,标题行要求A-F合并居中,内容为“销售报表”,黑体20磅。
(2)按“盈利=单价×数量-成本”的公式计算每一行中的盈利。
(3)合并A10:E10单元,输入“盈利合汁”.在F10单元计算出盈利合计。
(4)各单价、成本、盈利有关的数据采用千位分隔不保留小数位的样式。
(5)将表格中的数据按日期递增的顺序、日期相同再按产品名称(拼音)递增的顺序排序。(6)将第二行中的单元及AS:C9区域中的数据采用水平居中的格式。
(7)将台式微机的各天的盈利额画出折线图。

查看答案
更多问题

科学家利用地震波来研究地球内部物质结构和组成,其中,纵波能通过固体和液体,横波只能通过固体。阅读地球内部圈层结构示意图,回答下列问题。
(1)观测地震波在地下不同深度传播速度的变化,可将地球内部分为三个圈层,图中A、B、C分别是______、______、______。
(2)在地上约60一250千米至400千米处存在一个软流层,这里的物质处于熔融状态。软流层以上的______和______组成了岩石圈。
(3)横波速度在地下2900千米处降为零,据此推测从这里到5000千米深处的特质接近(液、固)态。

上海新生摩托车有限公司(311093××××)于2008年7月9日持出口收汇核销单出口摩托车一批。

Task 5
Directions: The following is a business letter. After reading it, you should give brief answers to the 5 questions (No.56 to No.60) that follow. The answers (in no more than 3 words) should be written after the corresponding numbers on the Answer Sheet.
Gmail (Google Email) Notice
Subject: Your Gmail account has been inactive for a long time
From “The Gmail Team”
Time 2008-06-26 14:12:55
To Hi there,
We’ve noticed that you haven’t used your Gmail account, , for quite some time. In order to make Gmail better for our users, we’ve added a lot of things in the last few months and we hope you’ll want to start using your account again.
Stop worrying about storage (存储量). has 5000 megabytes (兆字节) of free storage and our plan is to continue growing your storage by giving you more space as we are able.
The Gmail interface (界面) is now available in 12 languages. If you don’t see the language you want on this list, look for it in the future because we’re going to keep adding more.
We’re still working hard every day to build for you the best email service around. But to keep Gmail great for our users, we may have to close inactive accounts after 9 months. So, we hope you’ll give us another chance. To log in (登录) to your Gmail account, just visit: The Gmail Team
56. Why does the Gmail Team write to the Gmail user?
Because the user hasn’t used his / her Gmail ________ for quite some time.

Task 4
Directions: The following is a list of terms for library signs. After reading it, you are required to find the items equivalent to (与…等同) those given in Chinese in the table below. Then you should put the corresponding letters in the brackets on the Answer Sheet, numbered 51 through 55.
A—reading,reference and copying
B—staff only
C—closed shelves for undergraduates
D—information retrieval room
E—inter-library loan
F—display&reading room for new books
G—multi-media reading room
H—reference department office
I—novelty research
J—lecture hall
K—reading room for reference books
L—return deposit
M—reading room
N—title catalogue
O—circulation for foreign books
P—card catalogue
Q—periodicals and magazines
Examples: (O) 外文书刊借阅 (D) 信息检索室
51.() 员工专用 () 多媒体阅览室

答案查题题库