graphic3
graphic1
 
graphic2

Exam 77-420 Microsoft Excel 2013
2. Create Cells and Ranges
2.2 Format Cells and Ranges: Apply Number Formats

Enter and Format the Data

2. Try it: Enter the Data

Select Cell B1 and type: 20000

Go to Home->Number->Number Format.
Select Accounting.

This is the Present Value of the car. (Pv)

 

Select Cell B2 and type: 36

This is the number of payment periods. (Nper)


Select Cell B3 and type: .04

Go to Home->Number->Number Format.
Select Percent Style.

This is the Interest Rate for the loan. (Rate)

 

Keep going...

Home->Number->Number Format