1、演示所用的工具为一个Excel办公软件,使用的版本是office家庭和学生版2016。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/09fa513d269759eea602dfe1bcfb43166d22df4e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、新建一个Excel表格并在表格中添加用来求解的二元一次方程。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/18d8bc3eb13533fa953c2c04a6d3fd1f41345b15?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、然后我们将x的系数,y的系数以及常数都写下来,放到辅助区域。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/63d0f703918fa0ec9ef5da27289759ee3d6ddbee?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、然后选中D6和D7单元格,注意是同时选中两个单元格,然后在地址栏中输入函数“=MMULT(MINVERSE(A6:B7),C6:C7)”,函数表示使用A6~B7的区域以及C6到C7区域的数据来求解该二元一次方程。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a5c27d1ed21b0ef420be2674d3c451da81cb3e41?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、然后同时按住键盘上的Ctrl键和Shift键,接着单击键盘上的回车键,可以看到我们求得该二元一次方程的结果。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/fc1f4134970a304e38711ed0dfc8a786c9175c4c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)