Step 30 of 40: Adjustment 6

This step illustrates how to make an Adjustment to an existing worksheet by referencing applicable cells.


Written description of the slides

In Step 30, you’re going to record an adjustment to the General Journal by multiplying the Notes Payable amount by the Notes Payable interest rate, divided by 12 to record one month of interest expense.

TIP: The interest rates and percentages shown here may differ from what appears in your workbook.

NOTE: The debit and credit amounts should be derived by formulas that utilize cell references. You will only receive partial credit if you type amounts into the cells or formula instead of referencing the corresponding worksheet cells.

Steps labeled YOUR TURN are reinforcing steps that present opportunities to apply concepts covered earlier in the assignment.

Excel for Windows & Mac

We're here to help

If you're stuck or confused, send a copy of your workbook by way of one of these methods:

Share: Click the Share command in the upper-right hand corner of the Excel screen, choose Share again, and then share the workbook with support@studentsexcel.com.

Upload: You can upload a copy of your workbook at www.studentsexcel.com/student-upload.

Email: You can email your workbook as an attachment to support@studentsexcel.com.

Be sure to listen to the audio portion of the video as you work through the assignment. The presenter elaborates further on what is being presented on screen and will offer tips. 

Still need help? Contact Us Contact Us