Working with Sales Worksheet

How do I join Description and Style from the Catalog worksheet in cell B4 on the Q1 Sales worksheet?

What function should I insert and what steps should I follow?

Answer:

To join Description and Style from the Catalog worksheet in cell B4 on the Q1 Sales worksheet, you need to insert the CONCATENATE function and follow these steps:

1. On the Q1 Sales worksheet, select cell B4.

2. Click the FORMULAS tab and click Insert Function.

3. In the Search for a function field, type the keyword "Join" and then click GO.

4. In the Select a function field, choose CONCATENATE. Click OK.

5. In the Function Arguments pop-up window for CONCATENATE, do the following:

a. Click in the Text1 field.

b. Click the Catalog worksheet tab. In the Description column, select cell D4.

c. Click in the Text2 field and type a set of quotes containing a space, a hyphen, and a space - " -.

d. Click in the Text3 field.

e. Click the Catalog worksheet tab. In the Style column, select cell C4.

f. Click OK to complete the process.

6. You have now successfully joined Description and Style from the Catalog worksheet in cell B4 on the Q1 Sales worksheet.