漢字注音檢測：輸入漢字自動取音序首字母，比對答案自動計分：

1. A 欄：題目漢字（如「胡」）；B 欄：學生填寫音序；C 欄：自動取正確音序公式：
   =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"})
   （依 GB2312 區位碼對應音序首字母）
2. D 欄判斷計分：=IF(B2="","",IF(B2=C2,10,0))（答對 10 分、錯 0 分、未填不計分）。
3. 向下填充公式，輸入答案即時顯示分數。

圖 1-6：輸入題目 → 音序公式 → 判斷計分 → 填充 → 測試自動評分

原理：CODE() 取漢字內碼，LOOKUP() 對應音序區間表。可擴充至注音符號、拼音全拼比對，構建自動化語文測驗工具。