:Common mail merge application skills How to use mail merge to create test papers-Writing skills免费ppt模版下载-道格办公

Common mail merge application skills How to use mail merge to create test papers

  • Picture and text skills

When the teacher comes up with a multiple-choice test paper, he can quickly create the test paper through the mail merge function, How to do this?


分界线.png

▪First prepare a set of data source tables for the test paper content. The table includes question numbers, titles, and options. When ready, save the table in XLS format, and then open the WPS document .


录制_2021_04_20_14_20_44_321.gif


▪Step 1: Click the "Mail" button under the "Reference" tab, select Open Data Source and import the test paper content data source table in XLS format into the document.


录制_2021_04_20_14_21_29_82.gif


▪Step 2: Click "Insert Merge Field"-"Question Number"-"Title", insert an English "period" between the question number and the title, and then wrap the line below Insert the four options in sequence.


录制_2021_04_20_14_22_03_913.gif


▪Step 3: Frame the text, make simple layout adjustments to the font line spacing, etc., and then "Insert NEXT field" below the option. Please note that when inserting the NEXT field Make sure View Consolidated Data is turned off, otherwise you won't be able to see the NEXT field code.


录制_2021_04_20_14_24_26_1.gif


▪Step 4: Copy and paste the formatted domain name until it fills up the page. At this time, click "Merge into new document", and finally correct the formatting deviations Just make adjustments to some of the questions.


录制_2021_04_20_14_24_55_954.gif


Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/chang-jian-you-jian-he-bing-ying-yong-ji-qiao-ru-he-yong-you-jian-he-bing-zhi-zuo-shi-juan.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
single-end

Related Suggestion