Use formulas to format and modify TEXT,
DATE, and TIME. Use FINANCIAL formulas to calculate a car payment..
Brown Bag Sales Data 2010.xlsx
There is no Practice Activity for this lesson.
Review the Test Yourself questions on page 82.
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->MONTH,
page 69
5.
Formulas->Function Library->Date->NETWORKDAYS,
page 71
6.
Formulas->Function Library->Financial->PMT,
page 79 |
|
|
|
