Answer to Question #276246 in Excel for Ntgg

Question #276246

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]






1
Expert's answer
2021-12-08T18:59:42-0500
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

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be the first!

Leave a comment

LATEST TUTORIALS
New on Blog
APPROVED BY CLIENTS