试算平衡表上的总账期初借方余额合计与贷方余额合计不相符,常见的原因是编制试算平衡表时将有关数字抄写错误。本期之期初余额,应是上期之期末余额,如果在上期曾编制过试算平衡表,且期末余额相等,则说明是在编表时存在抄写错误。另一种原因是,因上期期末的试算平衡表上期末借方合计与贷方合计不相符,导致本期试算平衡表上的期初余额合计与贷方余额合计不相符。你可以根据以上原因进行查证,就可以解决了。
"具体解决步骤如下:<br>举例来说。某科成绩有平时、期中、期末三个成绩,现在要求按2、3、5的比例来计算总评成绩。<br><img src=""https://iknow-pic.cdn.bcebos.com/203fb80e7bec54e748e2d998b5389b504fc26a2e?x-bce-process%3Dimage%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_jpg"" max-height=""200""><br>1、在E2单元格输入“=b2*0.2+c2*0.3+d2*0.5”,然后回车。<br><img src=""https://iknow-pic.cdn.bcebos.com/29381f30e924b899b2c7b9be62061d950b7bf6b9?x-bce-process%3Dimage%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_jpg"" max-height=""200""><br>2、计算出“stu-001”的总评成绩<br><img src=""https://iknow-pic.cdn.bcebos.com/42a98226cffc1e178a5b4cb74690f603728de954?x-bce-process%3Dimage%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_jpg"" max-height=""200""><br>3、把光标移到E2单元格的右下角,会发现光标变成黑十字。点住鼠标左键不松,向下拖动直到E4松开左键。我们看到成绩都出来了。<br><img src=""https://iknow-pic.cdn.bcebos.com/1f178a82b9014a90f5da863ba5773912b21bee54?x-bce-process%3Dimage%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_jpg"" max-height=""200""><br>拓展资料:<br>"