B:USHEN&A? KVKIVLJ; & in rows

Question

c. Select TRANSPOSE from the Lookup & Reference category and select cells A1:G1 for the Array argument.

d. Press Ctrl+Shift+Enter to complete the array formula.

e. Repeat the TRANSPOSE task for the first names in cells 84:810.

1. Select call D4 and create a CONCAT formula to display the name in first name, last name order (Figure 6-111).

Figure 111 CONCAF form to displays

g.Copy the formula in cell D4 to cells D5 D10.

h. Click the Summary sheat tab, select call A5, and create a 3D reference to call D4 on the Technicians sheet.

1.CCopy the formules and preserve the borders,

4. Use SUMIFS to total number of patients by procedure and technician.

a. Click the Summary sheet tab and select cell C5.

b.

Use the SUMIFS function with an absolute reference to cells $D$5:$D$41 on the Procedures sheet as the

Sum_range argument.

The Criteria_range argument is an absolute reference to the image type column on the Procedures sheet, cells

SESSISES41.

The Criteria argument is a relative reference to cell B5 on the Summary sheet.

• The Criteria_range2 argument is an absolute reference to the technician names column on the Procedures

sheet.

c.Select cell As for the Criteris argument (Figure 6-112).

d. Copy the formula in cell CS to cells CB:C11 and

preserve the bordan

5.Use SUMS to total number of patients by category and

location in cells C14:C15

6.Look for and correct format inconsistencies.

7. Calculate procedure times.

a.Click the Times sheet tab and select cell F6,

b. Build a formula to subtract the start time from the end

time and multiply those results by 24. The result is shown

in hours.

c.copy the formula to row 41.

d. Select calls F6F41 and open the Format Calls dialog box. On the Number tab, choose Fraction with a Type of Up

to two digits (Figure 6-113).

8.0 Save and close the workbook (Figure 6-114).

Figars 5-112 SUMNS with back and relative references

Figure 6-113 Change times format to display fractions

00000

@

00

0