The information technology academic proficiency test includes word operation questions and EXCEL operation questions. Have you ever practiced it? Below are the operation questions for the information technology academic proficiency test that I have compiled for your reference! The information technology academic proficiency test EXCEL operation questions

1. Change all genders M to male and F to female.

(Edit? Replace) 2. Use the formula to find the actual salary (actual salary = basic salary + bonus + subsidy - rent * 2) 3. Create a data area with "name" and "actual salary" in the worksheet

A column chart with a maximum scale value of 1500 and a main unit of 150. The chart position is placed in the C40:J60 area.

The requirements for the WORD operation questions of the Information Technology Academic Proficiency Test are as follows: 1. Enter the following text content in WORD 2. Set the page of the document: set the paper size to 16K, the top and bottom page margins are 2 cm, and the left and right page margins

is 3 cm; 3. Add a blank line before the article and enter "Forest and World Climate" as the title of the article; 4. Set the title to "Boldface", bold, "No. 3", and the alignment is "Centered";

5. Add "light green" character shading to the title; 6. Scale the title font to 80%, and widen the character spacing to 1.5 points; 7. Set the main text font to Song Dynasty, and the font size to 4 small; 8. Set the first paragraph

The spacing before the paragraph is 1 line, and the spacing after the paragraph is 0.5 line.

And set the spacing before each other paragraph to 0.5 lines, and the spacing after the paragraph to 0.5 lines.

9. Adjust the indentation of the first line of each paragraph to 2 characters; 10. Merge the first and second paragraphs of the document into one paragraph.

Then separate the second paragraph from the agency.

11. Set the line spacing of the first paragraph of the document to 1.5 times the line spacing; 12. Set the line spacing of the second paragraph of the document to 20 points; 13. Replace all "CO2" appearing in the article with "carbon dioxide", and set the font color to green

, and add a single wavy line; 14. Insert a picture named "Forest.JPG" between the first and second paragraphs of the document. Find the picture yourself on your computer, and set the height of the picture to 6 cm and the wrapping mode.

?Four-sided?, horizontal alignment is centered.

14. Set the position of the picture relative to the page margin: the absolute position of horizontal alignment is 5 cm, and the absolute position of vertical alignment is 5 cm.

16. Crop the picture by 0.2 cm from top to bottom, left and right, and the image has a "watermark" effect, with a brightness of 70% and a contrast of 60%.

17. Add a box to the words "World Wildlife Fund" in the article; 18. Set the second paragraph to have a dropped cap, the dropped font is official script, the number of dropped lines is 3 lines, and the distance from the main text is 0.2 cm; 19

.Divide the first paragraph of the text into three columns with equal column widths, 1 character spacing, and add separators; 20. Add a header to the document?Forests and World Climate?, insert the page number in the footer, and align it in the center;

21. Adjust each column in the table to the same width (evenly distribute the columns); 22. Delete the row in the table with the year "1996".

23. Insert a column between fisheries and the sum ?Average?; 24. Insert a row between the rows 1978 and 1992 ?1985? Here is the document that needs to be processed: A report published by the WWF not long ago said that due to

The global forest area is declining rapidly. Existing forests are no longer able to absorb the CO2 emitted by various countries. Therefore, the entire climate situation has entered a vicious cycle.

The agency said that currently 20 major forest accumulation areas on five continents around the world have been affected by climate change to varying degrees.

Due to climate warming, one-third of the world's forests are at risk. Climate change not only destroys forests, but also triggers the emission of CO2 in dead wood and humus, thereby aggravating climate change and putting the entire ecological environment into a vicious cycle.

The declining forests weaken the ability to absorb CO2, causing the CO2 content in the atmosphere to increase rapidly.

Information Technology Academic Proficiency Test Operation Practice Questions 1. Single-choice questions 1. The data type integer in VB is represented ().

A. Boolean type B. Long integer type C. Integer type D. String type Answer: The data types in VB refer to the following table 2. In the email address hnjjzx@163.com, the host name of the mail server is ( )

.

A. hnjjzx B. 163.com C. 163 D. com Answer: Answer to this question: B Email address format: username@network server host name, such as zhangsan@sina.com, etc.