Using Excel to journalize and post adjusting entries, and to create the Adjustments and Adjusted Trial Balance columns of the worksheet The month$-$end adjusting entries are to be journalized and posted to T$-$accounts. A worksheet is to be used to help prepare the adjusted trial balance.

Use the blue shaded areas on the ENTERANSWERS tab for inputs.

To receive full credit, always use cell references and formulas, which result in an answer, and do not copy$/$paste from any of the tabs or hard$-$code$/$type in final answers.

$1$ Use Excel to journalize the adjusting entries. Use the blue shaded areas for inputs.

a$.$ To record the account name in the journal, click in the Account and Explanation column. A drop down arrow will appear to the right. Click the arrow and select an account from the chart of accounts. Use the explanation to help you with the entry.

$2$ Once the adjustments have been journalized, post the amounts to the correct side of the T$-$account. $($Note that the balance at the end of the month has been posted as a single entry.$)$

a$.$ The T$-$account totals will be calculated automatically.

b$.$ Total debits should equal total credits. The debit$-$credit balance checks for the trial balance and the adjusted trial balance appear to the right in red.

$3$ Use a formula to fill in the Adjustment debit and credit columns on the worksheet by referencing the adjusting entries.

$4$ Use a formula to add or subtract the adjustments to the trial balance amounts to calculate the amounts in the Adjusted Trial balance columns.

$5$ Use a formula to total the Adjustments and Adjusted Trial Balance columns.

$6$ On the Worksheet

a$.$ Format the cells requiring dollar signs.

b$.$ Format the cells requiring a single underline and cells requiring double underlines.

c$.$ Boldface the totals.

Excel Skills:

$1$ Enter numbers or text into cells.

$2$ Use Excel's data validation to select account names in journal entries.

$3$ Create formulas to add trial balance amounts to adjustment amounts to derive the adjusted trial balance.

$4$ Select the number format $($dollar signs$).$

$5$ Select the border $($single underline, double underline$).$

$6$ Select the boldface font. Use Excel to journalize the adjusting entries by referencing the opening account balances in the adjusted trial balance on the ENTERANSWERS$3$ tab and the journal entry descriptions found on this tab. Use the blue shaded areas for inputs.

$($To receive full credit, always use cell references and formulas, which result in an answer, and do not copy$/$paste from the Enteranswers$3$ tab or hard$-$code$/$type in final answers.$)$

HINTS

$1.$ Use an equalsign $(=)$ and appropriate cell references to ENTERANSWERS$1,$ ENTERANSWERS$2,$ and ENTERANSWERS$3$ worksheets for calculations to journalize Cedar's transactions for $2018.$ Enter numeric values where cell references are not available.

$2.$ Do not use an equal sign $(=)$ when entering a numeric value.

$3.$ Enter debits, then credits.

$4.$ Some of the input cells marked in blue may not require entries. Do not enter a zero.

Use Excel to journalize the adjusting entries by referencing the opening account balances in the adjusted trial balance on the $1$ ENTERANSWERS$3$ tab and the journal entry descriptions found on this tab. Use the blue shaded areas for inputs.

$($To receive full credit, always use cell references and formulas, which result in an answer, and do not copy$/$paste from the

Depreciation Expense $-$ Building Depreciation Expense $-$ Furniture

Dividends

Furniture Interest Expense

Jul $31$ Use a formula to fill in the Adjustment debit and credit columns on the worksheet by referencing the adjusting entries.

Use a formula to add or subtract the adjustments to the trial balance amounts to calculate the amounts in the Adjusted Trial balance columns. Use a formula to total the Adjustments and Adjusted Trial Balance columns.

$($To receive full credit, always use cell references and formulas, which result in an answer, and do not copy$/$paste from the Trial Balance or hardcode$/$type in final answers.$)$

CEDAR RIVER CORPORATION

Worksheet

July $31,2024$

HINTS

Some of the input cells marked in blue may not require entries. Do not enter a zero.

Cell$\_$Hint:

D$11$:E$36|$ Use an equal sign $(\backslash (=\backslash ))$ and appropriate cell references to ENTERANSWERS$1$ worksheet.

D$37$:E$37,$ F$11$:G$36|$ Use an equal sign $(\backslash (=\backslash ))$ and appropriate cell references to ENTERANSWERS$2$ worksheet.

D$37$:G$37|$ Use the function $=$SUM$()$ to total the Adjustments and Adjusted Trial Balance columns.