音序表能讓我們正確的讀漢語拼音字母表,音序表給每個字母規定了名稱,這是朗讀字母的根據,小學漢語拼音教學中字母表分為聲母表和韻母表 。
壹、新建工作簿,在 sheet1中輸入各列標題,並輸入想考查的漢字。
二、設置正確答案區並隱藏。
在C2格輸入或粘貼下列公式:=LOOKUP(CODE(A2),45217+{0,36,544,1101,1609,1793,2080,2560,2902.3845,4107,4679,5154,5397,5405,5689,6170,6229,7001,7481,7763,8472,9264}, ("A","B","C","D","E"","F","G"""H","J","K","L","M","N","O","P","Q"""R"","S","T","W",""X",""Y","Z"})這個公式的意義在於獲取漢字的代碼並將其轉換為英文字母。選中該列,設置隱藏。 ③設置評分 在D2格輸入=IF(B2="","",IF(B2=C2,10,0)),表示如果答對了就給10分,答錯了給0分,未答時不評分。