1. Computer development? Types and application fields?
2. Composition and main technical indicators of computer software and hardware system?
3. Representation and storage of data in computer?
4. The concept and application of multimedia technology?
5. What are the characteristics of computer viruses? Classification and prevention?
6. The concept of computer network? Composition and classification; The concept and prevention of computer and network information security?
7. The concept of Internet network service? Principle and application?
Second, the function and use of Word (operation questions account for 30 points)
1.Microsoft Office application interface usage and function settings?
2. The basic function of 2.Word, document creation? Editor? Save? Basic operations such as printing and protection?
3. Set the font and paragraph format? Apply document styles and themes? Adjust page layout and other typesetting operations?
4. Making and editing tables in documents?
5. Graphics in the document? Editing and processing of image (film) objects, use of text boxes and document parts, input and editing of symbols and mathematical formulas?
6. What are the columns of the document? Pagination and section operations, document headers? Footer setting, document content reference operation?
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 graphic materials and extract relevant information to quote into Word documents as required?
Third, the function and use of Excel (operation questions account for 30 points)
The basic functions of 1 Basic operation of Excel, workbook and worksheet, and control of working view?
2. Input of worksheet data? Edit and modify?
3. Cell formatting operation? Data format setting?
4. Protection of workbooks and worksheets? * * * Enjoy the revision?
5. A reference to a cell? The use of formulas and functions?
6. Linkage operation of multiple worksheets?
7. How to create mini-graphs and charts? Editing and decorating?
8. Sorting of data? Screening? Classified summary? Group display and consolidated calculation?
9. Use of PivotTable and PivotChart?
10. data simulation analysis and operation?
1 1. Simple use of macro function?
12. Get external data and analyze it?
13. Analyze data materials, and extract relevant information as required and quote it into Excel documents?
Four? The function and use of PowerPoint (operation questions account for 20 points)
The basic functions and operations of 1.PowerPoint, how to view and use the presentation?
2. What is the theme setting of the slides in the presentation? Background settings? Master and use?
3. The text in the slide? Graphics? SmartArt？ Image (film)? Chart? Audio? Video? Editing and application of artistic words and other objects
Use?
4. Animation of the objects in the slide? Sliding switching effect? Interactive settings such as link operation?
5. Slide setting, presentation packaging and output?
6. Analyze the graphic data, and extract relevant information and quote it into the PowerPoint document as required?