Chapter 4 Excel Review

Give the monthly interest for a house if the price is $350,000, down payment is $50,000, the interest rate is 5%, and it's over a period of 15 years.

=-PMT(5%/12,12*15,300000) Monthly payment=$2,372.38

Explain how to hide and unhide a worksheet.

Right click on the sheet tab and then click hide. To unhide, right click on the next sheet, click unhide, select the hidden sheet, and hit OK.

Explain how to protect a worksheet and allow people to select unlocked cells.

To unlock a range of cells, highlight the cells, right click, click format cells and then the protection tab. Make sure the locked box is not checked, and then hit okay. When you protect the sheet, make sure people can select unlocked cells and hit okay.

Explain how to define a range as a data table.

When you have all of the information, highlight the area that you want the data table to appear. Go to the Data tab, click on What-If Analysis, and then Data Table. Put a column input cell, a row input cell, or both and hit okay. Then you have values in the table so that you don't have to put the formulas in multiple times.

Explain how to define a name to a range of cells.

Highlight the range of cells that you want to name. In the formulas tab, click on define name and type in the name you want. Click OK.