can you please help me solve B, C, D, and E? i got A and can not get the rest of them

The most efficient way to find answers to all of the questions below is to use correct formulas in the spreadsheet applet above. If you use formulas that contain cell references (rather than just the numbers), it will save time since you can grab the lower right corner of the cell to drag such formulas down the column. For example, you can calculate the interest per period in cells E2 to E6 as follows. First, type the following into cell E2: 0.01*C2/02. Make sure you use the arrow key or the mouse to navigate out of the cell. Then, grab the lower right corner of cell E2, and drag the formula down to E6. All of the periodic interest rates will be calculated and the precise unrounded values will be stored in the applet for future reference. Even when rounded values are displayed, the precise values are saved in the background. If you decide not to use the spreadsheet, remember that you should not round intermediate steps and only round final answers Chambers and Crane Credit Union (CCCU) offers customers five different savings account options: Account 1 offers an APR of 8.8%, compounded annually, Account 2 offers an APR of 8.841%, compounded monthly. Account 3 offers an APR of 11.067%, compounded daily. Account 4 offers an APR of 9.878%, compounded weekly Account 5 offers an APR of 11.414%, compounded quarterly Use this account information to answer the questions below. Round all dollar amounts to the nearest cent (2 decimal places). (a) Use the orange block of the spreadsheet applet to find the APY for each account. The formula to use is given in the column heading DB. If you type a formula into cell D9 with cell references to B9 and C9 included in that formula, then you can drag the formula through to D13. This will display all of the APYs in column E After computing each account's APY, rank CCCU's five account options below by listing them in order from the account producing the greatest