Exam 77-420 Microsoft Excel 2013
1. Create and Manage Worksheets and Workbooks
1.1 Create Worksheets and Workbooks: Copy and Move Worksheets

graphc2
graphic1
 

 

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....