graphic2

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

graphic1

Home ->Number->Decrease Decimal

Memo to self: Changing the decimals is like making the number Bold or Red. This is decimal formatting. The REAL value of the number is displayed in the Formula bar.

 

Format the Decimals

How do you format the number of decimal places you see?

 

2. Try it: Practice with Decimals

Select: Cell D2.

Enter a new salary: $45,000.68

 

Go to Home -> Number.

Click on Decrease Decimal.

 

graphic3

 

What Do You See? Watch the numbers in Cell D2 as you click on Decrease or Increase Decimal. Did the number Round Up?

Keep going...