Required information Applying Excel 2-2: Using Basic Excel Skills to Prepare a Trial Balance [The following information applies to the questions displayed below.] In this Applying Excel exercise you will practice using basic formulas to create a trial balance. Watch the tutorial video and then complete Parts 1 and 2 to practice and apply the skills demonstrated in the videa. Prepare Excel spreadsheet (Part 1) Downlood the 'Applying Excel' worksheet below and save it to your computer. View the tutorial video, and then complete the worksheet. Enter formulas in cells that contain question marks (only use formulas, not all cells will require a formula). After entering formulas in all of the necessary cells that contain question marks, verify that the amounts match the example below. Check your worksheet setup and formulas by changing Prepald Rent. Salates Payoble. Common Stock and sarvice Revenue accoust belances td \$20.000. $10,000.570000 and $25,000, respectivety. You sheuld now have an out-of-balance condition with total debits of $476,500 and total credis of $234,600. If you do not get this antwer, review your woikthet and the farmulas you used Sove your completed Applying Excel form to your computer ond then upload it hare by clicking "Browse." Next click "Sove." You will use this worksheet to answer questions in Part 2 . Required information Applying Excel 2-2: Using Basic Excel Skills to Prepare a Trial Balance [The following information applies to the questions displayed below.] In this Applying Excel exercise you will practice using basic formulas to create a trial balance. Watch the tutorial video and then complete Parts 1 and 2 to practice and apply the skills demonstrated in the videa. Prepare Excel spreadsheet (Part 1) Downlood the 'Applying Excel' worksheet below and save it to your computer. View the tutorial video, and then complete the worksheet. Enter formulas in cells that contain question marks (only use formulas, not all cells will require a formula). After entering formulas in all of the necessary cells that contain question marks, verify that the amounts match the example below. Check your worksheet setup and formulas by changing Prepald Rent. Salates Payoble. Common Stock and sarvice Revenue accoust belances td \$20.000. $10,000.570000 and $25,000, respectivety. You sheuld now have an out-of-balance condition with total debits of $476,500 and total credis of $234,600. If you do not get this antwer, review your woikthet and the farmulas you used Sove your completed Applying Excel form to your computer ond then upload it hare by clicking "Browse." Next click "Sove." You will use this worksheet to answer questions in Part 2
