Determine the net present value of a new equipment purchase.
Click the Financials sheet tab and select cell H5.
Use NPV with a Rate argument of 4.25%.
Select cells D7:D13 for the Value1 argument and click OK. This is the same as entering each value argument separately.
Edit the formula to add both costs (cells D4 and D5) at the end of the formula. The net present value is $268,921.79.
Use TRANSPOSE and CONCAT to display technician names.
Click the Technicians sheet tab. The names are in rows.
Select cells A4:A10, seven rows in one column.
Select TRANSPOSE from the Lookup & Reference category and select cells A1:G1 for the Array argument.
Press Ctrl+Shift+Enter to complete the array formula.
Repeat the TRANSPOSE task for the first names in cells B4:B10.
Select cell D4 and create a CONCAT formula to display the name in first name, last name order (Figure 6-111).
The CONCAT formula displays the names in first name, last name order.
Figure 6-111 CONCAT formula to display names
Copy the formula in cell D4 to cells D5:D10.
Click the Summary sheet tab, select cell A5, and create a 3D reference to cell D4 on the Technicians sheet.
Copy the formula and preserve the borders.
Use SUMIFS to total number of patients by procedure and technician.
Click the Summary sheet tab and select cell C5.
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_range1 argument is an absolute reference to the image type column on the Procedures sheet, cells $E$5:$E$41.
The Criteria1 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.
Select cell A5 for the Criteria2 argument (Figure 6-112).SUMIFS with absolute and relative references
Figure 6-112 SUMIFS with absolute and relative references
Copy the formula in cell C5 to cells C6:C11 and preserve the borders.
Use SUMIFS to total number of patients by category and location in cells C14:C15.
Look for and correct format inconsistencies.
Calculate procedure times.
Click the Times sheet tab and select cell F6.
Build a formula to subtract the start time from the end time and multiply those results by 24. The result is shown in hours.
Copy the formula to row 41.
Select cells F6:F41 and open the Format Cells dialog box. On the Number tab, choose Fraction with a Type of Up to two digits (Figure 6-113).A time of 1.5 hours displays as 1 ½ hours.
Figure 6-113 Change time format to display fractions
Save and close the workbook (Figure 6-114).
Completed worksheets for Excel 6-6
Our assignment help service offers the best quality assistance at the lowest prices in the market. You can rely on us to provide you with exceptional support for all your academic needs.
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
