In the balance sheet shown in Figure 2.1, the Cash classification of Current Assets section contains this formula:
The names in this formula refer to ranges in the cash worksheet shown in Figure 2.2.
In the worksheet shown in Figure 2.2, there are three named ranges:
NovemberEndCashBalance refers to cell E3. This amount is the closing cash balance at the end of November, the prior month.
DecemberCashDebits refers to cells C4:C24. This range contains all the deposits to Bell Books' corporate checking account that were made during December.
DecemberCashCredits refers to cells D4:D24. This range contains all the withdrawals from Bell Books' ...