Please send the link of spreadsheet/docsheet here as your answer because I need the link and the formula.

IL. ACTIVITY Activity Code: ICT 4.1 - PERFORMANCE TASK Instruction: On your Google Sheets (https://docs.google.com/spreadsheets), type all the given data below (inside the table) and follow the given instruction in 1.2 and 2.1. Share/send your activity to the email address of your respective subject teacher. 1., Consider this data: NAME GRADES MATH SCIENCE FILIPINO ENGLISH A.P MARK 75 70 78 81 73 PETE 84 87 86 88 85 ANA 91 92 95 90 90 REA 73 75 74 75 70 1.2. Give the formulas to get : 1. Mark's , Pete's, Ana's and Rea's averages 2. The remarks (Passed or Failed) 3. Sum of all Grade? 4. The highest grade that: Ana's got? 5. The lowest grade that Mark's got? 6. Sum of all Rea's Grades 7. The Lowest Number among all grades 2. Consider this data: FIRST NAME MIDDLE NAME LAST NAME MARK CURTIS WILLIAMS PETE MCCLOEY HARRISON ANA MONROE FRITZ REA TAN COLLINS 2.1. Give the formulas to get: 1. Mark's Full Name 2. Ana's Full Name in Proper Case 3. Count the number of letters that Pete's Last Name has 4. "COUL" from Rea's Last Name 5. "LOEY" from Pete's Middle Name 6. Combining "WILL" and "LINS" from Mark and Rea's Last Names respectively