PLEASE HELP WITH ALL QUESTIONS - step by step in EXCEL

PLS & thanks! will upvote as well thx

6 In cells B22:B24, using named ranges, create functions that count the number of students if their year in school matches the years listed in A22:A24. In cells C22:C24, using named ranges, create functions that total the number of volunteer hours if their year in school matches the years listed in A22:A24. In cells C25:C26, using named ranges, create functions that total the number of volunteer hours if the criteria AA26:A27 is met. 7 In cell A38, type Totais. Create a formula in cells B38: E38 to find the total sum for the Value, Donated, Desktops, and Laptops columns respectively. 8 In cell F33, create an IF function that evaluates the total number of computers donated from Safety Inc. If a minimum of 30 computers have been donated, the function will return Goal Met. If fewer than 30 computers are donated, the function will return Under Goal. Use AutoFill to copy the function to cell range F34:F37