Answer to Question #276246 in Excel for Ntgg

Question

Section A    [40]

Part 1: Use Data in “Student Marks” Sheet

1. Use a formula (not a function) to calculate the Final ICA of Students. [2]
2. Use a function to test if there is a student who scored a 100 on one of the internal assessments. [2]
3. Use the “IF” function to assign students a Status based on the following; Proceed (if final ICA is 50 or more), Supplement (if final ICA is between 30 and 49) or Retake (if final ICA is 29 or less).     [6]
4. Count the number of students who are proceeding using “count-if” function                [4]
5. Count all none empty cells from cell A2 to cell F7 using a function.  [2]
6. Use v-lookup function to return Int2 Marks of Dkay Reed.        [2]
7. Use H-lookup function to return the name of a Student who got 45 on Int3 assessment. [2]

Answer 1

Dear Ntgg, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order