Operation Problems in Computer Level 2 Examination

Operation Problems in Computer Level 2 Examination

Early computers were programmed manually by machine instructions, which was time-consuming, laborious, error-prone and difficult to read, debug and modify. The following are the operation questions I have compiled about the computer-based examination of MSoffice. Welcome to refer to them!

First, the spreadsheet questions (***50 points)

Please choose the command to enter the examinee folder under the answer menu and complete the following operations according to the requirements of the topic. Note: The following files must be saved in the examinee folder. Open the workbook Excel.xlsx under the examinee folder and follow the requirements.

Complete the following operations and save the workbook with this file name (Excel.xdsx). A company plans to make statistics on the quarterly sales of its products, open the "Excel.xlsx" file and operate according to the following requirements:

(1) Calculate the contents of the columns of "First Quarter Sales" and "Second Quarter Sales" in the worksheet of "First Quarter Sales Table" and "Second Quarter Sales Table" respectively, both of which are numerical values, with 0 decimal places reserved.

(2) In the Product Sales Summary Table, calculate the contents of the columns of "Total Sales in the First and Second Quarters" and "Total Sales in the First and Second Quarters", which are numeric, with 0 decimal places reserved; Without changing the original data order, the sales ranking is given according to the total sales in the first and second quarters.

(3) Select the contents of the cell area of Al: E2 1 in the product sales summary table, establish a PivotTable report, with the row label as the product model and the column label as the product category code, calculate the total sales in the first and second quarters, and put the table into the cell area starting from the current worksheet G 1.

Second, the statement topic (***50 points)

Please choose the command to enter the examinee folder under the answer menu and complete the following operations according to the requirements of the topic.

Note: The following files must be saved in the examinee folder. Document "Annual Report on Statistical Work of Beijing Municipal Government". Docx "is a written material obtained from the Internet. Please open this document and do typesetting and saving according to the following requirements:

(1) Delete all Spanish spaces in the document.

(2) Set the paper size to 16, the top margin to 3.2cm, the bottom margin to 3cm, and the left and right margins to 2.5cm.

(3) Make a cover with the first three documents of the material, so that it can occupy one page (see the document "Cover Sample" for reference samples).

pri9”).

(4) Convert the paragraphs marked in blue under the heading "Consultation" into tables, and apply table styles to the tables to make them more beautiful. On the basis of table data, insert a pie chart below the table to reflect the proportion of various consulting tables, and only the percentage needs to be displayed in the pie chart.

(5) Set the paragraphs beginning with "one" and "two" to be displayed as "title 1" in the document; The paragraphs beginning with "(1)" and "(2)" are set as "Heading 2" style; The paragraphs beginning with "1", "2" and "2" are set to the heading 3 style.

(6) Add a hyperlink to the "Government Website of the Bureau of Statistics" marked in red in the third paragraph of the text, and the link address is "/". At the same time, add a footnote after the website of the Bureau of Statistics.

(7) Display all contents except the cover in two columns, but the above tables and related charts still need to be displayed in the middle column without columns.

(8) Insert a table of contents between the cover and the text. The table of contents should include the title L-3 level and the corresponding page number. The table of contents occupies a page without columns.

(9) In addition to the cover page and directory page, add a header to the main page, which contains the title of the document "Annual Report on Beijing Municipal Government Information Disclosure" and the page number. The homepage code is required to start from 1 page, in which odd page headers are displayed on the right, page numbers are displayed on the right, even page headers are displayed on the left, and page numbers are displayed on the left.

(10) Save the typeset document in the original word format, that is, the file name is Annual Report on Statistical Work of Beijing Municipal Government. Docx ",and then generate another PDF document with the same name to save.

Three, word processing problems (***50 points)

Please choose the command to enter the examinee folder under the answer menu and complete the following operations according to the requirements of the topic.

Note: The following files must be saved in the examinee folder.

background material

After this year's photography competition, the school photography club hopes to show its excellent works in club activities with PowerPoint. These excellent photos are saved in the exam folder and named after photos (1). Jp9 ~ photo (12). jp9。 Now, please complete the production work in PowerPoint according to the following requirements:

(1) Create a photo album with photos in PowerPoint application (1). JP9— Photo (12). JP9 * * * 12 photo. Include 4 pictures in each slide, and set each picture as a "center rectangle shadow" frame shape.

(2) Set the album theme to "album theme". The pptx style is placed in the exam folder.

(3) Set different switching effects for each slide in the photo album.

(4) Insert a new slide after the title slide and set the slide as "Title and Content" layout. Enter "Appreciation of Excellent Works of Photography Society" in the title position of this slide; And enter three lines of text in the content text box of this slide, namely "lakes and mountains in spring", "melting ice and snow" and "pastoral scenery".

(5) Convert the three lines of words of "Spring Scenery of Lake", "Snow Melting" and "Pastoral Scenery" into a SmartArt object with the style of "snake picture key list", and define Photo( 1).jP9, Photo(6).jP9 and Photo(9).jP9 as the display pictures of this SmartArt object.

(6) Add "Erase" to smartAn object from left to right to enter the animation effect, and require that SmartArt object elements can be displayed one by one during the slide show.

(7) Add a slide jump link to the SmartArt object element, so that you can jump to the third slide by clicking the label shape of "Lakes and Springs", the fourth slide by clicking the label shape of "Melting Snow" and the fifth slide by clicking the label shape of "Pastoral Scenery".

(8) Take the "ELPHRG0 1.wav" sound file in the exam folder as the background music of the album, and start playing it during the slide show.

(9) Save the photo album as "PowerPoint.pptx" file.

Computer secondary MSoffice computer test

basic requirement

1. Master basic computer knowledge and computer system composition.

2. Understand the basic knowledge of information security and master the basic concepts of computer virus and prevention.

3. Master the basic concepts and applications of multimedia technology.

4. Understand the basic concepts and principles of computer networks, and master Internet network services and applications.

5. Collect information correctly and skillfully use word processing software, spreadsheet software Excel and presentation making software Power Point.

6. Master the operation skills of Word and skillfully use it to prepare documents.

7. Master the operating skills of Excel and skillfully use it for data calculation and analysis.

8. Master the operating skills of PowerPoint and skillfully use it to make presentations.

Examination content

First, basic computer knowledge.

1. The development, types and application fields of computers.

2. Composition and main technical indexes of computer software and hardware system.

3. Representation and storage of data in computer.

4. The concept and application of multimedia technology.

5. The characteristics, classification and prevention of computer viruses.

6. The concept, composition and classification of computer network; The concept and prevention of computer and network information security.

7. The concept, principle and application of Internet network service.

Second, the function and use of Word

1.Microsoft Office application interface usage and function settings.

2. Basic functions of 2.Word, such as document creation, editing, saving, printing and protection.

3. Set fonts and paragraph formats, apply document styles and themes, adjust page layout and other typesetting operations.

4. Make and edit tables in the document.

5. Edit and process graphics and image (film) objects in documents, use text boxes and document parts, and input and edit symbols and mathematical formulas.

6. Document column, page and section operations, document header and footer settings, and document content reference operations.

7. Document review and revision.

8. Use the mail merge function to make and process documents in batches.

9. Multi-window and multi-document editing, and the use of document views.

10. Analyze the graphic data, and extract relevant information according to the requirements and quote it into the Word document.

Third, the function and use of Excel

The basic functions of 1 Basic operations of Excel, workbooks and worksheets, and control of working views.

2. Enter, edit and modify worksheet data.

3. Cell formatting operation and data formatting.

4. Protection, enjoyment and modification of workbooks and worksheets.

5. Reference of cells, use of formulas and functions.

6. Linkage operation of multiple worksheets.

7. Creation, editing and modification of mini-graphs and charts.

8. Data sorting, screening, classified summary, grouped display and consolidated calculation.

9. Use of PivotTable and PivotChart.

10. Data simulation analysis and operation.

1 1. Simple use of macro function.

12. Obtain external data and analyze and process it.

13. Analyze the data, and extract relevant information according to the requirements and quote it into the Excel document.

Fourth, the function and use of PowerPoint

The basic functions and operations of 1.PowerPoint, the viewing method and use of the presentation.

2. Theme setting, background setting, and the mastery and use of slides in the presentation.

3. Edit and apply the text, graphics, SmartArt, images (movies), charts, audio, video, wordart and other objects in the slide.

4. Interactive settings such as object animation, slide switching effect and link operation in slides.

5. Slide setting, presentation packaging and output.

6. Analyze graphic materials, and extract relevant information according to requirements and quote it into PowerPoint documents.

Examination mode

Adopt paperless examination and computer operation.

Examination time: 120 minutes

Software environment: operating system Windows 7.

Office software Microsoft Office 20 10

Within the specified time, complete the following operations:

1. Multiple choice questions (20 points) (including the basic knowledge of public affairs 10).

2.Word operation (30 points)

3.Excel operation (30 points)

4.PowerPoint operation (20 points)

;