Second-class certificate of national computer grade examination
Computer second-level necessary shortcut keys
Fast summation
ctrl+shift+； When entering the system
The space between/between/between/rooms.
Alt+F4 Fast Shutdown Program
Ctrl+shift+-→ Continue to the right.
choose
AIt+f9 edit field code
ALT+ mouse rectangle selection
Ctrl+shift+↓ continue down.
choose
Ctr 1+ 1 format cell.
Ctrl+shift+f9 Batch Cancel
hyperlink
Ctrl+sfhit+ enter run array
Ctrl+a switches punctuation between Chinese and English.
Ctrl+Shift switching input method
Ctrl+: enter the system date
Ctrl+ space Chinese and English input method
Turn into
Ctrl+A select all
Ctrl+C copy
F 12 save as
Ctr|+x shear
F 1 help key
Ctrl+F lookup
F2 renaming
Ctrl+H substitution
F4 repeats the previous operation.
Ctrl+Z undo
F5 refresh key
Ctrl+S save
F9 update domain
Ctrl+Enter batch filling
Windows+D quickly returns to the desktop.
face
Ctrl+E center alignment
Windows+E quick opening instrument
computer
Ctrl+f9 insert field
Ctrl+R right alignment.
Windows+L quick locking function
brain
Ctrl+k insert hyperlink
Difficulties and key points of PPT
1. Create a new slide (from the outline, reuse slides)
2. Set the layout, section and rename section.
3. Convert text to smartart
4. Replace fonts uniformly
5. Insert hyperlinks to different objects
6. Insert the date and time, slide number and footer, and set the title slide not to be displayed.
Show.
7. Insert audio (set the background music, and it is best to bring a small earphone during the exam. Yes
Some computers will find that 8/8 audio playback devices cannot insert audio. )
8. Set the slide size, orientation, apply the slide theme and set the background style.
9. Set the slide switching effect and automatic film changing time.
10. Animate different objects, and set animation sequence and start mode. special
It needs to pay attention to the animation of charts and the animation settings of smartart objects.
1 1. Create a custom slide show scheme.
12. Hide slides
13. Set the slide show mode and options.
14. Home view setting (typical topic Zhenti 25)
15.- Delete all comments at once.
Key points and difficulties of words
1. font setting (if the title provides a sample, you can set and repair it yourself.
The more similar the changes, the better. As long as you modify them, you can score. ) Typical true questions: true questions 1,
Zhenti 2 1
2. Paragraph setting (note that the first line is indented, and the unit of paragraph spacing is line and point, single
Bits can be manually entered, and the fixed values of line spacing and multi-line spacing)
3. New style, modification, copying, giving, use of style set (test frequency
High ratio, a lot of problems)
4. Replacement is the focus of the exam (batch modification of content, style, batch deletion of content)
three
5. Select the rectangle in the selection and select the text with similar format.
6. Paste selectively (Paste Excel tables into documents and change with data sources.
And automatically update)
7. Insert the cover that comes with the system (the date field control and time should be put on the sports cover first.
Control deletion)
8. Insert a table in the document, format it, convert the text into a table, and then repeat it.
The complex title line is the key t secret 1.
9. The composition of the chart part (pay attention to the setting of primary and secondary axes) is the key point.
Yes Difficulties.
10. Make a resume with picture shapes and smartart (real question 1 1).
1 1. Insert a hyperlink (to a file, a web address, a bit in this document).
The shortcut key is ctrl+K.
12. upgraded version: different odd-even pages, different home pages and different page formats.
Ultimate Edition: Different chapters display different titles, multiple page number formats, and combinations.
Odd and even pages are different from the first page.
13. Insert the text box template, draw the text box, set the format of the text box, and use
Text box to make a paper cover.
Key points and difficulties of words
14. Insert document attributes and insert fields (fields of document information type styleref)
Domain), save the selected content to the document part library, and modify the domain code (using domain generation)
It is difficult for code to modify page numbers).
15. Insert WordArt (arc text effect), initial sinking setting, system
Date insertion (automatic update), symbol insertion (checkmark and five-pointed star)
16. Apply theme, theme color and font settings.
17. Page settings: margins, binding lines, paper direction/size, page number range (
Symmetrical margins, spelling pages), the distance and boundary between the header and footer, and specify the line network.
Network, set the number of rows.
18. Column part: Set the number of columns, separation lines, column spacing, column breaks, tables and graphs.
The table bar is centered.
19. Delimiter section, focusing on section break (next page, consecutive pages, even pages, odd pages
three
20. Distinguish the difference between watermark and page background, and the way to print the background.
2 1. The setting of page boundaries and artistic boundaries are often tested. Please pay attention to comparing the page edges.
Box, paragraph border.
22. Index part, mark index items, insert indexes, delete indexes in batches, and according to the text
Automatic label indexing. m .
23. Mail merge part (pay attention to the difference between the original document and the result document, and pay attention to editing and receiving.
Set the personnel list, set the rules)
24. Simple and complex Chinese conversion, new annotations and document protection.
25. Use of outline view, use of navigation pane and adjustment of display scale.
Excel difficulties focus on anger.
1. Adjust the table format (row height, column width, border and shading)
2. Adjustment of cell format (alignment and numbering, in which attention should be paid to cross-column merging.
Center, custom formatting)
3. Selective pasting of data (transposed pasting)
4. Absolute quotation, relative references, mixed quotation.
5. Set the conditional format (the difficulty is to determine the conditional format with formulas)
6. Apply tabular format
7. Define the name of the data region and convert the table into a region.
8. Custom sorting (it should be noted that sorting is a descending stroke order, and sorting is a custom order.
Sort, sort by color)
9. Screening (automatic screening and advanced screening. Automatic screening is used more and needs characteristics.
Don't pay attention to advanced filtering)
10. Insert the chart (the composite chart is still the key point, and the mini chart is also a big test point) 1 1.
Page settings (paper size, paper direction, margins, large print scale)
Point)
12. Get external data (from website, from text focus)
13. Use of decomposition
14. Data validity setting (text length formula for integer and decimal date series)
15. Consolidated calculation
16. Classification and summary (Important, it is important to note that you should press before classification and summary.
Sort the classification fields. If you can't classify and summarize, please convert the table into ordinary.
Region)
17. Insert the PivotTable report (pay attention to the use of grouping and report filtering page functions) and insert it.
Into the pivotchart.
18. Use of simulation operation table and scheme manager (test center added, real question 25)
Excel function formula is angry
1, sum function: sum = sum (A 1: A5.5) equals 60.
2. Conditional summation function: sumif = sumif (A2: A6. “0 1”，F2:F6)。
3. Average function: AVERAGE=AVERAGE(A 1:A5.5) is equal to 10.
4. Maximum (minimum) value function: max (min) = max (A 1: A5) equals 27.
5. Statistical data number function: COUNT=COU NT
(A 1:A5) is equal to 3.
6. Conditional counting function: COUNTIF=COUNTIF
(A3:A6。 "? 7p* ") is equal to 3.
7. Calculate the number of non-blank cells Function: COUNTA
8. Search function: VLOOKUP=VLOOKUP
( 1.A2:C 10.3.TRUE)
9. Ranking function: RANK (ranking times, range and ranking method) =RANK(A3. A2:
A6. 1)
10, current date function: TODAY () function: returns the current date of the computer system.
1 1. Find the year of a given date: YEAR=YEAR.
("2006/04/24") is equal to 2006.
12, current date and time function: NOW () function: returns the current date of the computer system.
Period and current time.
13, if (condition x? Value 1? Value 2) = if (D3 > = 80? "Excellent"? If (D3÷= 60? "medium"
, "Failure *"
14, logic and function: and condition: 80 < = C2 < 90. It is expressed as sum (c)
2 & gt= 80 C2 & lt； 90) …
15, logic or function: or score greater than or equal to 80 or score less than 90, or (c
2 & gt= 80 C2 & lt； 90)
16, left intercept function: LEFT(X, n)=LEFT ("showroom ",1) The result is
Chen
17, right sectional function: right (x? n)
18, find the remainder function: MOD(X 1, x2), return the remainder of X 1/X2, and the result.
The symbol is the same as the divisor (x2) .................................. &) One heart ...)
19, rounding function: ROUND(X, n)
20. Intermediate load function: MID(X, m n) = mid.
("fluid flow", 1.5) and other "fluids"
2 1. Find the string length function: LEN(X)=LEN("abcdefg ") and the result is 7.
Not only have the above formulas, but also remember these functions. "
O
Date function: date, today, date, year, month.
H. Days and working days
Numerical function: mod stands for remainder, int stands for integer and round stands for rounding function.
Numbers, rounded up. Round down, big and small.
Text functions: left, right, middle, length, text,&;
Query function: vlookup, search
Array function is a big difficulty. Note that the shortcut key for running the array function is
(trl+ shift+enter (typical topic straight 16)