Computer operating level test questions
1. Create a folder named after your desktop, follow the Word editing software with the Word Editing software in the following desks, with the Word Editing software, and the file name is AAA.DOC. (15 marks)
my country's current national education series is divided into four levels, undergraduate, master's degree, and doctoral student; Graduate and doctoral student six aspects. In addition, the university general class held in Colleges and Universities from 1970 to 1976. There are three main types of diploma of higher education, namely: General higher education qualifications, adult higher education graduation (completion) certificate, higher education self-study exam graduation (completion) certificate.
The above academic certificate is established by the National Education Administrative Department approved a regular college (including the general class in adult colleges, military institutions, providing modern distance education institutions), adult colleges and universities (ie radio and television University, staff colleges, peasant colleges, management cadres, education colleges, independent settings of Correspondence colleges), the graduates of higher education education held by private academic qualifications, and the social power schools Self-study exam graduates.
2. Copy the above file (AAA.DOC) to a new file AAA1. The paragraph format is: left to zone 2 cm, right to 1.6 cm, and closely rounded the rose picture in the clip art, the image height is 2.89 cm, the width is 2 cm, the location on the page is 5.08 cm Vertical 3.28 cm. Enter "Beautiful Rose" below the picture, and combine it into a whole, deposit it under the folder named after your name. (15)
3. Copy the above file (aaa.doc) into a new file AAA2. The required format is: left to zoom in 1.6 cm, right and right, and arrange the settings as shown below: where the "higher education diploma has main three" plus double-line, yellow 0.75 pound borders; give "Higher Education Self-study Exam graduation (completion) certificate" couples with light columns to the wiring shading, "graduates who have issued higher education education issued by private education colleges" plus double-line underline. In addition, all "education" in the text will be replaced with a red "education" of Lishu No.3. Deposit files under folders named after your name. (15 marks)
4. Making the irregular form as follows, each line height is 20 pounds, the head text is No. 3, the font number of the words in the table is the system default, aligned in the horizontal center and vertical, and put it with themselves Under the folder named after name, the file name is AAA3. (15 marks)
Registry
Name Gender Birth Year, Municipal (County) Approval Level Work Unit Communication Address
5. In the Excel, the "First Batch of New Projects in 2004" was screened by different credits screening and different titles of teachers, and the total project fees were calculated. (Document "2004 first new project list. Xi" on the desktop of this machine.) (20 points)
6. Use Excel97 to establish a data sheet and chart as required, and the specific requirements are as follows:
(1) Please build a data table with the data of the following two types of stock prices (stored in the area of the A1: E7), and its data table is saved in the Sheet1 worksheet.
Stock Variety Time Pan Cales Capture A10: 30114.2113.2113.5112.1A14: 30116.5112.2112.3B1210.5112.2119.5B14: 30222.0219.5B14B16: 40125.5125.0125.0 (2) Established Data Table Selection The high "" disk low "" closing price "" time "data set up the high-disk low-closed diagram, chart title is" stock price chart "and embed it into the A9: F19 area of the worksheet.
(3) Change the worksheet Sheet1 to "stock price trend table".
Note: All of the above results are deposited on the desktop with a folder named after your name.
Test Results:
25, 30, 37, 15, 45, 30, 20, 55, 60, 30, 38, 30, 10, 40, 45, 60, 15, 0, 75, 25, 45, 15, 85, 50, 5, 15, 40, 60, 10, 20, 24, 48, 35, 48, 54, 42, 30, 30, 27, 22, 23, 76, 45, 5, 30, 30, 40, 15, 58, 45, 70, 5, 15, 37, 45, 45, 40, 0, 25, 15, 37, 37, 40, 45, 55, 25, 20, 20, 40, 40, 30, 35, 20, 60, 45, 30, 40, 40, 45, 40, 30, 65, 70, 40, 60, 40, 20, 18, 30, 45, 15, 25, 30, 26, 44, 40, 70, 0, 61, 33, 28, 23, 35, 0, 20, 45, 30, 0, 48, 37, 40, 30, 60, 20, 45, 35, 20, 50, 25
analysis:
Number of exams: 128 people, test paper over 100, test time 50 minutes
Score number ratio Remarks 053.9% white roll! <= 6011287.5%> = 601612.5%> = 7064.69%> = 8010.78%> = 9000% 10000% full points
Seeing from the statistics:
The number of people accounts only 12.5% of the number of references; 87.5% of people can't get grid, even 3.9% of people pay the white roll!
More than 1 more than 80 points, accounting for 0.78%;
90 points or more people are 0;
The test questions do not contain any techniques that need to be used in the usual office environment. From the examination, most of the participants did not make a complete topic in the specified time, and there were several people to exit the exam (not included in the above 128 people).
Most people can complete the first text entry topic, but since the entry speed is too slow, the completion time of the rear topic is occupied. Some people can't build a folder on the desktop, indicating that the operating system is not familiar.
Most people can complete the picture insert, but do not understand the combination of the text box below the picture, and do not understand the page settings. Description Practice is very small, it may never print the document with a printer.
Give a document, a few people can do some, but it is not strictly done.
Most people have done better about form production questions. The score is more than 30, and this topic is better.
The worst completion is the topic of the last 2 Excel. Some people just established a data sheet and input data. There are very few people who can establish a chart according to the data table data. No one can change the worksheet.
From the perspective of the entire recruitment, the number of applicants reached more than 400, including Master's degree. Finally, more than 200 people who take the written test are undergraduate or above. After participating in the written test, only more than 130 people can continue to participate in the machine. Those who participated in the machine have only 12.5% of the post rate (16 people).
Zhang Qing
http://www.why100000.com
March 7, 2005
