Can you help me find the solution please? Thank you so much. The excel part is not necessary but need help finding solution and hypothesis test. etc

A researcher has conduct a study on 10 subjects to determine if a new print ad increases a viewer's1 appeal rating for their product. Scores are obtained on the subjects (using a proprietary tool) both before and after viewing the ad. Data is provided below. Prepare a well formatted and neatly labeled Excel worksheet and the usual hypothesis test procedure to assess the effectiveness of the ad. Data A A l B | c | D 1_ Participant Before After 2_1 19.32 8.4 3 2 13.23 10.19 43 12.39 14.07 i4 23.52 22.34 6 5 10.92 17.34 76 8.4 11.91 {7 10.19 12.75 9_ 8 38.1 44.2 10 9 40.3 40.0 1? 10 19.33 18.44