Useful tips

What is an Excel Capstone?

What is an Excel Capstone?

Excel Capstone Project 1. Your high school history class has just completed research papers about cultures that existed from the 15th through the 17th centuries. The next step in this assignment is to create a spreadsheet using data that you uncovered during your research.

How do I freeze the first 7 columns in Excel?

Freeze columns and rows

  1. Select the cell below the rows and to the right of the columns you want to keep visible when you scroll.
  2. Select View > Freeze Panes > Freeze Panes.

How do you calculate PMT in Excel?

PMT, one of the financial functions, calculates the payment for a loan based on constant payments and a constant interest rate. Use the Excel Formula Coach to figure out a monthly loan payment….Example.

Data Description
=PMT(A2/12,A3,A4) Monthly payment for a loan with terms specified as arguments in A2:A4. ($1,037.03)

How do I create a defined name in Excel?

Create a name by using the Define Name option

  1. Select the cell(s).
  2. On the Formulas tab, in the Define Names group, click the Define Name button.
  3. In the New Name dialog box, specify three things: In the Name box, type the range name.
  4. Click OK to save the changes and close the dialog box.

How can you display the first row first column all the time irrespective of scrolling?

Select cell B2. Then select the View tab from the toolbar at the top of the screen and click on the Freeze Panes button in the Window group. Then click on the Freeze Panes option in the popup menu. Now when you scroll, you should still continue to see row 1 and column A.

What is the PPMT function in Excel?

The PPMT function in Excel calculates the principal portion of a loan payment for a given period based on a constant interest rate and payment schedule. The syntax of the PPMT function is as follows: PPMT(rate, per, nper, pv, [fv], [type])

How is PMT calculated?

Payment (PMT) To calculate a payment the number of periods (N), interest rate per period (i%) and present value (PV) are used. For example, to calculate the monthly payment for a 5 year, $20,000 loan at an annual rate of 5% you would need to: Enter 20000 and press the PV button. Enter 5 and then divide by 12.

What is ESC in Excel?


  • Cancels an entry in the cell or Formula Bar.
  • Closes an open menu or submenu, dialog, or message window.
  • It also closes full screen mode when this mode has been applied, and returns to normal screen mode to display the ribbon and status bar again.

How do I keep the first row and first column visible in Excel?