单词表制作

考纲识别：

=IF(ISERROR(FIND("CET4",E2)),IF(ISERROR(FIND("CET6",E2)),IF(ISERROR(FIND("考研",E2)),IF(ISERROR(FIND("IELTS",E2)),IF(ISERROR(FIND("TOEFL",E2)),IF(ISERROR(FIND("GRE",E2)),IF(ISERROR(FIND("TEM4",E2)),IF(ISERROR(FIND("TEM8",E2)),"?","TEM8"),"TEM4"),"GRE"),"TOEFL"),"IELTS"),"考研"),"CET6"),"CET4")

音标：

=IF(A2="","",FILTERXML(WEBSERVICE("http://dict.youdao.com/search?q="&A2&"&doctype=xml"),"//phonetic-symbol"))

词义：

=IF(A2="","",FILTERXML(WEBSERVICE("http://fanyi.youdao.com/translate?&i="&A2&"&doctype=xml"),"//translation"))

Table Convert Online