Exp22_Excel_Ch07_CumulativeAssessment_Variation_Shipping | 100% Solution | @MyLabPearsonAcademy скачать в хорошем качестве

Exp22_Excel_Ch07_CumulativeAssessment_Variation_Shipping | 100% Solution | @MyLabPearsonAcademy

Contact WhatsApp: +923166321717 Email: [email protected] I am providing help in all online courses like Excel, Word, Access, PowerPoint, Accounting , Management Courses, Finance Courses, Computer Science Courses, Information Technology Courses, All Writing Assignments etc. I can do your Quizzes, Exams , Mid-Term, Final Exams. In short I can get you A grade in your courses. If you want me do your courses My WhatsApp number and Email is given you can contact me through that. Thanks. #excel #Exp22_Excel_Ch07_CumulativeAssessment_Variation_Shipping #Excel_Ch07_CumulativeAssessment_Variation_Shipping Exp22_Excel_Ch07_CumulativeAssessment_Variation_Shipping | Exp22 Excel Ch07 | Variation_Shipping #Exp22_Excel_Ch07_CumulativeAssessment_Variation_Shipping #Excel_Ch07_CumulativeAssessment_Variation_Shipping#Ch07_CumulativeAssessment_Variation#Excel_Ch07#Exp22_Excel_Ch07_CumulativeAssessment#Variation_Shipping#excel #Excel_Ch07_CumulativeAssessment #Ch07_CumulativeAssessmen#CumulativeAssessment_Variation #Exp22_Excel_Ch07#CumulativeAssessment_Variation_Shipping #Exp22_Excel_Ch07_Cumulative#CumulativeAssessment_Variation.xlsx #exp22 excel ch07 shipping Exp22_Excel_Ch07_Cum_HotTubs_Instructions.docx Project Description: You are a data analyst for Ultimate Hot Tubs, which has locations in five states. You want to analyze sample sales data and create a map to indicate sales by state. In addition, you want to create a loan amortization template that can be used to show customers. 1 Start Excel. Download and open the file named Exp22_Excel_Ch07_Cum_HotTubs.xlsx. Grader has automatically added your last name to the beginning of the filename. 2 Your first task is to use date functions to identify the day of the week each order was placed. In cell D2, insert the WEEKDAY function to return the serial number representing the weekday that the first hot tub was ordered (cell E2). Copy the function to the range D3:D12. 3 The result of the WEEKDAY function is a serial number. You will format it to display as a day of the week and left-align the results. Select the range D2:D12. Apply a custom number format dddd to display the actual weekday. Apply Left horizontal alignment. 4 You want to calculate the number of days between the order date and date the store received the hot tub. In cell G2, insert the DAYS function to calculate the number of days between the Date Ordered and Date Received for the first hot tub. Apply Center horizontal alignment. Copy the function to the range G3:G12. 5 Next you will use logical functions. First, you will use the SWITCH function to switch the codes PD and CR for Paid in Full and Credit, respectively. In cell C2, insert the SWITCH function to evaluate the first value in the Code column. Switch PD for Paid in Full and switch CR for Credit. Use text strings for the last four function arguments. Copy the function to the range C3:C12. 6 Now, you will issue a store credit toward cleaning supplies if orders took over 45 or 70 days as a goodwill gesture. In cell I2, insert the IFS function. Evaluate if the Days for the first hot tub order was greater than 70. If so, return $100. If the Days for the hot tub was greater than 40, return $50. Otherwise, return $0. Use cell references to the criteria thresholds and store credits located in the range H15:I16. Use relative and mixed references correctly. Copy the function to the range I3:I12. 7 Finally, you will create a nested IF function that displays Send Gift Basket for customers who bought either the Luxury or Serenity model and paid in full. In cell J2, insert an IF function with a nested AND function with a nested OR function. The function should display Send Gift Basket if these conditions are met: (1) the model was either Luxury or Serenity and (2) the hot tab was Paid in Full. If the conditions are false, use an empty text string "". Use text within the arguments and appropriate relative cell references. Copy the function to the range J3:J12. 8 Your assistant created a section for summary statistics below the main dataset. You will calculate the average number of days between the order and received dates. In cell B15, insert the AVERAGEIF function to calculate the average number of days for the Luxury model. Use mixed references to the range and criteria range. Use a relative reference to cell A15 that contains the model name. Do not type text as the criteria argument. Apply Number format with 0 decimal places and apply Center horizontal alignment. Copy the function to the range B16:B17 and preserve the existing border in cell B17. 9 In cell C15, insert the COUNTIF function to calculate the quantity of each hot tub model. Use mixed references for the range and a relative reference to the first model in cell A15. Apply Center horizontal alignment. Copy the function to the range C16:C17 and preserve the existing border in cell C17. 10 Now, you will identify the highest price for the Luxury hot tub model. In cell E15, ins