Where is it, please? Answer the question? Select the corresponding command under the menu and complete the following operations according to the requirements of the topic. The specific requirements are as follows:
Note: What appears below? Candidate folder? Both are %USER%
Open the text file in the examinee folder? Written materials. txt？ , complete the following operations as required and use the file name? WORD.docx？ Save the generated document.
background material
Zhang Jing is a third-year undergraduate. Through all kinds of understanding and analysis, she hopes to practice in a company next summer. In order to get a rare internship opportunity, she intends to elaborate a concise and eye-catching resume with Word, such as? Resume reference style. jpg？ As shown in the figure, the requirements are as follows:
1. Adjust the document layout, requiring the paper size to be A4, the margins (up and down) to be 2.5cm, and the margins (left and right) to be 3.2cm.. ..
2. According to the needs of page layout, insert two standard color rectangles of orange and white at appropriate positions, in which the orange rectangle occupies A4 format and the text wrapping mode is set to? Floating on words? As the background of your resume.
3. Refer to the sample file, insert a rounded rectangle with orange as the standard color, and add text? Internship experience? , insert 1 rounded rectangular dashed boxes.
4. Refer to the sample file, insert the text box and text, and adjust the font, font size, position and color of the text. Among them? Zhang Jing? It should be a standard orange wordart. What path should we follow to seek the special effects of words? Up-bending arc? .
5. according to the needs of page layout, insert pictures under the examinee folder? 1.png？ Cut and adjust according to the sample, and delete the cutting area of the picture; Then insert pictures of 2.jpg, 3.jpg and 4.jpg as needed, and adjust the positions of the pictures.
6. Refer to the sample file, use the standard orange arrow in the appropriate position of the shape (hint: the horizontal arrow uses the linear arrow), and then insert? SmartArt？ Graphics, and make appropriate editing.
7. Please refer to the sample file in? Analysis of promotional activities? Using bullets in four places? Tick tock? , in? Used to be the monitor? Waiting for four carets? The color of the five-pointed star is standard red. Adjust the position, size, shape and color of each part to present a unified and good visual effect.
Excel operation problem
Where is it, please? Answer the question? Select the corresponding command under the menu and complete the following operations according to the requirements of the topic. The specific requirements are as follows:
Note: What appears below? Candidate folder? Both are %USER%
Xiao Zhao is a college student who has been working for a long time. He used to use Excel to record his monthly personal expenses. At the end of 20 13, Xiao Zhao entered the detailed data of monthly expenses in the name of? Expenditure schedule. xlsx？ Excel workbook document in.
Please help Xiao Zhao organize the analysis list according to the following requirements:
1. On the worksheet? Xiao Zhao's beautiful life? Add a table title to the first row. Xiao Zhao 20 13 expenditure schedule? , and by merging cells, put them at the top and center of the whole table.
2. Apply a theme to the worksheet, increase the font size, appropriately increase the row height and column width, set the center alignment, and remove the table title? Xiao Zhao 20 13 expenditure schedule? Add appropriate borders and shading to the worksheet to make it more beautiful.
3. Set the cell data type corresponding to various monthly expenditures and total expenditures to? Currency? Type, no decimal, with RMB currency symbol.
4. Calculate the total monthly expenditure, average monthly expenditure of various projects and average monthly total expenditure through functions; And sort the worksheet in ascending order of total monthly expenditure.
5. use? Conditional format? Function: Use different font colors and fill colors to highlight the data in cells with monthly single expenditure amount greater than 1000 yuan; Display the data in the cell where the total monthly expenditure is greater than 1 10% of the total monthly expenditure in another color, and it is appropriate to use the color that does not block the data.
6. What is it? Year and month? With what? Clothing. Clothing? Insert a new column between columns? A quarter? , the data is generated by the function according to the month, for example, 1 corresponds to March? 1 quarter? From April to June? The second quarter?
7. Copy the worksheet? Xiao Zhao's beautiful life? , put the copy on the right side of the original table; Change the label color of the replica table and rename it? Quarterly summary? ; Delete? Average monthly expenses? Corresponding line.
8. Through the classified summary function, the average monthly expenditure amount of various expenditures in each quarter is calculated in ascending order.
9. What is it? Quarterly summary? Create a new name after the worksheet? Line chart? In this worksheet, based on the classified summary results, a line chart with data labels is created, and various expenses are marked on the horizontal axis. By comparing the quarterly average expenditures of various expenses, the data labels are added to the highest quarterly average monthly expenditures of various expenses.
PPT operation questions
Where is it, please? Answer the question? Select the corresponding command under the menu and complete the following operations according to the requirements of the topic. The specific requirements are as follows:
Note: What appears below? Candidate folder? Both are %USER%
Please according to the provided? Ppt materials and design requirements. docx？ Design and make presentations, and use file names? ppt.pptx？ Inventory, the specific requirements are as follows:
1. The presentation must contain 6 slides, and the content of each slide is the same as that of? Ppt materials and design requirements. docx？ The serial number in the file corresponds to the content and the built-in theme is selected for the presentation.
2. Set the slide of 1 page as a title slide with a title? Learning concept of learning society? Does the subtitle include the production unit? Computer teaching and research section? And the date of production (format: XX, XX, XX).
3. Set the slides on pages 3, 4 and 5 in different formats and make changes according to the file? Ppt materials and design requirements. docx？ The content layout puts all its text into the corresponding slides, and the fourth slide must contain the specified pictures.
4. according to? Ppt materials and design requirements. docx？ The animation categories in the file prompt the design of animation effects in the presentation, and ensure that the order of animation effects in each slide is reasonable.
5. What are the highlights in the slide? Ppt materials and design requirements. docx？ The key content in the document (the bold part of the material), including font, font size, color, etc.
6. As a table of contents page, the slides on page 2 are represented by a vertical box list SmartArt graphic. Ppt materials and design requirements. docx？ Three contents to be introduced in the file, and set hyperlinks for each content. Click each link to jump to the corresponding slide.
7. Set the slide on page 6 to a blank layout, and change the slide background of this page to a solid color fill.