Excel Problem 1 Use the Excel template provided for this problem. Create the spreadsheet necessary to answer the questions on the next page. The formulas are given below. Turn in your Excel file to the Assignments section of Blackboard. Tun in the answers to the questions on page 2 to the Assignments section of Bb (with your Excel file). So there are two files to turn in: this Word file and the Excel file. Use the Excel template to solve the following problem Tracey charged $4,800 (cell D3) of stuff to her credit card while Christmas shopping. Her credit card company charges 1.5% (cell D4) interest per month and has a minimum monthly payment of 2.5% (cell D6) of the balance or $20 (cell D7), whichever is greater. Use the template provided to set up the spreadsheet below to determine how many months it will take Tracey to pay off the $4,800 balance on her credit card if she always makes the minimum monthly payment and doesn't charge any additional stuff to her card. USE THE TEMPLATE! 1. Input these formulas for the following cells: Cell G10 cil D11 Ell F11 G11 Formula =D3 -G10 -C11 SD$4 IFE11 SDS6 SDS7.EI1 SDS6,IF (SDS7 E11SDS7 E11) E11-F11 Select cells C11:G11 (this means all the cells in row 11 from columns C through G). Copy these cells all the way down through Row 244. To copy: See the tiny little box in the corner of cell G11? Put the fat plus sign on that box until it turns skinny. When it turns to a skinny plus sign, left click and hold, and then drag down to Row 244. 2. Currency, and two decimal places. Change "Symbol" to None (it might already be set at None). 3. With the fat plus sign inside one of the highlighted cells, right click. Select Format Celis 4. Input these formulas for the following cells: CellFormula D245-SUM(D11:D244) F245 SUM F11:F244) F247 D245/F245 5. Answer the questions on the next page. NOTE: don't look at the Row number when answering the questions, look at the number in Column B. Excel Problem 1 Use the Excel template provided for this problem. Create the spreadsheet necessary to answer the questions on the next page. The formulas are given below. Turn in your Excel file to the Assignments section of Blackboard. Tun in the answers to the questions on page 2 to the Assignments section of Bb (with your Excel file). So there are two files to turn in: this Word file and the Excel file. Use the Excel template to solve the following problem Tracey charged $4,800 (cell D3) of stuff to her credit card while Christmas shopping. Her credit card company charges 1.5% (cell D4) interest per month and has a minimum monthly payment of 2.5% (cell D6) of the balance or $20 (cell D7), whichever is greater. Use the template provided to set up the spreadsheet below to determine how many months it will take Tracey to pay off the $4,800 balance on her credit card if she always makes the minimum monthly payment and doesn't charge any additional stuff to her card. USE THE TEMPLATE! 1. Input these formulas for the following cells: Cell G10 cil D11 Ell F11 G11 Formula =D3 -G10 -C11 SD$4 IFE11 SDS6 SDS7.EI1 SDS6,IF (SDS7 E11SDS7 E11) E11-F11 Select cells C11:G11 (this means all the cells in row 11 from columns C through G). Copy these cells all the way down through Row 244. To copy: See the tiny little box in the corner of cell G11? Put the fat plus sign on that box until it turns skinny. When it turns to a skinny plus sign, left click and hold, and then drag down to Row 244. 2. Currency, and two decimal places. Change "Symbol" to None (it might already be set at None). 3. With the fat plus sign inside one of the highlighted cells, right click. Select Format Celis 4. Input these formulas for the following cells: CellFormula D245-SUM(D11:D244) F245 SUM F11:F244) F247 D245/F245 5. Answer the questions on the next page. NOTE: don't look at the Row number when answering the questions, look at the number in Column B