In this
lesson, you will learn how to:
1. Practice modifying cell contents and formats.
2. Use the Paste Special options.
3. CONCATENATE (combine) data with a formula.
4. Modify and format TEXT with formulas.
5. Use DATE and TIME formulas.
6. Use FINANCIAL formulas to calculate a car payment
This lesson introduces the Formulas Ribbon.
1.
Formulas -> Function Library->Text ->Concatenate, page 62
2.
Formulas -> Function Library->Text ->UPPER, page 65
3.
Formulas -> Function Library->Text ->SUBSTITUTE, page 67
4.
Formulas->Function Library->Date & Time->MONTH, page 69
5.
Formulas->Function Library->Date & Time->NETWORKDAYS, page 71
6.
Formulas->Function Library->Financial->PMT, page 79 |
|
|
|
