Wenzhou color matching recruitment

The advanced application technology of office software is in Zhejiang province, but there is none in the whole country.

The problem type is something like this.

Typical practice of words

Note: The admission ticket number of this question is set as: 091761126100123.

1. Typesetting the text, in which:

(1) Chapter names are in the style of "Title 1" and centered; The numbering format is: Chapter X, where X is automatic sorting.

(2) Section names are in the style of "Heading 2" and aligned to the left; The numbering format is: multilevel symbol, x.y. X is the chapter number, and y is the chapter number (for example: 1. 1).

(3) Create a new style and name it "Style"+the last four digits of the admission ticket number; These include:

Font A: the Chinese font is "Italic -GB23 12", the western font is "Times New Roman" and the font size is "Xiaosi";

B. Paragraph: the first line is indented by 2 characters, with -0.5 line before the paragraph and 0.5 line after the paragraph, and the line spacing is 1.5 times;

C. other formats, default settings.

(4) "1"is the second place. Everything that appears is automatically numbered, and the numbering format remains unchanged; The places where "1)" and "2" appear are automatically numbered, and the numbering format remains unchanged.

(5) Apply the style in (3) to the unnumbered characters in the text.

Note: chapter names, section names, table characters, table and figure titles are not included.

(6) Add the caption "Figure" to the figure in the text, which is located at the bottom and center of the figure.

A the serial number is "chapter number"-"the serial number of the drawing in the chapter" (for example, the second drawing in chapter/kloc-0, with the caption number 1-2);

B the description of the figure uses the next line of text of the figure, and the format is the same as that of the label;

C. the picture is centered.

(7) Compare "as shown in the following figure" in the text with "as shown in figure X-Y", where "X-Y" is the caption number of the figure.

(8) Add the title "Table" to the table in the text, which is located above the table and centered.

A the serial number is "chapter serial number"-"serial number of the table in the chapter" (for example, 1 table in 1 chapter, with the caption number1-1);

B. The description of the form uses the words on one line of the form, and the format is the same as that of the label;

C. the table is in the center.

(9) For the "table below" where "as shown in the table below" appears in the text, use cross-reference and change it to "as shown in table X-Y", where "X-Y" is the number of the table title.

(10) Insert a footnote in the text (excluding the title) where "table tennis" first appeared, and add the words "table tennis originated from court games and developed into a national sport".

2. Insert chapters in sequence before the text, and use the table of contents function in Reference to generate the following contents:

(1) Part 1: Contents. These include:

A. the "table of contents" uses the style of "title 1" and is centered;

B. Under "Directory" are directory items.

(2) Section II: Graphic Index. These include:

A "graphic index" uses the style of "title 1" and is centered;

B Under "Chart Index" are chart index items.

(3) Section III: Table Index. These include:

A "table index" uses the style of "title 1" and is centered;

B under "table index" are table index items.

3. The text is divided into several sections, and each chapter is an independent section.

4. Add a footer. Use the field to insert and center the page number in the footer. These include:

(1) For the part before the text, the page numbers are in the format of "I, ii, iii…… ...", and the page numbers are continuous;

(2) For sections in the text, the page number format is "1, 2, 3 ...", and the page numbers are continuous, and each section always starts with an odd number of pages.

(3) Update the directory, graph index and table index.

5. Add the title of the text. Use the fields to add content according to the following requirements and display it in the center. These include:

(1) odd pages, and the header text is "chapter number"+"chapter name".

(2) For even pages, the text in the header is "section number"+"section name".

EXCEL typical exercise

operation requirement

1. Use the array formula to calculate the total score and average score of Sheet 1, and save the calculation results in the Total Score column and Average Score column of the table.

2. Use Rank function to count the RANKing of each student in Sheet 1 and save the ranking result in the "rank" column of the table.

3. Use logical function to judge whether the score of each student in each course in Sheet 1 is higher than the average score, if so, save the result as true, otherwise save the result as false, and save the result in the column of "Is the score of three subjects higher than the average score" in the table.

4. According to the results in Sheet 1, use statistical function to count the number of people in each score section of the "Mathematics" test results, and save the statistical results to the corresponding position in Sheet2.

5. Copy Sheet 1 to Sheet3 and perform advanced screening on Sheet3. The requirements are as follows:

A. Screening criteria: Chinese > = 75, Mathematics > = 75, English > = 75, and Total Score > = 250;

B. save the results in Sheet3.

6. According to the results in Sheet 1, create a PivotTable report in Sheet4, which requires:

A. show whether the number of people in all three subjects exceeds the average score;

B. The row area is set to "Whether the scores of the three subjects are above average";

C. whether the scores in all three subjects are above the average.

operation requirement

1. Use the HLOOKUP function to automatically fill in the parking unit price in Sheel 1

Requirements: According to the "Parking Price List" in Sheel 1, the "Unit Price" column in the "Parking Record Form" is automatically filled in according to different vehicles.

2. In Sheel 1, the time function is used to calculate the parking time of cars in the parking garage, which requires:

The calculation method of formula A is "delivery time-delivery time"

B format is "hours: minutes: seconds"

(For example, one hour, fifteen minutes and twelve seconds in parking time is "1: 15: 12")

3. Using the function formula to calculate the parking fee requires:

Calculate the parking fee according to the length of parking time, and fill in the "payable amount" column with the calculation result.

note:

A. Parking is charged by the hour, and if it is less than one hour, it is charged by one hour;

B. People who exceed 15 minutes per hour can accumulate an extra hour. (For example, 1 hour 23 minutes is charged as 2 hours)

4. Use the statistical function to make statistics on the "Parking Record Form" in Sheel 1 according to the following conditions, and fill in the corresponding cells, which require:

A. Statistical parking fee is greater than or equal to the number of parking records in 40 yuan.

B. Calculate the maximum parking fee

5. Advanced screening requirements of SHEEL 2:

A. the screening criteria are: "model"-automobile, and "payable amount" > = 30;

B. save the results in Sheel2.

6. According to Sheel 1, create a data perspective 1, which requires:

A. display the summary of charges for various models;

B the line area is set to "vehicle type";

C. The charging item is "amount payable";

D. Save the corresponding PivotTable report in Sheel3.

Typical practice of PPT for advanced office software

1. Use templates and color schemes

(l) Set the design template of the home page as "Globe" and the design templates of other pages as "ocean";

(2) Create a new custom color scheme, in which the color scheme is:

A. background color: red (r) is 50, green (g) is 100 and blue (b) is 255;

B. Text and lines: black (that is, the RGB values of red, green and blue are all 0);

C. Title text: red (that is, the RGB values of red, green and blue are 255, 0 and 0 respectively);

D emphasize text and visited hyperlinks: green (that is, the RGB values of red, green and blue are 0,255,0 respectively);

E other colors (including shadows, fills, accents, accented words and hyperlinks) are all white (that is, the RGB values of red, green and blue are all 255).

When finished, add the color scheme as a standard color scheme.

(3) Modify the color scheme created in (2), change the title text color to green, and add this color scheme as a standard color scheme after completion;

(4) applying the modified color scheme to the first page; Apply the modified color scheme to the remaining pages.

2. Set up and apply the motherboard of the slide according to the following requirements.

(1) For the title motherboard applied to the home page, set the title style to "Bold, No.54";

(2) For general slide masters applied to other pages, insert the current date (format standard means "2008- 1-3 1") in the date area, and insert the slide number (page number) in the footer.

3. Set the animation effect of the slide show. The specific requirements are as follows:

(1) Set the animation scheme of the title text on the home page to the "inward dissolution" effect that comes with the system.

(2) For the second slide, set the following custom animation effects in order (that is, in the order of a→h when playing):

A. Set the entry effect of the title content "main content" as "chessboard";

B. Set the input effect of the text content "Design Principle Classification" to "Color Typewriter", and it will start automatically after the title content appears 1 second without mouse click;

C, setting the input effects of the theme-oriented principle, the data-driven principle and the prototype design principle of the text content as "sliding" in turn;

D, setting the input effect of "specific steps" of text content as "diamond";

E, setting the emphasis effect of the text content "design principle classification" as "waveform";

F, setting the action path of the theme-oriented principle of the text content as "Right";

G, setting the exit effect of the text content "data-driven principle" as "folding";

H. Add "Forward" and "Back" operation buttons to the page. Click the button to jump to the previous page and the next page of the current page respectively, and set the entry effect of these two action buttons to "fly in".

4. Set the switching effect of slides according to the following requirements:

(1) Set the switching effect between all slides to "vertical combing";

(2) Switch automatically every 5 seconds, or click the mouse to switch manually.

5. Set the slide show effect according to the following requirements:

(1) Hide the fourth slide, so that you can skip the hidden page directly when playing;

(2) Select the first three slides for circular projection.

6. Output the presentation according to the following requirements:

(1) Publish the first three pages of the presentation as a web page;

(2) Save to the specified path (examinee folder) and name it "DPPT -Ans.mht".

I hope it helps you, come on!