|
The next
lesson demonstrates the TEXT functions.
Each example creates a Cell Reference, and uses
Arguments to create the formulas.
The TEXT
functions include:
CONCATENATE
(combining fields)
UPPER/LOWER
SUBSTITUTE
1. Before You Begin: Open the
file:
Counting
Chickens 2010.xlsx.
There should be a spreadsheet called Original Data for
TEXT Formulas.
File->Open
Exam 77-888: Microsoft Excel Expert
2010
2. Applying Formulas and Functions
2.4. Apply functions in formulas:
TEXT Functions |
|
| |
