$\%$

References

Maple Moving Company has provided you its list of accounts and unadjusted balances as of December $31,$ Year $2,$ along with selected

year$-$end data. The Controller has asked you to prepare an income statement and balance sheet for the year ended December $31,$

Year $2.$ Use the information included in the Excel Simulation and the Excel functions described below to complete the task.

Cell Reference: Allows you to refer to data from another cell in the worksheet. In the Excel Simulation below, if $"=$B$3"$ is entered

in a blank cell, the formula outputs the result from cell B$3,$ which is $$62,500$ in this example.

Basic Math functions: Allows you to use the basic math symbols to perform mathematical functions. You can use the following

keys: $+($plus sign to add$),-($minus sign to subtract$),*($asterisk sign to multiply$),$ and $/($forward slash to divide$).$ In the Excel

Simulation below, if $"=B3+B4"$ is entered in a blank cell, the formula adds the values from those cells and outputs the result,

which is $229,660$ in this example. If using the other math symbols, the result is an appropriate answer for the function.

SUM function: Allows you to refer to multiple cells and adds all the values. You can add individual cell references or ranges to

utilize this function. In the Excel Simulation below, if $"\frac{?}{S}=UM(B3,B4,B5)"$ is entered in a blank cell, the formula outputs the result of

adding those three separate cells, which is $297,260$ in this example. Similarly, if $"=$ SUM$($B$3$:B$5)"$ is entered in a blank cell, the

formula outputs the same result of adding those cells even though they are expressed as a range in the formula, so the result is

$297,260$ in this example.