Mark the steps as checked when you complete them.

Open the ClemensonImaging$-06$ workbook and click the Enable Editing button. The file will be renamed

automatically to include your name.

Determine the net present value of a new equipment purchase.

a$.$

Click the Financials sheet tab and select cell H$5.$

b$.$

Use NPV with a Rate argument of $4\mathrm{.}25\%.$

C$.$

Select cells D$7$:D$13$ for the Valuet argument and click OK$.$ This is the same as entering each value argument

separately.

d$.$

Edit the formula to add both costs $($cells D$4$ and D$5)$ at the end of the formula. The net present value is

$$268,921\mathrm{.}79.$

Use TRANSPOSE and CONCAT to display technician names.

a$.$

Click the Technicians sheet tab. The names are in rows.

b$.$

Select cells A$4$:A$10,$ seven rows in one column.

c$.$

Select TRANSPOSE from the Lookup & Reference category and select cells A$1$:G$1$ for the Array argument.

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

e$.$

Repeat the TRANSPOSE task for the first names in cells B$4$:B$10.$

Select cell D$4$ and create a CONCAT formula to display the name in first name, last name order $($Figure $6-$

$.$