Exam 77-420 Microsoft Excel 2013 4. Apply Formulas and Functions 4.4 Format and Modify Text with Functions: CONCATENATE

Formulas -> Function Library-> Text ->Concatenate Text Formula Options This formula combines two cells: B2, the name of the Product, with E2, the calculated revenue.   4. Try It: Edit the Text Function Start by entering the cell references.   Edit Text1: B2 Edit Text2: D2 Click OK to CLOSE the Function Arguments.   What Do You See? The formula is =CONCATENATE(B2,D2)   This TEXT formula did, indeed, combine the fields. However, this result needs some improvements. Keep going...