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