T$-$Accounts Ledger Assignment

In an Excel spreadsheet, recreate the T$-$Accounts shown below. Then, using formula functions, balance each account by recording the sum of the debit and credit sides $(1$ mark for each sum$).$

To finish, record the ending balance using formula functions on the correct side $(2$ marks for each correct balance on the normal balance side $-$ left or right$).$

$16$ marks

$\backslash$table$[[$Bank$],[3,000,150],[400,35],[100,120],[300,200]]$

A$/$R J$.$ Wilson

$\backslash$table$[[300,50],[100,270]]$

A$/$P Waxman

$\backslash$table$[[$Co$.],[100,450],[250,],[100,]]$

L$.$ McNally, Capital $175$

$5,500$

$400$