Get instant live Excel expert help to learn how to find range in Excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
In cell B5, insert the PMT formula in excel using the data from the range B2:B4—be sure to divide the interest rate by 12, multiply the years by 12, and display the payment as a positive number
Solved by S. U. in 23 mins
In cell A1, apply the Title cell style. In A7, type Option #1 Reduce the Loan and then Copy the format from cell A1 to cell A7. Copy the range A2:B5, and then Paste the Values & Number Formatting to cell A8. In cell B2, type 425000 to restore the original loan amount.
Solved by K. H. in 19 mins
In A13, type Option #2 Increase Years. Format the cell the same as cell A7. Copy the range A2:B5, and then Paste the Values & Number Formatting to cell A14. Display the value in B15 with two decimal places, and then in cell B3, type 10 to restore the original value.
Solved by M. Q. in 14 mins
On the Payment Table worksheet, in the range A2:B4, enter the following row titles and data. Format the Amount of Loan as Currency with 0 decimals. Format the Interest as Percentage with 2 decimals.
Amount of Loan $425,000
Period (months) 120
Interest rate (per year) 5.25%
Solved by M. C. in 13 mins
In cell C8, type 60—the number of months in a 5-year loan. In D8, type 120—the number of months in a 10-year loan. Fill the series through cell H8. Apply Bold and center the range C8:H8.
Solved by D. S. in 12 mins
In the range B9:B16, enter varying interest rates in decrements of .5% beginning with 7.0% and ending with 3.5%. If necessary format all the interest rates with two decimal places, and then bold and center the range.
Solved by A. W. in 30 mins
Create a Data Table in the range B8:H16 using the information in cells B2:B4 in which the Row input cell is the Period and the Column input cell is the Interest rate.
Solved by D. Q. in 27 mins
Display the Advertising Costs by Quarter worksheet, and then apply appropriate Currency [0] cell style to the range B6:E6 and to the range B18:E18. Apply the Comma [0] cell style to the range B7:E17, and then apply the Total cell style to the range B18:E18.
Solved by T. A. in 22 mins
Create a new conditional formatting rule that uses a formula to determine which cells to format in the range A4:A57. Apply bold font style and blue font color (eighth column under Standard Colors) to film titles with a rating of PG-13 and a profit of more than $125
Solved by C. H. in 12 mins
I am trying to find central tendency using descriptive statistics in excel. I need to know what to put in my input range and what format. Thank you.
Solved by D. B. in 30 mins