Excel exam focuses on: converting all kinds of files into Excel tables (pay attention to importing plain text files), using functional formulas to calculate, copy, absolute address, sort, filter, conditional format, making charts (types, titles, legends, series, fonts, font sizes), hiding, classifying and summarizing, cells (alignment, borders, numbers, fonts), and worksheets (.
The words of a family are for reference only, hope to adopt them!
What books should I read in the first-level examination of computer grade examination? Computer level is not difficult. Just learn the basic computer textbooks of the university, and then download some questions on the Internet. Do more and you will be able to pass ~
How long does it take to pass the Computer Rank Examination? Hello, Ling Xue. Com answers for you:
Every level is different. If it is the first level, it is not too difficult. Self-study should be no problem, especially in the first-level office. Skilled office software is enough, plus some basic computer knowledge.
I hope I can help you.
What is the first level of computer grade examination? The contents of computer level 1 examination are basically unified, but they are all basic knowledge.
The written test is about some basic knowledge in the textbook, with choices and blanks.
Computer operations include: Chinese character input ability test;
Basic operation and application of Windows operating system;
Word operates document creation, opening and basic editing operations, text search and replacement, multi-window and multi-document editing. Save, protect, copy, delete, insert and print files. Basic operations of document layout such as font format, paragraph format, page format, page setting, print preview, etc. Graphic function of Word, graphic editor and its use;
Excel spreadsheet operation workbook and worksheet basic concepts, worksheet creation, data input, editing and typesetting. Basic operations such as inserting, copying, moving, renaming, saving and protecting worksheets. The concepts of absolute address and relative address of cells, the input of formulas in worksheets, and the use of common functions. The concept of data table, the use of record table, the classification, screening, search and classification of records. Creation and formatting of charts;
PowerPoint operates the creation, opening and saving of presentations. The use of demonstration view, the production of slides, the arrangement of text, the insertion of pictures and charts, and the selection of templates. The manuscript and deletion of slides, the order of presentations, the insertion of multimedia objects, the packaging and change of presentations, the setting of slide formats and the setting and printing of slide show effects.
; Internet dial-up connection, simply using browser (IE) and e-mail (E_mail) to send and receive;
Practice more. No problem.
How to calculate the first level of computer grade examination? Only the scores passed are excellent. Try to do better. You can also consult the teachers of training institutions.
Computer Grade Test1Class B Simulation Test is free online.
Is there a tutorial for Computer Rank Examination Level 1 B? basic requirement
1. Have basic computer knowledge.
2. Understand the basic composition of microcomputer system.
3. Understand the basic functions of the operating system and master the usage of Windows.
4. Understand the basic knowledge of Word table processing, master the basic operations of Word and Excel (or WPS) in Windows environment, and master a Chinese character input method skillfully.
5. Understand the basic concepts of computer network, and master the use of Internet e-mail and browsers.
6. Have knowledge of computer safe use and computer virus prevention.
Examination content
First, the basic knowledge
L The concept, types and application fields of computers; Configuration and main technical indexes of computer system.
2. The concept of number system and the conversion between binary and decimal.
3. Computer data and coding. The storage unit of data (bits, bytes, words); Characters and ASCII codes, Chinese characters and their coding.
Second, the composition of the micro dust collector system
The composition and function of computer hardware system: the function and usage of CPU, memory (ROM, RAM) and common input and output devices.
2. Composition and function of computer software system: the concepts of system software, application software and programming language (machine language, assembly and high-level language).
3. Computer safe operation, virus and its prevention.
Third, the function and classification of the operating system
1. Basic concept, function and classification of operating system.
2. Composition of operating system, concepts of file (document), file (document) name, directory (folder), directory (folder) tree and path.
3.3 Use. window
(1) Features, functions, configuration and running environment of Windows.
(2) Use of 2)Windows start button, taskbar, menu, icon, etc.
(3) The running and quitting of application programs, the use of "My Computer" and "Resource Manager".
(4) Basic operations of documents and folders: opening, creating, moving, deleting, copying, renaming, searching, printing and setting properties.
(5) Copy the floppy disk, format the floppy disk, and check the disk properties.
(6) Installation, deletion, selection and screen display of Chinese input methods, and the use of Chinese DOS mode.
(7) The setting and use of shortcut keys.
4. Use of accessories.
Fourth, the function and use of thesaurus processing software
1. Basic functions of Chinese Word, startup and exit of Word, and working window of Word.
2. Master a common Chinese character input method.
3. Document creation and opening, document editing (basic operations such as text selection, insertion, deletion, search and replacement), multi-window and multi-document editing.
4. Save, copy, delete, insert and print files.
5. Font, font size setting, paragraph format and page format setting, and print preview.
6. The graphic function of Word, the graphic editor of Word and its use.
7.Word table making, data input and editing in the table, data sorting and calculation.
Verb (abbreviation of verb) The function and use of Chinese Excel
1. The basic concept, function, startup and exit of the electronic form Exool.
2. Basic operations such as creating, inputting, editing and saving workbooks and worksheets.
3. The use and input of formulas and common functions in the worksheet.
4. The concept of worksheet database, sorting, filtering and searching of records.
Compilation of 5.5. Exool chart and corresponding operation.
Six, the basic knowledge of computer network
1. The concept and classification of computer network.
2. Simple concepts of computer communication: Modom, network card, etc.
3. The characteristics of computer local area network and wide area network.
4. The concept of Internet and its simple application: the sending and receiving of e-mail and the use of browser IE.
Examination mode
1. Full computer operation: 90 minutes.
2. Within the specified time, use a microcomputer to complete the following operations:
(1) 30 comprehensive multiple-choice questions
(2) 2) Basic operation of Windows.
(3) Chinese character input ability test
(4) text operation.
(5)Excel operation.
A question in the first level of computer grade examination? If it is this year's exam, I suggest buying a book to read. The book of future education is good, and there is a real simulation environment to practice. I think it's good. I recommend it to you!
Why can't I apply for Computer Rank Examination Level 1? No, you can't apply for the first level. You can take the second grade directly.
Level 1 examination
Level: Operating skill level. Check the basic computer knowledge and computer operation ability, including office software, graphics and image software.
Subjects: computer foundation and MS Office application, computer foundation and WPS Office application, computer foundation and Photoshop application, and three subjects.
Form: computer examination is completely adopted, and the computer examination time of all subjects is 90 minutes, with a full score of 100.
Qualifications: The total score is not less than 60 points. ...
Ask a first-level question of computer grade examination. Please tick E, Format-Font, and tick "superscript".