This business/management problem is solved step by step below, with detailed explanations to help you understand the method and arrive at the correct answer.
ScanSolve AI Answer
Based on the provided spreadsheet: 1. Test 1 Percentage: The "TEST 1 PERCENTAGE" is derived directly from the "TEST 1 MARK". It appears that the numerical value of the mark is simply displayed with a percentage sign appended, rather than being calculated as a percentage out of the "TOTAL POSSIBLE MARK" of 110. Example: For Godfrey, the "TEST 1 MARK" is 95, and the "TEST 1 PERCENTAGE" is 95%. 2. Top Achievers: The "TOP ACHIEVERS" column displays the student's name if their "TEST 1 PERCENTAGE" (which is their mark) is 90% or higher. If the percentage is below 90%, it displays "NOT THERE YET". Example: Godfrey has 95%, which is 90\%, so "GODFREY" is displayed. Mandla has 75%, which is < 90\%, so "NOT THERE YET" is displayed. Nkhesani has 91%, which is 90\%, so "NKHESANI" is displayed.