New Question Type of Computer Two-Level Office Operational Questions I. Word Processing In the new year, the company's propaganda department needs to design and produce a New Year's greeting card and a label containing the mailing address for the sales department to distribute to the relevant customers.Complete the design and production of greeting cards and labels according to the following requirements. 1.Open the document "Word Material. docx" under the candidates'folder.Save it as "Word. docx" (". docx" as the file extension), and then all operations are based on this file, otherwise they will not be segregated. 2.Referring to the sample document "Greeting Card Sample. jpg", according to the following requirements, the content of the main document "Word. docx" is designed and typesetted, requiring all content to be arranged in one page, and no blank page can be generated: 1) The paper size is defined as 18 cm wide, 26 cm high, 13 cm upper margin, 3 cm lower, left and right margins. 2) Set the picture "background. jpg" under the candidates'folder as a "texture" form to the page background. 3) Insert a clip painting named good luck in the middle of the header, change its dark color to a certain red series, and superimpose an artistic word "Congratulations on the New Year" on the clip painting.And adjust its size, position and direction appropriately. 4) Draw a horizontal line of ruins that runs through the page and equals the width of the page in the middle of the page, requiring it to be large vertically and horizontally relative to the page. 5) Refer to the example "Greeting Card Sample. jpg", modify the font, font size, color, paragraph and other formats of the lower half of the text. 3.Create a greeting card for each designated customer according to the following requirements. 1) In the document "Word.docx", insert the customer's name after "respectful", insert the words "lady" or "sir" after the name, and save the customer's information in the Excel document "customer address book.xlsx". 2) Create a greeting card with an exclusive page for all customers in Beijing, Shanghai and Tianjin. The result is stored in the examinee folder under the name of "greeting card. docx", which should not contain blank pages.At the same time, the operation result of the main document "Word.docx" is saved. 4.Refer to the label example shown in Figure 1 below, and make a label attached to an envelope for mailing for each customer who already has a greeting card. The requirements are as follows: Postal Code: Address of the Recipient of Zip Code: Address of Communication: Name and Sir Next Record Postal Code: Address of the Recipient of Zip Code: Address of Communication: Name and Sir Figure 1: Sample tag master document 1) Make a label named "address" on A4 paper. The label is 13 cm wide and 4.6 cm high. The label is 0.7 cm apart from the edge of the paper.Left margin 2 centimeters, cousins 1.2 centimeters apart, printed on A4 paper per page 5 Label.Save the label as "Word. docx" under the examinee folder. 2) According to the example shown in Figure 1, in the main document of the label, relevant content is input, relevant customer information is inserted, and proper typesetting requires that both the "addressee" and "addressee" text occupy 7 character widths. 3) Only one label is generated for each customer in Shanghai and Beijing, and the document is saved in the examinee folder under the name of "label. docx".Save the label main document "Word2.docx" at the same time.II. Spreadsheet 1. Using the data information in the worksheet of "provincial code", "number of votes of each province and city" and "sampling number of each province and city", the statistical work is completed in the worksheet of "sampling rate of votes of each province and city". Among them, the data sequence of "region" column should not be changed; 2. The number of votes in each province and city is the sum of four batches of votes in the worksheet of "the number of votes in each province and city" for each member of the team. 3. The sampling number of each province and city is the sum of the three cut-and-distribute samples corresponding to the "sampling number of each province and city" worksheet. 4. The sampling rate of each province and city is the ratio of the corresponding sampling number to the number of votes. The digital format is set as the percentage pattern, and 2 decimal digits are retained. 3.The

docxDoc New Question Type of Computer Two-Level Office Operational Questions

Professional Docs > Common > Other > Preview
5 Pages 0 Downloads 78 Views 3.0 Score
Tips: If the document is garbled or fails to read, please download the document
New Question Type of Computer Two-Level Office Operational Questions Page 1 New Question Type of Computer Two-Level Office Operational Questions Page 2 New Question Type of Computer Two-Level Office Operational Questions Page 3 New Question Type of Computer Two-Level Office Operational Questions Page 4 New Question Type of Computer Two-Level Office Operational Questions Page 5
Uploaded by admin on 2019-10-16 01:09:37
Rate
You can enter 255 characters
What is my domain?( answer:www.45doc.com )
comments
  • No comments yet