Text Formulas

Text as well as numbers can be edited by formulas. One useful Text function combines the data from several cells.

 

This function also has a cool name: Concatenate.

 

2. Try This: Make a Copy

Select the Original Data sheet.

Right click and make a Copy.

Name the new sheet: Text Functions.

 

And Try This: Add a Label

Select Cell F1.

Type: Product Revenue

 

Keep going....

Exam 77-882: Microsoft Excel 2010 Core

4. Managing Worksheets and Workbooks

4.1. Create and format worksheets: Move or Copy