要一个100以内乘除法自动出题的Excel表格,比如56÷8×5=,连乘连除也...答:公式如下:=RANDBETWEEN(1,100)&LOOKUP(RANDBETWEEN(1,4),{1,"+";2,"-";3,"*";4,"/"})&RANDBETWEEN(1,100)&LOOKUP(RANDBETWEEN(1,4),{1,"+";2,"-";3,"*";4,"/"})&RANDBETWEEN(1,100)&"="结果见图:
用Excel做100以内乘法连加连减 自动出题答:=RANDBETWEEN(1,100)&CHOOSE(RANDBETWEEN(1,3),"+","-","×")&RANDBETWEEN(1,100)&CHOOSE(RANDBETWEEN(1,3),"+","-","×")&RANDBETWEEN(1,100)&"="