We read your photo as:

Explain how "Test 1 Percentage" and "Top Achievers" are determined based on the provided spreadsheet data.

Business/Management

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%\ge 90\%, so "GODFREY" is displayed.
    • Mandla has 75%, which is <90%< 90\%, so "NOT THERE YET" is displayed.
    • Nkhesani has 91%, which is ≥90%\ge 90\%, so "NKHESANI" is displayed.
Was this helpful?

Still stuck on this one?

Ask a follow-up, and the answer starts from this question.

Got a different question?Ask your own question
Handwritten step-by-step solution preview

Handwritten Step-by-Step Solution

Get this as a handwritten image on WhatsApp — like a tutor wrote it for you.

Try on WhatsApp