‘壹’ wps琛ㄦ牸閲岋纴濡备綍蹇阃熺畻鍑哄悗闱㈢殑绛旀堬纴鍐欑殑璇︾粏涓镣癸纴璋㈣阿锛
绗涓绉嶆柟娉曪细阃変腑闇瑕佽＄畻镄勬暟鎹锛岃颁綇涓瀹氲侀櫎鏁版嵁涔嫔栧氶変腑涓琛岀┖锏界殑
‘贰’ excel做选择题时自动判断对错，并显示正确答案
假设F列没有标准答案
H2=IF(CHAR(64+MATCH(--LEFT(A2,FIND("+",A2)-1)+--SUBSTITUTE(RIGHT(A2,LEN(A2)-FIND("+",A2)),"=",""),B2:E2,))=G2,"正确","错误")
I2=CHAR(64+MATCH(--LEFT(A2,FIND("+",A2)-1)+--SUBSTITUTE(RIGHT(A2,LEN(A2)-FIND("+",A2)),"=",""),B2:E2,))
‘叁’ 濡傛灉琛ㄦ牸璁╄＄畻寮忕洿鎺ュ嚭缁撴灉锛屾庝箞锅氾纻
琛ㄦ牸璁╄＄畻寮忕洿鎺ュ嚭缁撴灉镄勬祦绋嫔备笅锛
宸ュ叿锛氭埓灏撷PS13-9350-3708銆亀in10銆乪xcel10.0.0.166銆
1銆侀栧厛镓揿紑excel琛ㄦ牸锛屽湪琛ㄦ牸涓杈揿叆鏁版嵁骞惰繘琛屼箻娉曡＄畻锛屽彲浠ョ湅鍒版ゆ椂鏄剧ず璁＄畻鍏寮忎笉鏄剧ず璁＄畻缁撴灉銆