Question 1: Copy the data in three different pages after answering part (3) in this question On the first page: 1) Insert a comment in cell G2 and type in total = quantity purchase price and copy the comment on all cells in column G. 2) freeze the First row (row # 1) 3) in column G Find total purchases (total = quantity purchase price). Question 2: 1) Using conditional formatting to shadow records according to field name (for example shadow records ali) 2) Draw scatter plot between the quantity variable on the x-axis and the total variable on the y - axis, indicating the following: - Coefficient of determination , what it means - linear regression equation of the total variable on quantity. Question 3: 1)Use advanced filter to Filtering the records purchased by the client Khaled for the keyboard class and filtering in cell A 22 2) Find total purchased quantities and total purchases for each item of goods

Please attach the solution to an excel file