Question

On the CallCenterReport worksheet, add formulas that will summarize the issues for the department entered in cell B3. In cell B6, add an INDEX function that will use an INDIRECT function to retrieve the department issue list for the department listed in cell B3. Use an absolute reference to B3, and then use a relative cell reference to A6 as the row_num argument. Copy the formula down to cell B9.

Answer 1

In cell B6, formula =INDEX(INDIRECT($B$3),A6)

CallCenter Worksheet Details:

The image of the CallCenter Report worksheet for reference to the question asked is attached below.

Step-by-step explanation:

Firtsly, an absolute reference in Excel refers to a reference that is "locked" so that rows and columns won't change when copied. To do this,we put a $ dollar sign ( =A$1,) before the row coordinate to lock only the row.

A relative reference in Excel is a cell address without the $ sign in the row and column coordinates example A1.

Having known what absolute and relative reference are, we wlil write the below formula in cell B6 that will later be copied to cell B9:

: =INDEX(INDIRECT($B$3),A6)