In a worksheet, the marks scored by ten students are stored in cell B3 to B12. i) In cell C3, show an expression you would use...

      

In a worksheet, the marks scored by ten students are stored in cell B3 to B12.
i) In cell C3, show an expression you would use to obtain positions of the students using marks scored in descending order
ii) In cell B13, write an expression you would use to extract the highest score from the marks

  

Answers


Kavungya
i)= RANK ( & B & 3 : & B & 12,O)
ii)= Max ( B3 : B12)
Kavungya answered the question on April 17, 2019 at 13:46


Next: Give two reasons why hardwood trees species in Kenya are in danger of extraction
Previous: The diagram below shows a simple fold.

View More Computer Studies Questions and Answers | Return to Questions Index


Exams With Marking Schemes

Related Questions