Скачать или смотреть Exp19_Excel_Ch07_CapAssessment_Shipping | Excel Chapter 7 Assessment Shipping

#Exp19_Excel_Ch07_CapAssessment_Shipping_Simulation_Exam_Solution_Chegg_CourseHero_Quizlet_YouTubeVideo

To Get this Solution Contact us on Email and WhatsApp is given in Video
Email address: [email protected]


#Exp19_Excel_Ch07_CapAssessment_Shipping #CapAssessment_Shipping #Ch07_CapAssessment_Shipping #CapAssessment #Exp19_Excel_Ch07 #exp19_excel_ch07_capassessment_shipping #Ch07 #Exp19 #Shipping #exp19_excel_ch07_capassessment_shipping
#exp19excelch07capassessmentshipping #exp19 excel ch07 capassessment shipping#Exp19_Excel_Ch07_CapAssessment_Shipping.xlsx
#excel_chapter_7_capstone_assessment_shipping#shipping #Exp19_Excel_Ch07_CapAssessment_Shipping #CapAssessment_Shipping #Shipping.xlsx #Excel #Ch07_Shipping.xlsx #Shipping #CapAssessment #Exp22 #CapAssessment_Shipping #Exp19
#Exp19_Excel_Ch07_CapAssessment_Shipping.xlsx #Ch07 #CapAssessment #Ch07_Shipping#Ch07_Shippin #Exp19_Excel_Ch07_Shipping #Exp19_Excel_Ch07_CapAssessment_Shipping #Excel_2022_Project #Ch07_CapAssessment_Shipping #Excel_Shipping
#Excel_2019_Project #Exp19_Excel_Ch07_CapAssessment_Shipping #Exp19_Excel #Exp19_Excel_Chapter07_CapAssessment_Shipping
#Exp19_Excel_Ch07_CapAssessment_Shipping.xlsx#capassessment_shipping #ch07_capassessment_shipping #exp19_excel_ch07
#exp19_excel #exp19 #capassessment #exp19_excel_ch07_capassessment #Shipping #Capstone #ch07

Steps to Perform:
Step Instructions Points Possible
1 Start Excel. Download and open the file named Exp19_Excel_Ch07_CapAssessment_Shipping.xlsx.


In cell D7, insert the appropriate date function to calculate the number of days between the Date Arrived and Date Ordered. insert the SWITCH function to evaluate the airport code in cell E7. Include mixed cell references to the city names in the range F2:F4. Use the airport codes as text for the Value arguments. insert the IFS function to identify the shipping cost based on the airport code and the applicable shipping rates in the range G2:G4. Use relative and mixed references correctly. insert an IF function with a nested AND function to determine shipping refunds. The AND function should ensure both conditions are met: Total Days is grater than Total Days Delivery Goal (cell C3) and Order Total is equal to or greater than Order Total Threshold (cell C2). If both conditions are met, the refund is 50% (cell C4) of the Shipping Cost. Otherwise, the refund is $0. Use mixed references as needed.
insert the COUNTIF function to count the number of shipments for Austin (cell B1). Use appropriate mixed references to the range argument to keep the column letters the same. insert the SUMIF function to calculate the total orders for Austin (cell B1). Use appropriate mixed references to the range argument to keep the column letters the same.
insert the AVERAGEIF function to calculate the average number of days for shipments from Austin (cell B1).
insert the COUNTIFS function to count the number of orders where the Airport Code is IAH and the Order Total is greater than $1,000. 2.5
10 In cell C8, insert the SUMIFS function to calculate the total orders where the Airport Code is IAH and the Order Total is greater than $1,000. 2.5
11 In cell C9, insert the MAXIFS function to return the highest order total where the Airport Code is IAH and the Order Total is greater than $1,000
12 On the Map worksheet, insert a map for the states and revenues.
13 Format the data series to show only regions with data and show all map labels. 2.5
14 Change the map title to April 5-9 Gross Revenue.
In cell F2, insert the IPMT function to calculate the interest for the first payment. Copy the function to the range F3:F25.
16 In cell G2, insert the PPMT function to calculate the principal paid for the first payment.
17 In cell H2, insert a formula to calculate the ending principal balance.
insert the CUMIPMT function to calculate the cumulative interest after the first two years.
19 In cell B11, insert the CUMPRINC function to calculate the cumulative principal paid at the end of the first two years. insert the RATE function to calculate the necessary monthly rate given the NPER, proposed monthly payment, and loan. insert a formula to calculate the APR for the monthly rate in cell B15.
22 Insert a footer

#Exp19_Excel_Ch07_Cap_Real_Estate
#Exp19_Excel_Ch07_HOEAssessment_Employees
#Exp19_Excel_Ch07_ML1_Admissions
#Exp19_Excel_Ch07_ML2_Finances
#Exp19_Excel_Ch07_CapAssessment_Shipping
#Exp19_Excel_Ch08_HOEAssessment_Robert's_Flooring
#Exp19_Excel_Ch08_ML1_Portfolio_Analysis
#Exp19_Excel_Ch08_ML2_Reading_Scores
#Exp19_Excel_Ch08_CapAssessment_Employee_Satisfaction
#Exp19_Excel_Ch08_Cap_Golden_State_5K
#Exp22_Excel_Ch07_ML1_RealEstate
#Exp22_Excel_Ch07_ML2_Employees
#Exp22_Excel_Ch07_CumulativeAssessment_Variation_Shipping
#Exp22_Excel_Ch07_HOE_Salaries
#Exp22_Excel_Ch07_Cum_HotTubs