How do you do this problem in excel (formula view , normal view)

Need more practice? Try this Extra Practice Quiz (check figures in Chapter Organizer, p. 308) 1. Complete the following without a table (round each calculation to the nearest cent as needed): Rate of Number of compound periods to be Total Total Principal Time interest Compounded compounded amount interest $500 1 year 8% Quarterly a. b. c. 2. Solve the previous problem by using compound value (FV). See Table 12.1. 3. Lionel Rodgers deposits $7,000 in Victory Bank, which pays 4% interest compounded semiannually. How much will Lionel have in his account at the end of 8 years? 4. Find the effective rate (APY) for the year: principal, $8,000; interest rate, 6%; and com- pounded quarterly. Round to the nearest hundredth percent, 5. Calculate by Table 12.2 what $1,800 compounded daily for 5 years will grow to at 6%