Use a formula (not a function) to calculate the Final ICA of Students. [2]
Use a function to test if there is a student who scored a 100 on one of the internal assessments. [2]
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]
Count the number of students who are proceeding using “count-if” function [4]
Count all none empty cells from cell A2 to cell F7 using a function. [2]
Use v-lookup function to return Int2 Marks of Dkay Reed. [2]
Use H-lookup function to return the name of a Student who got 45 on Int3 assessment. [2]
1
Expert's answer
2021-12-08T18:51:46-0500
Dear Tttt, 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
Numbers and figures are an essential part of our world, necessary for almost everything we do every day. As important…
APPROVED BY CLIENTS
"assignmentexpert.com" is professional group of people in Math subjects! They did assignments in very high level of mathematical modelling in the best quality. Thanks a lot
Comments
Leave a comment