Instructions for answering questions:
1. Candidates can only open one answer window, save the answer results and close the current answer window before opening the next question. 2. The timing shall be subject to the invigilator's announcement of the end of the exam. At that time, candidates must immediately save the answer results and close the answer window.
3. In case of special circumstances such as misoperation and computer failure, please raise your hand to the invigilator.
4. All the test questions are generated into the folder named after your test number in the answer folder (see the figure below), and the answers are only valid in this folder.
z:\——& lt； Your test number > ————— excelkt |—— net |———— Winkt |——— word |— ......
5. Unless otherwise specified, letters and numbers shall be regarded as English characters; Punctuation marks shall be subject to Chinese full-width symbols.
6. This exam includes the main test paper and the additional test paper. After the main test paper is handed in, you can log in again to open the additional test paper.
1, create a conservation-oriented society and save electricity from small things. What is incorrect is that
A. Let the TV stand by for a long time to reduce the number of times it is turned on.
B. In summer, the air conditioning temperature should be raised by one degree as much as possible.
C. after turning off the computer, disconnect the power supply.
D. When the air conditioner is not in use, please disconnect the power supply.
The answer to this question is
2, suspected that the computer is infected with a virus, the first reasonable measures should be taken are
A. reinstall the operating system. B. use antivirus software to kill virus.
C. format all disks. D. Turn it off immediately and don't use it again.
The answer to this question is
3. Which of the following represents a complete computer system?
A. Host, keyboard and monitor B. Host and its peripheral devices
C. System software and application software D. Hardware system and software system
Answer: D.
4, programming to find the sum of two integers, the program structure can be completed only by which structure.
A. Sequence structure B. Branching structure C. Ring structure
The answer to this question is
Many people store the data in the server on the network, which is convenient for remote access. The following can achieve this function is ()
A. floppy disk
B. hard disk
C. optical disk
D. e-mail address
The answer to this question is
6. A column in the data table is called ().
A.a record b field c command d attribute.
The answer to this question is
7. In the school computer information management system, every student has to study many courses, and there are more than one student studying a certain course. Then the relationship between students and courses is ().
A. one-to-one B. one-to-many C. many-to-many
The answer to this question: A B C.
8, the main purpose of image data compression is:
A. improve the clarity of the image B. improve the contrast of the image C. make the image more vivid D. reduce the storage space
The answer to this question is
9. Do the following under the winkt folder:
1. Set the properties of the e3 1 1 folder in the exam3 folder to read-only.
2. Copy all files with the first character P and the fourth character T in the exam4 folder (including subfolders) to the exam5 folder.
3. Move the exam2 folder to the exam 1 folder.
4. rename the exam6 folder to test6.
10. Enter the specified text in the text input form. After entering, save and exit.
Note: (1) All punctuation marks are Chinese full-width symbols, and all letters and numbers are English half-width characters.
(2) Save before exiting.
Note: Choose between Word and WPS, and do more to get the highest score.
1 1. Open w3.doc in the word folder and do the following:
1. The title is in bold, and the third word is in the middle.
2. The text is set to Song Dynasty No.4, the line spacing is fixed at 20 points, and the first line of the paragraph is indented by two Chinese characters.
3. Insert the picture hjt 1.jpg between the title and the first paragraph, and the line feed is up and down.
4. Set the margins, 2cm from top to bottom, left and right.
12. Open w6.wps under the wps folder and do the following:
1. Appends the text in the news.txt file to the back of the text.
2. The text is set to Song Dynasty No.4, and the first line of the paragraph is indented by two Chinese characters.
3. Insert the picture hjt 1.jpg between the title and the first paragraph, and surround it: both sides do not surround it.
4. Set the margins, 20mm from top to bottom, left and right.
Note: Choose between Excel and VFP. If you do too much, you will only get the highest score.
13. Open e005.xls and do the following:
1. Merges cells A 1:E 1 and displays cell data in the middle level.
2. Calculate the "Total Sales" with the formula and fill it in the corresponding cell.
3. Use the formula to calculate the "growth" and fill it in the corresponding cell. (Calculation formula: growth =2005 -2004)
4. Sort the table data in ascending order with "2005" as the main keyword and "2004" as the secondary keyword. Requirements: Do not include the "Total Sales" line when sorting.
5. Save the exercise when you are finished.
Note: Choose between Excel and VFP. If you do too much, you will only get the highest score.
14, VFP database application
1. Open table VFPV02. DBF, and use the report wizard to create the report VFPV02. Requirements: Select three fields: employee number, name and gender; Group records should be grouped by "gender"; Style selection accounting type; The direction in the layout is vertical; Sort the records in ascending order by employee number; The title of the report is "Employee Basic Information Table".
2. Open shuju 1.dbf, calculate zf according to zf=km 1+km2+km3, and fill the result in the zf field.
3. Open shuju2.dbf, run the js3.fxp program, and close the database.
15, that is, Internet browsing.
Browse the website of "Jade House" and complete the following operations:
1. In the search engine on the homepage, search with "Ruby" as the key word, and save the searched page in the Internet folder with the name of "Ruby.htm";
2. Enter the "Legend of Plum Rain" page from the "Jade Culture" page, and copy its introduction (excluding the title) to "Legend of Plum Rain". Txt "file is placed in the Internet folder.
Note: Choose one of the two questions, WebMail and OutLook Express. If you do too much, you will only get the highest score.
16, OutLook Express email
1. Set an email account with the display name Caring E-mail :guanai@deyu.com;
Account number: Guan Ai, password: help; ; Server pop3:deyu.com, smtp:deyu.com
2. Receive the email and save the email attachment from dabenying@deyu.com to the OEKT folder with the original file name.
Note: Choose one of the two questions, WebMail and OutLook Express. If you do too much, you will only get the highest score.
17, Webmail
1. Apply for a new account.
Account name: Leopard
Password: ws72 1008
Name: Xiao Zhao.
2. Forward the mail from koala@inhe.net in the inbox to tiger @126.com. ..
3. Save the attachment in Marksim@yahoo.com.cn's email in the inbox with the file name "Exam". Rar "is placed in the webmail folder.
18、PowerPoint
Open PPT\PPT2. PPT file, and do the following:
1. Set the application design template to Notebook.pot
2. Insert the picture p 1.jpg in the lower right corner of the first slide, set the picture height to 12CM, and lock the vertical and horizontal ratio.
3. Set the animation effect of text 2 on the second slide to fly in on the right side and send it in batches.
19, the computer can directly identify the code of _ _ _ _ _
A. binary b octal c decimal d hexadecimal
The answer to this question is
20. Indulge in the internet too much, which will easily make people divorced from the real world, affect their physical and mental health, and then form the so-called "Internet addiction". The correct understanding of "Internet addiction" is ()
A. surfing the internet for more than 4 hours every day is "internet addiction"
B. "Internet addiction" makes people escape from reality and indulge in fantasy, so that they usually appear numb and negative.
C. People who are healthy will definitely not suffer from "Internet addiction".
D. The characteristics of "Internet addiction" people seeking information online are clear goals and quick action. Once they find out, they will stop immediately without any unnecessary browsing.
The answer to this question is
2 1, which is mainly used to manage computer software and hardware.
A.IE B.windows C.word D.powerpoint
Answer: B.
22, in the microcomputer system, the basic program of managing input and output devices in
A. hard disk B. ram C. rom D. register
The answer to this question is
23. In WINDOWS98, the drive letter of the hard disk usually should not be
A.:D:
The answer to this question is
24. What is the shape of the file system structure in Windows 98?
A. Grid B. Tree C. Hierarchy D. Chain
The answer to this question is
25, the following description about font size, the error is ().
A 36-point font is larger than a 28-point font.
B. the number five in the font size is bigger than the number four.
C. changing the font will not affect the font size.
D. changing the font color will not affect the font size.
The answer to this question is
26, "Bluetooth" is
A. A scientific research project is called B. A disease that causes teeth to turn blue.
C. A wireless communication technology
The answer to this question is
27. When sending emails to two people at the same time, which symbol can be used to separate their addresses in the address bar?
A.、
B.,
C.。
D.+
The answer to this question is
28. The webpage file is _ _ _ _ _.
A. binary file B. animation file C. plain text file D. multimedia file
The answer to this question is
29. For advanced data filtering in Excel, the following statement is correct _ _ _ _ _ _.
A. The table after advanced filtering only contains rows that meet the filtering conditions, and other rows are deleted.
B after advanced filtering, only the rows that meet the filtering conditions are displayed in the table, and other rows are temporarily hidden.
C. advanced filter conditions can only be fixed values.
D advanced filter conditions cannot be defined by users, but only determined by the system.
The answer to this question is
A sports fan of a school made a survey on the possibility of winning the 2006 World Cup on the campus website. The results showed that 48% of the students chose Brazil. 36% students choose the German team; 16% of the students chose England. If the above survey results are represented by charts, the one that can best show the distribution trend is ().
The answer to this question is
3 1. The following is the paint box of "Drawing" software in Windows. As shown in the figure, _ _ _ is the foreground color.
A. black b white c red d blue
The answer to this question is
32. "Ctrl+C" shown in the figure.
A is the shortcut key for the Copy command in the Edit menu.
B. Explain that the copy option in the edit menu contains the next submenu.
C is the shortcut key to open the edit menu.
D. explain that clicking the copy option in the edit menu can open a dialog box.
33. According to the following statement, the final value of A is ().
a= 1
b=2
a=b/a
A. 1 B. 1/2 C. 3 D.2
The answer to this question is
34.Windows operation
The following file names and folder names are case-insensitive, and all letters and numbers are English half-width characters.
1. Create the following folder structure under the TA folder. (2 points)
tantalum (Ta)
├—K 1
└—K2
└—K3
2. Delete all files in TJ folder (including subfolders) whose file names begin with "Deleteable". (3 points)
3. Rename the TE folder to TE. BAK (2 points)
4. Move the TD folder to the TB folder and overwrite the existing folder with the same name. (3 points)
35, text input
In the text entry form, enter the specified text, and then save and exit.
Note: (1) All punctuation marks are Chinese full-width symbols, and all letters and numbers are English half-width characters.
(2) Save before exiting.
Note: Choose between Word and WPS, and do more to get the highest score.
36.word processing
1. Change the font color of "Mars Express" to "Mars Express" in n2.doc under the word folder to red.
2. Set the title font in n2.doc under the word folder to bold and No.3; The text font is set to four characters in regular script.
3. Save the file.
4. Save as "Mars Express". doc”。
Note: Choose between Word and WPS, and do more to get the highest score.
37.Wps word processing
Open the wps5.wps document in the wps folder and do the following:
1. Add the title "Overview of Qinghai-Tibet Railway Project" to the article, and set the title as No.3, bold and centered.
2. Set the text line spacing to 3.8 mm. ..
3. Bold and underline the last paragraph of the article.
4. Insert the file qztl02.gif in the current folder of the article, only around one side.
Note: Choose between Excel and VFP. If you do too much, you will only get the highest score.
38, Excel data processing
Open the excel08.xls file in the excel folder under the examinee's answer folder.
1. Set the font of the title "Work Safety Statistics in 2005" to italic red and the font size to 18.
2. Use the formula to calculate the "total number of regions" and fill it in the corresponding cells. Summarize the national individual data and fill in the corresponding cells.
3. Set the height of the fifth line (the line where Hebei is located) to 28, set the characters in it to red, and center the characters in A2:F34 area vertically and horizontally.
4. Fill in the data of column C in Sheet2 in equal proportion, starting from line 1, with a step value of 3 and ending at line 10.
Note: Choose between Excel and VFP. If you do too much, you will only get the highest score.
39, VFP database application
Perform the following operations in the Visual FoxPro environment:
1, data calculation: (5 points)
Open the table DATA5.dbf in the current directory to improve everyone's math score by 2 points.
2. Visual operation: (5 points)
Open the table label1v. DBF, and use the form wizard to create the form tab1v. Requirements: Select all fields; The style is relief, and the button type is picture button; Sort records in ascending numerical order; The title of the form is "Statistics of Automobile Sales".
40.IE internet browsing
Browse the Goldfish.com website and complete the following operations:
1. Enter the goldfish color page from the goldfish topic page, and copy the text description (excluding the title) to the "color.txt" file under the Internet folder.
2. From the "evolution of goldfish" page to the "origin of goldfish name" page, save this page in an Internet folder with the file name "youlai.htm".
Note: Choose one of the two questions, WebMail and OutLook Express. If you do too much, you will only get the highest score.
4 1, OutLook Express email 033
1. Set up an email account with the display name of Liu Zongyuan and the email address of liuzhongyuan@kaoshi.com;
Account number: lzy, password: stu123; ; pop 3:pop 3 . kaoshi . com； smtp:smtp.kaoshi.com .
2. After receiving the email, reply to the sender with the subject "Thank you for receiving the email".
Note: Choose one of the two questions, WebMail and OutLook Express. If you do too much, you will only get the highest score.
42. Internet mail
1. Send a new email to leo@sohu.com and Virgo @ 163.com, with the subject of "Notice" and the text as "There will be a meeting in the second conference room next Monday 14:00. Please attend on time." .
2. Delete the mail in the draft box.
3. Forward the mail in the inbox to Eagle @126.com. ..
43, PowerPoint production
Open the sun.ppt file in the ppt folder and do the following:
1. Watch the slide, and add a hyperlink to the text "What's different from ordinary nuclear power" on 1 slide, so that you can link to the slide with the corresponding title.
2. Insert the picture s2.jpg on the second slide, with the picture position 3cm horizontally and 8cm vertically relative to the upper left corner of the slide.
3. Add a custom animation effect to the picture on slide 3, with vertical blinds and wind chimes.
4. Delete the fourth slide.
The way to read lies in enlightenment! The purpose of learning is to draw inferences from others. As long as you are familiar with the basic theory and combine appropriate exercises, you will naturally be handy in the exam.
Wish you success!