Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create a formula in E4 that will calculate the Interest amount at a rate of 11.5% Create a formula in F4 that will calculate the
Create a formula in E4 that will calculate the Interest amount at a rate of 11.5% Create a formula in F4 that will calculate the Balance owing. Use the Fill Handle to carry both formulas down thru E4:F9. Use Auto Sum to calculate the Totals in B10:F10. Format the input data to Comma style and the Balance column to Accounting style. Apply the Total style to A10:F10, apply Accounting format. Set the worksheet to fit on one page, center horizontally and add a footer. Put the date on the left, sheet tab in the center, and file name on the right. Change the sheet tab name to your First Name
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started