\fChapter 5 Excel Problem - Excel Sign in X File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Share Arial A 29 Wrap Text DP AutoSum AY Fill - Sort & Find & Paste I U - - Q- A - $ ~ % " 38 48 Insert Delete Format B E Merge & Center Conditional Format as Cell Formatting " Table " Styles ~ Clear * Filter ~ Select Font Alignment Number Editing Clipboard F Styles Cells N59 X V f A B D E F G H J K M N 0 P Q R S T U 37 JOB-ORDER COST SHEET 38 Job 16 39 DIRECT MATERIALS DIRECT LABOR OVERHEAD 40 Reg. No Amount Ticket Hours Rate Amount Rate Activity Amount 41 42 43 44 45 46 COST SUMMARY 47 Balance, March 1 $ 39,890 Direct Materials Direct Labor Overhead Total cost 39,890 JOB-ORDER COST SHEET 56 Job 17 57 DIRECT MATERIALS DIRECT LABOR OVERHEAD 58 Reg. No Amount Ticket Hours Rate Amount Rate Activity Amount 59 60 61 Ex 5.20 (+ 100% Ready Accessibility: Investigate 8:12 PM Type here to search X W P 1/27/2022Chapter 5 Excel Problem - Excel Sign in X File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Share Arial A 29 Wrap Text DP AutoSum AY Fill - Paste B I U - B- Q- A - E Merge & Center $ ~ % " 38 48 Conditional Format as Cell Insert Delete Format Sort & Find & Formatting " Table " Styles ~ Clear * Filter ~ Select Clipboard F Font Alignment Number Styles Cells Editing T121 X V f A B C D E F G H K L M N 0 P R S T U 104 Direct Labor 105 Overhead 106 Total Cost S 107 108 109 110 111 3 & 4. Select Job Nos. from drop-down lists. Only balances will be graded. 112 113 Work in Process Cost of Goods Sold 114 Ending Balance Ending Balance 115 Jobs Balances Jobs Balances 116 117 118 Total 119 Total S 120 121 122 123 124 125 126 127 128 129 Ex 5.20 + Ready End Mode C& Accessibility: Investigate 100% Type here to search D W 8:15 PM P 1/27/2022