Скачать или смотреть Exp19_Excel_Ch02_Cap_Appliances | Excel Ch02 Cap Appliances | @myitlabsolutions161

#Exp19_Excel_Ch02_Cap_Appliances
#Exp19 Excel Ch02 Cap Appliances

Contact Me For Help in Your Assignments and Courses

WhatsApp: +923035618174
Email : [email protected]

We offer comprehensive support for a wide range of online courses including Business and Management, Business and Finance, Business and Accounting, Human Resource Management, History, English, Literature, Nursing, Psychology, Statistics, Information Technology, Applied Sciences, Computer Science, and more. Our services include assistance with weekly quizzes, assignments, exams, thesis and dissertation writing, as well as proficiency in specific courses like MyITLab, Microsoft Word, Microsoft PowerPoint, Microsoft Excel, and Microsoft Access.


To complete the Exp19_Excel_Ch02_Cap_Appliances project, follow these steps:

Open the File:

Start Excel.
Download and open the file named Exp19_Excel_Ch02_Cap_Appliances.xlsx (with your last name added).
Insert Date:

In cell B2, insert the function =TODAY().
Format cell B2 as Long Date.
Autofit Column Width:

Autofit the width of column B.
Lookup Item Names:

In cell C5, insert a function to look up the item names based on the inventory. This might use a formula like =VLOOKUP(A5, InventoryRange, 2, FALSE).
Drag the formula down from C5 to C13.
Autofit Column Width:

Autofit the width of column C.
Lookup Item Prices:

In cell E5, insert a function to look up item prices. This might be similar to the item names lookup but with the price column.
Drag the formula down from E5 to E13.
Format Prices:

Apply Currency Number Format with two decimal places to column E.
Calculate Total Due:

In cell F5, use an IF function to calculate the total due considering the delivery charge. For example, =E5 + IF(B5="Home Delivery", $B$25, 0).
Drag the formula down from F5 to F13.
Apply Currency Number Format with two decimal places to column F.
Calculate Monthly Payments:

In cell H5, use a formula to calculate the first customer’s monthly payment. This might involve dividing the total due by the number of months.
Ensure the result is positive. For example: =ABS(F5/NumberOfMonths).
Drag the formula down from H5 to H13.
Total Monthly Payments:

In cell H14, use a formula like =SUM(H5:H13).
Apply Currency Number Format with two decimal places to cell H14.
Additional Calculations:

H18: Total number of orders with =COUNTA(A5:A13).
H19: Lowest monthly payment with =MIN(H5:H13).
H20: Average monthly payment with =AVERAGE(H5:H13).
H21: Highest monthly payment with =MAX(H5:H13).
H22: Median monthly payment with =MEDIAN(H5:H13).
Apply Currency Number Format with two decimal places to the range H19
.
Insert Footer:

Insert a footer with your name on the left, the sheet name in the center, and the file name on the right.
Save and Close:

Save and close the file. Submit as directed.
Good luck with your project! Let me know if you need help with any specific step.