Excel Exam | Part 2 excel template - Saved Search (Option - Q) Home Insert Draw Page Layout Formulas Data Review View Automate Help Comn X Arial 12 AAY a? Wrap Text General Paste B U D ab Merge & Center ~ $ ~ % Conditional Format As Styles Insert Delete Format Formatting v Table Clipboard Font Alignment Number Styles Cells " X V fx Unearned Revenue that has been earned on December 31 amounted to $2,570 B C D E F G H K M N O P Q R S ADJUSTING ENTRIES 12 points For each of the following, journalize the necessary adjusting entry: Dec 31 a) Insurance expired during the year is $500. 31 b) The balance in the Supplies account is $3,245. A count at the end of the fiscal period revealed $1855 of supplies on hand. 31 c) The estimated depreciation on vehicles is $300 31 d) A business pays weekly salaries of $1,125 on Friday for a five-day week ending on that day. Journalize the necessary adjusting entry at the end of the year, assuming the fiscal period ends on Tuesday. 31 e) Prepaid Rent has a balance of $4,450. At the end of the fiscal period, Prepaid Rent amounted to $3,250. 31 f) Unearned Revenue that has been earned on December 31 amounted to $2,570\f